The order changes reports in the BW is part of the global sales folder. The primary objective of the reports is to oversee the confirmation time of an order in SAP, providing valuable insights into the efficiency of order processing. Order promising is a supply chain KPI where Solvay ability is measured to confirm an order within the certain time frame. Additionally, these reports are designed to monitor any modifications that happened after the initial confirmation date, offering a comprehensive view of the order's lifecycle and enabling proactive management of changes in the SAP system. |
Describe the key User profiles that exist for the application. General role/Viewer role: Approver role: |
Target Users: Supply chain team and sales team. |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 18.12.2023 | Azadeh Nasiri | Initial draft |
|
The order confirmation process in SAP typically involves confirming the details of a sales order, including product availability, delivery dates, and other relevant information. The process begins with the creation of a sales order in SAP. This involves entering details such as customer information, product quantities, delivery dates, and any other relevant specifications. SAP performs an ATP check to determine the availability of the products requested in the sales order. This check considers factors such as current stock levels, incoming goods, and production schedules. Based on the ATP check, SAP provides an initial confirmation to the customer. This confirmation includes details such as the confirmed delivery date and any other relevant information. If there are changes to the order, such as customer requests or adjustments to production schedules, the order confirmation may need to be revised. SAP facilitates the process of making these revisions while ensuring the impact on product availability and delivery commitments is considered. Order changes reports in BW provides reporting and analytics capabilities to track key performance indicators (KPIs) related to the order confirmation process. This allows Solvay to monitor the order fulfillment efficiency.
Information about the existent Workbooks and the respective BW queries.
| Reports | Technical Name |
|---|---|
BW- Order promising | BW_WBK_CPSDCH01_0001 |
Order changes | BW_WBK_CPSDCH01_0020 |
There are indicators in the report that explores the time taken to confirm an order in SAP by comparing the order line creation date and the confirmation date. The target is to be less than 48 hrs (=< 2 business days).
Furthermore, the report assesses the 'Stability' factor, determining whether the first confirmation date has been altered subsequently. If so, the report provides insights into the frequency and extent of these changes, shedding light on the order's stability over time.
Scope :
Reference Date : for the KPI % Order Promising and the Cycle Time the reference date is Order Line Creation date . Order lines are taken into consideration as soon as they are entered in the system. (data load delay of 1 day, night batch)
Cycle Time :
ATP in SAP helps businesses determine the quantity of a product that can be promised to a customer at a specific point in time. It takes into account the current stock levels, incoming goods, and existing customer orders to calculate the available quantity that can be promised for future delivery.
In SAP a "Credit Block" on a sales order refers to a restriction or hold that is placed on the order due to credit-related concerns. This mechanism is part of SAP's credit management functionality, which helps organizations control and monitor credit limits for their customers. When a sales order is subject to a Credit Block, it means that the system has identified a potential credit risk associated with the customer placing the order. This risk could be due to factors such as the customer exceeding their credit limit or having overdue payments.
Scenarios/ Rules
Order still blocked? | First credit release date | 1st confirmed ATP date | Cycle Time | |
Case 1 | no | no | yes | Order line creation -> 1st confirmed |
Case 2 | no | no | no | Order line creation -> today |
Case 3 | no | yes | yes | First credit release -> 1st confirmed |
Case 4 | no | yes | no | First credit release -> today |
Case 5 | no | yes | yes (but prior to credit release date) | Order line creation -> 1st confirmed |
Case 6 | yes | - | yes | Order line creation -> 1st confirmed |
Case 7 | yes | - | no | Order line creation -> today |
Case 8 | no | yes (but prior to order line creation date) | yes | Idem case 1 |
Case 9 | no | yes (but prior to order line creation date) | no | Idem case 2 |
1st ATP confirmation date :
Promising Split : Each order line is categorized in 5 possible Confirmation Status
Details of Confirmation Status:
KPI Order Promising percentage : # of GOOD confirmed < 2 business days / # total orders lines
Confirmed in 2 business days : KPI is based on 1st ATP confirmation (whether the order line has been updated or not)
# of Confirmations :
*even if the change log shows several changes per day, we can count only 1 confirmation per day
Stability (Stable confirmation) :
Calculation: Based on KPI “# of Confirmations”, Stable Y = 1 confirmation and Stable N > 1 confirmation
If the order has no GI date, it is considered as not possible to calculate the KPI.