Historical data

Sales order

This part of Global Sales is used to have the historical data (last 3 years) for:

• Sales orders
• Schedule lines
• Delivery
• Shipment
• Billing

Sales documents types

Sales order

All the sales documents types are in the historic. Regarding the sales document type, a sales order line can be in one of the categories below:

• Sales
• Return
• Consignment
• Credit/Debit memo

The categories are stored in the object C_DOCTYP2 with the attribute C_GRPDOC. The attribute is updated manually.

IMPORTANT: This concept of categories isn't standard. It was created for Global Sales.

Delivery

All the delivery types are in the historic. Nothing is done to group the delivery type.

Billing

All the billing document types are in the historic. Regarding the billing document type, a billing line can be in one of the categories below:

• Sales
• Pro Format
• Inter-company

The categories are stored in the object C_BILLTYP with the attribute C_BILLCL. The attribute is updated manually.

IMPORTANT: This concept of categories isn't standard. It was created for Global Sales. An exclusion is done between the propagation layer and the business to don't have the billing Pro-format..

Data flow

The data flow is based on the LSA method. The data visualization is done on the multiproviders:

• MVSDSO44 (MP: Global Sales) for the aggregated queries.
• MVSDSO45 (MP: Detail Jump Query) for the detailed queries.

Global Sales data layers:

• Propagation Layer
• Business Layer
• Reporting Layer
• Virtual Layer
• Master Data

See the data flow of the multiprovider MVSDSO44 (MP: Global Sales) :

See the data flow of the multiprovider MVSDSO45 (MP: Global Sales) :

Propagation layer

List of infoproviders used by the Historical data:

Technical point: We never use the propagation layer for reporting. No SIDs are generated in the propagation layer.

Business layer

List of infoproviders used by the Historical data:

Reporting layer

List of infoproviders used by the Historical data:

Virtual layer

List of infoproviders used by the Historical data:

Data update

IMPORTANT: The same process chain is used to update the Sales order and the Historical sales data.

The processes chains below are used to update the multiproviders MVSDSO44 and MVSDSO45

For Solvay:

• SD - Main Process Chain - UPDATE DATA - (PC_SD_MAIN)
  • SD - Propagation Update (PC_SD_PROPAG)
  • SD - Business Layer (Solvay) (PC_SD_BUSINESS_LAYER)
  • Global Sales: Reporting layer (PC_Global Sales_REPORTING)

For Rhodia:

• PC: Global Sales: Main (Rhodia) - (PC_GLOBAL_SALES_MAIN)
  • Global Sales: Propagation Layer (Rhodia) (PC_GL_SALES_PROP_01)
  • Global Sales: Business Layer (Rhodia) (PC_GL_SALES_BUS02)
  • Global Sales: Reporting Layer (Rhodia) (PC_GL_SALES_REP02)

Reporting

The reporting is based on Core workbooks based on Core queries.

The core workbooks give an aggregated view, to have information on the documents detail jumps are done.

IMPORTANTE: The core queries are not published on the role menu. Only the workbooks are published on the role menu, folder Historical data.

Core queries

The core queries are used to build the workbooks and to have the detail at the documents lines level (jumps).

IMPORTANT: The calendar Year/month corresponding to:

• the last requested GI date for the sales orders part.
• the actual Gi date for the sales deliveries part.
• the billing document date for the billing part.

BW Queries Feeding QV Queries 

1. QV_BW_QRY_MVSDSO45_SD0001  -    C_DOCNUMB_C_CUSTGR2 ia added to Rows as a part of change.

PO's transfers

Puchase order documents types

All the rules used in Global Sales were determined by SAP experts.

IMPORTANT:

Solvay:

• PO's types UB and NB, the vendor must to be flagged as intra-group. Exception is done for purchase organization. The exception is done with the technical object C_POSD.

Rhodia:

• PO's types UB and NB, the purchase organization 3200 is used for the type UB. The purchase organization 3001 to 3008, 3200 and 3400 are used for the type NB.
  
  
  

Purchase order

Global Sales uses the data coming from SPRINT to have the PO's transfers order.

Delivery

The deliveries are coming from the DSO DBSDSO29 "PO Global: Transfers orders delivery (Solvay)".

The deliveries are coming from the DSO DBSDSO69 "PO Global: Transfers orders delivery (Rhodia)".

Billing

The billing are coming from the DSO DBSDSO27 "PO: Transfers orders Invoices (Solvay)".

The billing are coming from the DSO DBSDSO67 "PO: Transfers orders Invoices (Rhodia)".

IMPORTANT:

• Transfers done with the PO type UB is always done between the same GBU.
• Transfers done with the PO type NB is always done between Solvay's entities.

Master data

The master data used, is the master data of SPRINT, with the object C_PO_ITM (Purchase Order Item). Please refer to SPRINT documentation for more detail.

Data flow

The data flow is based on the LSA method. The data visualization is done on the multiproviders MVSDSO42 (MP: Global PO (Global Sales)) and MVSDSO43 (MP: Detail PO Jump (Global Sales)).

Global Sales data layers:

• Propagation Layer
• Business Layer
• Reporting Layer
• Virtual Layer

See the data flow of the multiprovider MVSDSO42 (MP: Global PO (Global Sales)):

See the data flow of the multiprovider MVSDSO43 (MP: Detail PO Jump (Global Sales)):

Propagation layer

IMPORTANT: To build the PO's transfers order book, we use data coming from the propagation of SPRINT.

List of infoproviders used by the PO's transfers order book:

Business layer

List of infoproviders used by the PO's transfers order book:

Reporting layer

List of infoproviders used by the PO's transfers order book:

Virtual layer

List of infoproviders used by the Historical data PO's transfers:

Data update

Process chain

IMPORTANT: The same process chain is used to update the PO's (transfers) order book and the Historical PO's (transfers) data.

The processes chains below are used to update the multiproviders MVSDSO42 and MVSDSO43 :

PF1:

• Global Sales: Transfers Orders Main chain (PC_OBAS_TRANSFERS_MAIN)
  • Global Sales: Business Layer Transfers Orders (Solvay) (PC_OBAS_TRANSFERS)
  • Global Sales: Reporting Layer Transfers Orders (PC_OBAS_TRANSFERS_ODB)

WP1:

• PC: Global Sales: Main transfers (Rhodia) (PC_GL_SALES_MAIN_PO)
  
  • Global Sales: PO Transfer business layer (Rhodia) (PC_GL_SALES_PO_BUSINESS)
  • Global Sales: Transfers Reporting layer (Rhodia)(PC_GL_SALES_PO_REPORTING)
  • SD - Global Sales: Transfer OTIF w/ Orderbook (Rhodia) (PC_GL_SALES_DBSDSO9E)
  • Global Sales: CRSDSO70 (SO OTIF w/order book) (Rhodia) (PC_GL_SALES_CRSDSO70)

Reporting

CORE QUERIES

The core queries are based on the multiproviders MVSDSO42 and MVSDSO43.