General presentation
Objective of the application
Develop a new reporting solution for Sales & Distribution data coming from SAP/ERP/PF1 with a first deliverable the ORDER BOOK REPORT (Sold & Pending).
Detail on: Sales Orders, Purchase Orders (transfers), Sales Order Lines, Schedule Lines,Deliveries, Invoices.
Innovation: Process Core Rules integrated to the Order Book Report, generating 2 views:
- Order Book Business View: Determine for each sales order item when it will BE INVOICED, so determine the best estimation for the billing date → FOCUS: BUSINESS / TOP MANAGEMENT / FINANCE
- Order Book to Be Issued: Determine for each sales order item when it will be issued, so determine the best estimation when the product will leave the plant → FOCUS SUPPLY CHAIN TEAM
Usage information
History
Roles & Access
Roles and access
Two roles were created for OBAS. The first one is the application role and the other one is the role menu.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZBI_RCS_SD_A01 | Application role for OBAS project / SD data / Orderbook | Role for the application |
| ZR_RCS_CA_M49 | SD - Sales and Distribution | Role menu for the application |
Authorization objects
The authorization is done regarding the BFC GBU, the legal company and the sales office.
| Authorization object | Explanation |
|---|---|
| CPFCTR1_2 | GBU |
| C_COMPCDE | Legal company |
| C_SAL_OF | Sales office |
Order book
Sales order book
Sales Order Book is a presentation in a detailed level of all sales orders placed in SAP/PF1 system, being possible to determine:
- Sales order on going and open
- Sales Orders Shipped Not Billed
- Sales Orders invoiced
The sales order book is defined at most detailed level. That means at the schedule line level. The concept of line is very important to understand how the order book. Each sales document can generate an item, the combination of the document number / item number is a line.
To generate the sales order book the documents line below is used:
- Order line
- Schedule line
- Delivery line
- Billing line
- Schedule line
Document line generation:
- Each sales order document can generate n order line.
- Each scheduled line can generate n delivery document.
- Each delivery document can generate n delivery line.
- Each delivery line can generate n billing document.
- Each Billing document can generate n billing line.
Comment: OBAS doesn't use the shipment line. The mandatories informations are at the shipment header level.
Core rules
All the rules used in OBAS were determined by SAP experts.
IMPORTANT:
- The sales order book excludes the order line which has a rejection code.
- The sales order book is defined at the most detailed level (the schedule line).
- Order line classification: An order line can be in one of the three class:
- If the country of legal company is diference than the country of plant.
- If the transportation mode is "SEA" (Export).
- The others cases
Order line status
- The status of the order line (from SAP) is not used in OBAS.
It's because in PF1, an order line is with the status "C" (completed). When the deliveries regarding the total confirmed quantity of the order line is planned or issued .
To be invoiced date
The to be invoiced date is used to know when an order line will be billed. This concept is used in the order book for the Open order and the Shipped but not billed part.
Important: the to be invoiced date can be calculated only if the type of sales order will generate a delivery document. That means the credit/debit memo are not included in the Open order and the shipped but not billed part. The returns are not considered in the Open order and shipped but not billed part.
The to be invoiced date is calculated by use the more update document in the document flow.
- More updated document:
- The shipment document.
- The delivery document.
- The sales order document at the schedule line level.
Regarding the order line classification, the to be invoiced is calculated following the rules below:
- If the order line classification is "1" (the country plant is diference than the ship-to country):
- If a shipment document exist. To be invoiced date = shipment end date (planned or actual)
- If a delivery document exist with an actual GI date, but no shipment document. To be invoiced date = the actual GI date + transit time.
- If a delivery document exist without an actual GI date, but no shipment document. To be invoiced date = the planned GI date + transit time.
- If the delivery document not exist. To be invoiced date = the scheduled GI date of the order line (at the schedule line level) + transit time.
- If the order line classification is "2" (the transportation mode = "SEA" (Export)):
- If a shipment document exist. To be invoiced date = shipment start date (planned or actual)
- If a delivery document exist with an actual GI date, but no shipment document. To be invoiced date = the actual GI date.
- If a delivery document exist without an actual GI date, but no shipment document. To be invoiced date = the planned GI date.
- If the delivery document not exist. To be invoiced date = the scheduled GI date of the order line (at the schedule line level).
- If the order line classification is "3" (the others cases):
- If a shipment document exist. To be invoiced date = shipment completion date (planned or actual)
- If a delivery document exist with an actual GI date, but no shipment document. To be invoiced date = the actual GI date.
- If a delivery document exist without an actual GI date, but no shipment document. To be invoiced date = the planned GI date.
- If the delivery document not exist. To be invoiced date = the scheduled GI date of the order line (at the schedule line level).
WARNING: A shipment document can be created without the shipment dates. If this case appears, the shipment document will be ignored in the determination of the to invoiced date.
To be issued date
The to be issued date is used to know when an order line will be billed. This concept is used in the order book to be issued for the Open order and the Shipped but not billed part.
Important: like the to be invoiced date, the to be issued date can be calculated only if the type of sales ordert will generate a delivery document. That means the credit/debit memo are not included in the Open order and the shipped but not billed part. The returns are not considered in the Open order and shipped but not billed part.
The to be issued date is calculated by use the more update document in the document flow.
- More updated document:
- The delivery document if the quantity is issued.
- The shipment document.
- The delivery document if the quantity is not issued.
- The sales order document at the schedule line level.
To calcul the to be issued date we use the rules with the hierarchy below:
- If a delivery document exist with an actual GI date. to be issued date = the actual GI date.
- If a shipment document exist, and the delivery is not issued. to be issued date = shipment completion date (planned or actual).
- If a delivery document exist without an actual GI date. to be issued date = the planned GI date.
- If the delivery document not exist. to be issued date = the scheduled GI date of the order line (at the schedule line level).
WARNING: A shipment document can be created without the shipment dates. If this case appears, the shipment document will be ignored in the determination of the to issued date.
The rest to be delivered
The rest to be delivered is the quantity which need to be delivered to the customer to complete the requested quantity. The rest to be delivered is defined at the schedule line level. It is used in the Open order part, to determine the to be invoiced/issued quantities and the values. The calculation is done following the rules below:
- If the confirmed quantity = 0.
- The rest to be delivered = the schedule line quantity - ( the issued quantity + delivery tolerance)
- If the confirmed quantity <> 0.
- The rest to be delivered = the schedule line confirmed quantity - ( the issued quantity + delivery tolerance)
IMPORTANT: If the rest to be delivered is negatif, the quantity: rest to be delivered is forced to 0.
Not invoiced
Definitions
The notion of Not Invoiced (or not billed) is very importante to generate the order book. That will define the sales documents lines which are Open or Shipped not billed.
To know if a document line is invoiced or not (billed or not billed) 2 checks are done:
- The first check is done regarding a delivery line. If a billing document exist with reference the delivery line. The corresponding delivery line is billed (invoiced).
- The second check is done regarding the sales document line. If a billing document exist with reference, the sales order line. The corresponding order line is billed (invoiced).
IMPORTANTE: An order line can be partially billed.
Open order
Definitions
If a rest to be delivered exist for an order line. The order line is open.
Two cases:
- The order line is open and no delivery is planned.
- The order line is open and a delivery is planned.
Open order without planned delivery
This case appear when an order line was created, but no delivery is yet planned.
Example:
The order line 4268469/20 has no delivery created. This order line is at the beginning of the sales process.
Open order with planned delivery
This case appear when an order line was created, and delivery is planned.
Example:
The order line 4311472/20 has the delivery lines 87743333/10 and 87743333/900001 created.
The delivery is planned but the material is not yet issued. The order line 4311472/20 is open.
Shipped but not billed
Definition
Order line which has a delivery line with an issued quantity but the issued quantity is not yet billed.
Example:
The order line 4357166/10 has the deliveries lines 70367763/10 and 70367763/900001 created.
The material was issued, no billing exist for the delivery. The order line 4357166/10 is shipped not billed.
Billed
Definition
An order line is billed, when a billing line is created with reference document:
- the order line
- the order line's delivery
Example:
The order line 4204405/10 has a billing document created in reference of the delivery line. The order line is billed.
Master data
List of mater data:
| Technical name | Description |
|---|---|
| C_ITM_SD | Sales order item |
C_ROUTE | Route |
C_TRMODE | Transportation mode |
| C_SHIPCD2 | Shippment condition |
IMPORTANT: The object C_ITM_SD is critical due to it use to generate the order book.
Data flow
The data flow is based on the LSA method. The data visualization is done on the multiprovider MVSDSO01 (MP: Sales order book).
OBAS data layers:
- Propagation Layer
- Business Layer
- Reporting Layer
- Virtual Layer
- Master Data
The draw below represente the data flow of the multiprovider MVSDS01:
Click on the draw to enlarge.
IMPORTANT: The multiprovider MVSDSO01 (Sales Order Book) is also used by DYNASIS. The order book doesn't use data coming from DYNASIS.
Propagation layer
List of infoproviders used by the Sales order book:
| DSO tech. name | DSO description | DTS tech. name | DTS description | Comments |
|---|---|---|---|---|
| DPSDSO02 | Sales Document Item Data (Solvay) | 2LIS_11_VAITM | Sales Document Item Data | OBAS |
DPSDSO04 | Sales Document Order Delivery (Solvay) | 2LIS_11_V_SSL | Sales Document Order Delivery | OBAS |
| DPSD001 | Deliveries (Solvay) | 2LIS_12_VCITM | Delivery Item Data | OBAS |
| DPSDSO07 | Billing Document Item Data (Solvay) | 2LIS_13_VDITM | Billing Document Item Data | OBAS |
| DPSDTR22 | TR Prop: Shipments & Deliveries (Solvay) | 2LIS_08TRTLP | Shipment: Delivery Item Data per Section | From TIERS |
| DPSDTR28 | TR Prop: Shipments & Deliveries Status 1-4 (Solvay) | DTS_BW_SHIP_SBS | Extract Shipment doc overall status 1 to 4 | From TIERS |
Technical point: We never use the propagation layer for reporting. No SIDs are generated in the propagation layer.
For more detail on the propagation layer, click on this LINK.
Business layer
List of infoproviders used by the Sales order book:
| DSO tech. name | DSO description | source DSO tech. name | source DSO description |
|---|---|---|---|
| DBSDSO01 | SO: Not Invoiced (Solvay) | DPSDSO04 | Sales Document Order Delivery (Solvay) |
| BDSDSO11 | SO Global: Sales Document Item Data (Solvay) | DPSDSO02 | Sales Document Item Data (Solvay) |
| DBSDSO14 | SO Global: Deliveries (Solvay) | DPSD001 | Deliveries (Solvay) |
| DBSDSO06 | SO Global: Invoices (Solvay) | DPSDSO07 | Billing Document Item Data (Solvay) |
| DBSDSO18 | SO: OPEN ORDER W/O DLV DOC (Solvay) | DBSDSO01 | SO: Not Invoiced (Solvay) |
| DBSDSO17 | SO: OPEN ORDER WITH DLV DOC (Solvay) | DBSDSO01 | SO: Not Invoiced (Solvay) |
| DBSDSO16 | SO: SHIPPED NOT INVOICED (Solvay) | DBSDSO01 | SO: Not Invoiced (Solvay) |
DBSDSO09 |
SO global: Shipments status 1 to 7 (Solvay) | DPSDTR22 + DPSDTR28 | TR Prop: Shipments & Deliveries (Solvay) + TR Prop: Shipments & Deliveries Status 1-4 (Solvay) |
| DBSDSO10 | SO global: Deliveries and Shipment to the customer (Solvay) | DBSDSO09 | SO global: Shipments status 1 to 7 (Solvay) |
For more detail on the business layer, click on this LINK.
Reporting layer
List of infoproviders used by the Sales order book:
| CUBE tech. name | CUBE description | source DSO tech. name | source DSO description | Comments |
|---|---|---|---|---|
CRSDSO02 |
SO Order Book: OPEN ORDER+SHIPPED NOT INVOICED (Solvay) | DBSDSO16 + DBSDSO17 + DBSDSO18 | SO: SHIPPED NOT INVOICED (Solvay) + SO: OPEN ORDER WITH DLV DOC (Solvay) + SO: OPEN ORDER W/O DLV DOC (Solvay) | |
| CRSDSO01 | SO Order Book: Current month Invoices (Solvay) | DBSDSO06 | SO Global: Invoices (Solvay) |
For more detail on the propagation layer, click on this LINK.
Virtual layer
List of infoproviders used by the Sales order book:
| CUBE tech. name | CUBE description | source DSO tech. name | source DSO description | Comments |
|---|---|---|---|---|
MVSDSO01 |
MP: Sales order book | CRSDSO01 + CRSDSO02 + CRDYN12 + CRDYN11 | SO Order Book: Current month Invoices (Solvay) + SO Order Book: OPEN ORDER+SHIPPED NOT INVOICED (Solvay) + From SO - Devileries and Invoices + DYN - Reporting | OBAS
OBAS
DYNASIS
DYNASIS |
IMPORTANT: In the multiprovider MVSDSO01, they are data coming from DYNASIS (CRDYN11 and CRDYN12). These data are not used in the Order book.
For more detail on the propagation layer, click on this LINK.
Master data
List of master data used to generate the Sales order book:
| Object tech. name | Object description | source tech. name | source description | Comments |
|---|---|---|---|---|
| C_DOCNUMB | Sales document (with System ID) | DPFIAR06 | FIAR: Credit blocked by Credit Reasons - Solvay | To have the flag credit block (Historical and dynamique) |
C_ITM_SD
|
Sales document item | DBSDSO08 + DBSDSO11 + DBSDSO12 | SO Global: Sales Document Schedule Line (Solvay) + SO Global: Sales Document Item Data (Solvay) + SO global: Sales Document Item Status (Solvay) |
Is the more critical object. Used to generate the data flow. |
C_SHIPNU2 |
Shipment Number (Core) | DPSDTR21 + DPSDTR28 | TR Prop: Shipments header (Solvay) + TR Prop: Shipments & Deliveries Status 1-4 (Solvay) |
For more detail please see the TIERS documentation |
For more detail on the master data layer, click on this LINK.
Data update
Process chain
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 multiprovider MVSDSO01 (Sales order book):
- SD - Main Process Chain - UPDATE DATA - (PC_SD_MAIN)
- SD - Propagation Update (PC_SD_PROPAG)
- SD - Business Layer (Solvay) (PC_SD_BUSINESS_LAYER)
- OBAS: Reporting layer (PC_OBAS_REPORTING)
SD - Main Process Chain - UPTDATE DATA - (PC_SD_MAIN)
SD - Propagation Update (PC_SD_PROPAG)
SD - Business Layer (Solvay) (PC_SD_BUSINESS_LAYER)
OBAS: Reporting layer (PC_OBAS_REPORTING)
For more detail click on this LINK.
For detail on the processes chains of the master data, please refer to Concepts and Definitions
IMPORTANT: The sales order book is generated every day from scratch. No historic is done for the sales order book.
Loading frequency
The data is updated every day. The process chain start after the end of TIERS update.
Perfomance
General performance:
Detailed performance:
Reporting
The reporting is based on Core workbooks based on Core queries.
The core workbooks give an aggregated view (SNAPSHOT), 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 Order Book.
Data selection
Data selections are done at the query level:
- On the sales documents type.
- On the billing document type.
- On the consolidated method.
- On the sales unit.
For more detail on the selections, click on this LINK.
Core queries
The core queries are used to build the workbooks and to have the detail at the documents lines level (jumps).
SNAPSHOTS To Be Invoiced
The core query Order Book: SNAPSHOTS To be Invoiced (BW_QRY_MVSDSO01_SD004) is used to build the workbooks:
- Order book business view To Be Invoiced.
- Order book business view To Be Invoiced (consolidated view).
IMPORTANT: The diferences between the order book business view To Be Invoiced (consolidated view) and the order book business view To Be Invoiced , are only on the keys figures definitions. The same keys figures are used as the Order book business view, but the percentage of Solvay in a legal company is used to calculate the consolidated keys figures. For more details, click on this LINK.
Filters:
Comment: In yellow the characteristics where a filter is applied. The others characteristics are prompts.
Free Characteristics:
Rows:
Columns (Key figures):
For more detail please open the query on the query designer.
SNAPSHOT To Be Issued
The core query Order Book: SNAPSHOTS To be Issued(BW_QRY_MVSDSO01_SD003) is used to build the workbook:
- Order book business view To Be Issued.
Filters:
Comment: In yellow the characteristics where a filter is applied. The others characteristics are prompts.
Free characteristics:
Rows:
Columns (Keys figures):
For more detail please open the query on the query designer.
Open order to be invoiced (Jump)
The core query BW - Order book: Open Order (Core) (BW_QRY_MVSDSO01_SD006) is used to have the detail of the Open Orders (Jump query) in the workbooks:
- Order book business view To Be Invoiced.
- Order book business view To Be Invoiced (consolidated view).
Filters:
Free Characteristics:
Rows:
Columns (Keys figures):
For more details, please open the query BW - Order book: Open Order (Core) (BW_QRY_MVSDSO01_SD006) in the query designer.
Open order to be issued (Jump)
The core query BW - Order book: Open Order To be issued (Core) (BW_QRY_MVSDSO01_SD001) is used to have the detail of the Open Orders (Jump query) in the workbooks:
- Order book business view To Be Issued.
Filters:
Free characteristics:
Rows:
Columns (Keys figures):
For more details, please open the query BW - Order book: Open Order To be issued (Core) (BW_QRY_MVSDSO01_SD001) in the query designer.
Shipped but no billed to be invoiced (Jump)
The core query BW - Order book: Shipped not billed (Core) (BW_QRY_MVSDSO01_SD007) is used to have the detail of the Shipped not billed (Jump query) in the workbooks:
- Order book business view To Be Invoiced.
- Order book business view To Be Invoiced (consolidated view).
Filters:
Free characteristics:
Rows:
For more details, please open the query BW - Order book: Shipped not billed (Core) (BW_QRY_MVSDSO01_SD007) in the query designer.
Shipped but no billed to be issued (Jump)
The core query BW - Order book: Shipped not billed To be issued (Core) (BW_QRY_MVSDSO01_SD002) is used to have the detail of the Shipped not billed (Jump query) in the workbook:
- Order book business view To Be Issued.
Filters:
Free characteristics:
Rows:
Columns (Keys figures):
For more details, please open the query BW - Order book: Shipped not billed To be issued (Core) (BW_QRY_MVSDSO01_SD002) in the query designer.
Full data base (Jump)
Billed
The core query BW - Order book: Invoiced Current Month (Core) (BW_QRY_MVSDSO01_SD008) is used to have the detail of the billed documents lines (Jump query) in the workbooks:
- Order book business view To Be Invoiced.
- Order book business view To Be Invoiced (consolidated view).
- Order book business view To Be Issued.
IMPORTANT: A selection is done on the cube SO Order Book: Current month Invoices (Solvay) (CRSDSO01) to keep only the billing documents with a billing date (Month/Year) igual to the current month.
Filters:
Free characteristics:
Rows:
Columns (Keys figures):
For more details, please open the query BW - Order book: Invoiced Current Month (Core) (BW_QRY_MVSDSO01_SD008) in the query designer.
Core workbooks
Three core workbooks are available on the folder Order book for the sales orders. Each workbooks are based on one query.
Order book business view To Be Invoiced
The workbook Order book business view To Be Invoiced (BW_WBK_SD_0001) is base on the core query: Order Book: SNAPSHOTS To be Invoiced (BW_QRY_MVSDSO01_SD004) and it contains the tabs below:
- Summary
- Perimeter
- Snapshot by BA and Ship-to zone.
- Snapshot by Product hierarchy
- Snapshot by Sales Organization
- Snapshot by Sales Representative and Ship-to
- Read-me
- Glossary
IMPORTANT:
- The tab snapshot by BA and ship-to zone contains exclusions:
- Jumps are linked with the workbook to have the detail at documents lines level for:
- Open orders
- Shipped not billed
- Invoiced
- Full order book
For more detail please open the workbook in Analysis (tab read-me and glossary).
Order book business view To Be Invoiced (consolidated view)
The workbook Order book business view To Be Invoiced (conso) (BW_WBK_SD_0002) is base on the core query: Order Book: SNAPSHOTS To be Invoiced (BW_QRY_MVSDSO01_SD004) and it contains the tabs below:
- Summary
- Perimeter
- Snapshot by BA and Ship-to zone.
- Snapshot by Product hierarchy
- Snapshot by Sales Organization
- Snapshot by Sales Representative and Ship-to
- Read-me
- Glossary
IMPORTANT:
- The tab snapshot by BA and ship-to zone contains exclusions:
- Jumps are linked with the workbook to have the detail at documents lines for:
- Open orders
- Shipped not billed
- Invoiced
- Full order book
WARNING: the jump query will provide the detail not consolidated. To have the detail consolidated, the user need to had manually the keys figures consolidated. It's to reduce the number of core queries. The order book business view to be invoiced and the order book business view to be invoiced consolidated are using the same queries. By default the keys figures consolidated are hidden on the queries.
Order book To Be Issued
This workbook is base on the core query BW - Order book: Snapshots To be issued (Core) (BW_QRY_MVSDSO01_SD003) and it contains the tabs below:
- Summary
- Perimeter
- Snapshot by BA and Ship-to zone.
- Snapshot by Product hierarchy
- Snapshot by Sales Organization
- Snapshot by Sales Representative and Ship-to
- Read-me
- Glossary
For more detail please open the workbook in Analysis (tab read-me and glossary).
COMMENTS: Please note that for the sales order book. The shipped not billed and the billed parts are displayed for the current month.
Purchase order (Transfers) order book
Core rules
All the rules used in OBAS were determined by SAP experts.
IMPORTANT:
- The purchase order (Transfers) order book take in consideration just the PO's types UB and NB, just for the purchase organization ZZ80, OV80 and SRMR.
- The purchase order (Transfers) order book is defined at the purchase order line.
To be invoiced date
The to be invoiced date is calculated following the rules below:
- If there is GR (good receipt) date, the to be invoiced date = the last GR date.
- If there is not yet a GR (Goods Receipt), the to be invoiced date = the scheduled delivery date of the last schedule line.
The rest to be delivered for PO's transfers
The rest to be delivered is the quantity which need to be delivered to the customer to complete the requested quantity. The rest to be delivered is defined at the purchase order line level. It is used in the Open order part, to determine the to be invoiced quantities and the values. The calculation is done following the rules below:
- If the confirmed quantity = 0.
- The rest to be delivered = PO's line quantity - the goods receipt quantity
- If the confirmed quantity <> 0.
- The rest to be delivered = the PO's line confirmed quantity - the goods receipt quantity
IMPORTANT: If the rest to be delivered is negative, the quantity: rest to be delivered is forced to 0.
Open order
Definitions
A PO transfers order is open if:
- the indicator Final delivery is empty (for NB document).
- the quantity of the PO line is issued (for UB document).
Example:
The PO's line 4512394035/10 is closed because the indicator Final Delivery is flagged.
Delivered quantity
Definition
Is the quantity issued (the delivery line has an actual GI date).
Example:
The delivery line 87422928/10 which contain the bacth 900001 is issued. The quantity was delivered.
Billed
Definition
A PO transfers order line is billed, when a billing line is created with reference document:
- the PO transfers order
- the PO transfers order's delivery
IMPORTANT: On the transfers process, just purchase documents type NB will generate billing documents.
Example:
The PO 4511943102 has a billing document created in reference of the delivery document 86095478. The PO's transfers is billed.
Master data
Data flow
The data flow is based on the LSA method. The data visualization is done on the multiprovider MVSDSO07 (MP: Transfers order book).
OBAS data layers:
- Propagation Layer
- Business Layer
- Reporting Layer
- Virtual Layer
- Master Data
The draw below represente the data flow of the multiprovider MVSDS07:
Click on the draw to enlarge.
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:
| DSO tech. name | DSO description | DTS tech. name | DTS description | Comments |
|---|---|---|---|---|
| DPSDSO02 | Sales Document Item Data (Solvay) | 2LIS_11_VAITM | Sales Document Item Data | OBAS |
| DPSD001 | Deliveries (Solvay) | 2LIS_12_VCITM | Delivery Item Data | OBAS |
| DPSDSO07 | Billing Document Item Data (Solvay) | 2LIS_13_VDITM | Billing Document Item Data | OBAS |
| DP_PUSL2 | PO: Schedule line (Solvay) | 2LIS_02_SCL | Purchasing data (schedule line level) | SPRINT |
| DP_PUHD2 | PO : Historical Data (Solvay) | DTS_BW_EKBE | PO Historical Data | SPRINT |
For more detail on the propagation layer click on this LINK.
Business layer
List of infoproviders used by the PO's transfers order book:
| DSO tech. name | DSO description | source DSO tech. name | source DSO description |
|---|---|---|---|
| DBSDSO25 | PO : Transfers Historical Data (Solvay) | DP_PUHD2 | PO : Historical Data (Solvay) |
| DBSDSO26 | PO: Transfers orders sched. line (Solvay) | DP_PUSL2 | PO: Schedule line (Solvay) |
| DBSDSO28 | PO: OPEN Transfers orders (Solvay) | DBSDSO26 | PO: Transfers orders sched. line (Solvay) |
| DBSDSO27 | PO: Transfers orders Invoices (Solvay) | DPSDSO07 | Billing Document Item Data (Solvay) |
| DBSDSO29 | PO Global: Transfers orders delivery (Solvay) | DPSD001 | Deliveries (Solvay) |
For more detail on the business layer click on this LINK.
Reporting layer
List of infoproviders used by the PO's transfers order book:
| CUBE tech. name | CUBE description | source CUBE tech. name | source CUBE description |
|---|---|---|---|
| CRSDSO12 | PO Order Book: OPEN ORDER (Solvay) | DBSDSO28 | PO: OPEN Transfers orders (Solvay) |
| CRSDSO11 | PO Order Book: Current month Invoices (Solvay) | DBSDSO27 | PO: Transfers orders Invoices (Solvay) |
| CRSDSO04 | PO Global: Deliveries aggregated (Solvay) | DBSDSO29 | PO Global: Transfers orders delivery (Solvay) |
For more detail on the reporting layer click on this LINK.
Virtual layer
List of infoproviders used by the PO's transfers order book:
| CUBE tech. name | CUBE description | source CUBE tech. name | source CUBE description |
|---|---|---|---|
MVSDSO07 |
MP: Transfers order book | CRSDSO04 + CRSDSO11 + CRSDSO12 | PO Global: Deliveries aggregated (Solvay) + PO Order Book: Current month Invoices (Solvay) + PO Order Book: OPEN ORDER (Solvay) |
For more detail on the vitual layer click on this LINK.
Master data
Just the master data of C_PO_ITM is used. Please refer to SPRINT documentation for more informations.
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 multiprovider MVSDSO07 (MP: Transfers order book):
- OBAS: Transfers Orders Main chain (PC_OBAS_TRANSFERS_MAIN)
- OBAS: Business Layer Transfers Orders (Solvay) (PC_OBAS_TRANSFERS)
- OBAS: Reporting Layer Transfers Orders (PC_OBAS_TRANSFERS_ODB)
OBAS: Transfers Orders Main chain (PC_OBAS_TRANSFERS_MAIN)
OBAS: Business Layer Transfers Orders (Solvay) (PC_OBAS_TRANSFERS)
OBAS: Reporting Layer Transfers Orders (PC_OBAS_TRANSFERS_ODB)
Loading frequency
The data is updated every day. The process chain start after the end of SPRINT update.
Performance
General performance
Detailed performance
Reporting
Data selection
Core queries
SNAPSHOT PO's transfers To Be Invoiced
This workbook is base on the core query Order Book: SNAPSHOTS To be Invoiced (BW_QRY_MVSDSO01_SD004) and it contains the tabs below:
- Summary
- Perimeter
- Snapshot by BA and Ship to zone
- Snapshot by Product hierarchy
- Snapshot by Departure Plant
- Read-me
- Glossary
Open order
Billed
Core workbooks
Order book PO's transfers To be invoiced
Historical data
Sales order
Sales documents types
Sales order
Delivery
Billing
Sales documents flows
Sales order
Schedule line
Delivery
Shipment
Billing
Master data
Data flow
Propagation layer
Business layer
Reporting layer
Virtual layer
Master data
Data update
Process chain
Loading frequency
The data is updated every day. The process chain start runed after the end of TIERS update.
Perfomance
Reporting
Data selection
Core queries
Historical data: Sales orders
Historical data: Sales deliveries
Historical data: Sales invoices
Historical data: Sales overview
Detail: Schedule line
Detail: Sales order
Detail: Deliveries
Detail: Invoices
Core workbooks
PO's transfers
Puchase order documents types
Purchase order
Delivery
Billing
Purchase documents flows
Purchase order
Schedule line
Delivery
Shipment
Billing
Master data
Data flow
Propagation layer
Business layer
Reporting layer
Virtual layer
Master data
Data update
Process chain
Loading frequency
The data is updated every day. The process chain start runed after the end of TIERS update.
Perfomance
Reporting
Data selection
Core queries
Historical data: Po's transfers orders
Historical data: Po's transfers deliveries
Historical data: Po's transfers invoices
Detail: Po's transfers order
Detail: Po's transfers Deliveries
Detail: Po's transfers Invoices
Core workbooks
Sales follow-up
OTIF (On Time In Full)
Concepts and definitions
ATP DATES
Available-to-promise (ATP) is a business function that provides a response to customer order enquiries, based on resource availability. It generates available quantities of the requested product, and delivery due dates.
- First ATPs dates, are the first dates received from a schedule line in PF1.
- Last ATPs dates, are the last dates received from a schedule line in PF1.
- The date of the restauration will be the starting date for the calculation of the ATP dates.
- All the ATP dates calculated before this date are loosed.
AGENT COMMISSIONS:
An agent commission is a partner of Solvay. This partner receive a commission for sales. This commission is calculated via a specifics documents types which are generate by a billing document of a sales order. The agent commission is based on two keys figures. The commission base and the commission rate. The value of the commission received by the agent is igual to: the commission rate X the commission base. For more detail click on this LINK.
BILLED:
BILLING GROUP
BILLING LINE
BLOCKS
The sales process can be stop by block(s) on the sales document(s) or document(s) line(s).
If a block exists the sales process is stopped where the block is created (at the document or document level).
Types of blocks:
- Delivery block (Historic).
- Delivery block (Document item)
- Billing block (Document header)
- Billing block (Document item)
- Credit block (Historic)
- Credit block (Dynamic)
For more informations click on this LINK.
CLOSE ORDER
An order is close if the rest to be delivered = 0.
CO (CURRENCY ORIGIN)
it's the currency of the legal company responsible for the order line.
COMMISSIONS
Is a part of the gross sales, it is determined during the pricing. This information provide from the billing document and it is retreived with the subtotal 4.
CONFIRMED QUANTITY
Is the quantity confirmed by the system. In other terms, what quantity the supply chain is able to deliver regarding the customer's requested delivery date. This quantity is defined at the schedule line level on the system. In BW the confirmed quantity is available on the data base, at the schedule line and at the sales
CONSOLIDATED RATE
Is the percentage of Solvay in a legal company.
IMPORTANTE: The consolidated rate is maintained in the master data of the object C_COMPCDE (Company code). For more detail click on this LINK.
CONSOLIDATION METHOD
It is an financial information to know how the result of a legal company is counted in the overall group result. This characteristic is used to do the exclusion of sold entities.
CP (CURRENCY PROMPT)
CREDIT/DEBIT MEMO
CURRENCY CONVERSION
CUSTOMER
CUSTOMER GBR
CUSTOMER PICK-UP
CUSTOMER SALES VIEW
DELAYED BY ATP
- If the function ATP is available for the sales order.
- And the system is not able to deliver the quantity asked at the requested date by the customer
DELIVERY LINE
A delivery line is the combination of a delivery document and an item.
Example:
70367763/10 and 70367763/900001 are deliveries lines. The important delivery line is 70367763/900001 because is the quantity isn't null.
IMPORTANT: The delivery line with the "zero" quantity must to be in the data base (DSO DBSDSO14 (Global sales deliveries)). It because billing lines can be created regarding this delivery line.
DELIVERY TOLERANCE
DEPARTURE PLANT
The concept of departure plant is used for PO's transfers . The departure plant is the plant where the product is sent.
DESTINATION PLANT
The concept of destination plant is used for PO's transfers part. The destination is the plant where the product is delivered.
DISCOUNT & SURCHARGES
EXTRAPOLATION BY WORKING DAYS
An extrapolation by working days can be applied on the different keys figures. The objective is to be able in a commercial to know the number of working days for the curent month and the number of working days passes until the last update date> The determination of the working days is done at the country's SAP standard calendar calendar.
Applications: In the sales follow-up's workbook, an extrapolation is done on the monthly delivery quantity. The references dates (number of working days for the current month and number of working days passed until the last update) are based on the SAP standard calendar of the plant's country.
IMPORTANT: The object C_TECHWD is calculated every day. If for a country code a SAP standard calendar exist. For more detail click on this LINK.
FIRST CONFIRMED QUANTITY
The first confirmed quantity is: the first quantity, confirmed for an order line, received in BW during an update.
IMPORTANTE: This quantity is avaible on the master data C_ITM_SD (Sales document item). For more detail click on this LINK.
FIRST CUSTOMER GI DATE
FIRST REQUESTED DATE
FIRST REQUESTED QUANTITY
GBU SHIP-TO ZONES
GROSS SALES
INTRA GBU
INTRA GROUP
IV DOCUMENTS
JUMP QUERY
LAST CONFIRMED QUANTITY
LAST CUSTOMER GI DATE
LAST REQUESTED DATE
NET SALES
OBAS AUTHORIZATIONS
OBAS CURRENT MONTH
OPEN ORDER
ORDER BOOK RULES
ORDER LINE
PRICING CONDITION
PRO-FORMAT DOCUMENTS
This kind of billing document is not counted in the sales result by the business. The proformat document is mandatory to be aligned with specifics countries's laws.
SCREAN SHOT
PUQ (PROMPT UNIT QUANTITY)
PURCHASE ORDER LINE (TRANSFERS)
REBATES
REJECTED ORDER
REST TO BE DELIVERED
RESTATED BUSINESS AREA
RESTATED PARTNER BUSINESS AREA
ROUTE
SCHEDULE LINE
A scheduled line is the more detailed level in a sales order. By default each sales order line has only one scheduled line. If the business function ATP is activated for the order line. More than one scheduled line line can be generated.
SALES REPRESENTATIVE
SHIPMENT TO THE END CUSTOMER
SHIPPED BUT NOT BILLED
SNAPSHOT
TAXES
TO BE INVOICED
TO BE ISSUED
TRANSFERS ORDER
TRANSITE TIME
TRANSPORTATION MODE
UNIT CONVERSION
RETURN
Maintenance
Known bugs
Recurring procedure
Planned Evolution
OBAS interaction
TIERS
SPRINT
APO
DYNASIS
Detail: Schedule line
| Snapshot by BA and Ship to zone |
For more detail on the business layer click on this LINK.


















































































