If you’re writing an ‘Open Orders’ report, chances are you are intersted in the delivery status of your Sales Order. You man have noticed that there are two delivery statuses (stati?) found on the Sales Document Header and Item level: “Delivery Status” and the “Overall Delivery Status”. What do these statuses represent? Read on to learn more about the SAP Sales Order Delivery Status fields.
SAP Sales Order Delivery Status Fields
First off, let’s discuss where these status fields exist. The answer will depend upon your version of SAP. If you’re using ECC 6 or previous, you will find these status fields in dedicated status tables. The header status table for SD Documents is table VBUK. Likewise, item level status fields exist in table VBUP. These index tables store status details separately from other header and item details to improve database performance.
With SAP S/4HANA, these performance issues are no longer valid, so SAP decided to integrate status fields into the main Sales Order Header and Item tables: VBAK and VBAP respectively.
NOTE: My S/4HANA reference systems include the old VBUK/VBUP tables, but they are not functional.
SAP Delivery Status
The delivery status reflects the actual delivery status of a line item. That status is then aggregated at the header level to summarize the status at the entire document level.
The “actual delivery status” mentioned above reflects whether or not the item has been delivered:
|If the item is not relevant for delivery, the value is blank/null.|
|A||The item is relevant for delivery, but has no delivered quantity.|
|B||The item is relevant for delivery, but has only a partial quantity delivered.|
|C||The item is relevant for delivery, and is fully delivered.|
In the above list, “delivered” means there is a delivery created with reference to the Sales Order item. It does not indicate whether the delivery has been goods issued.
The status is aggregated at the header level:
|A||No items have been delivered|
|B||At least one item has been delivered, or partially delivered|
|C||All items have been delivered|
Another important thing to note is that items which have been rejected with still show a delivery status of A, B, or C. This is the reason why the Delivery Status can be a bit misleading: the item may still appear to be open on a report, despite being rejected.
The database fields for this status are as follows:
|System||H / I||Table/Field|
SAP Overall Delivery Status
As described above, the ‘Delivery Status’ values can be misleading when items are rejected. The ‘Overall Delivery Status’ will help us account for that. This value can also be thought of as the “effective delivery status”. It answers the question: What is the status of the deliverable items?
That status values (A, B, and C) still apply to each items; however, it takes into consideration the Rejection Reason. If there is a Rejected item, for example, it will not be delivered and so it is considered as “C” (Complete).
|System||H / I||Table/Field|
The same aggregation occurs for the header status, except, as mentioned above, it considers rejected items as Complete (“C”).
There you have it: The SAP Sales Order Delivery Status and Overall Delivery Status explained. There’s a subtle difference between these fields. Understanding them can really make an impact to custom reports or simply help you understand the values as they appear on a standard report. Thanks for reading. Please leave your thoughts and questions in the comments below.