Symptom
When comparing the values of the field "Requested Delivery Date" from the VA01/02/03 apps and the "Sales Order Items - Backorders" app, both values are different.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Go to Display Sales Orders - VA03
- Compare the information from the field Delivery Date with the information displayed in the "Sales Order Items - Backorders" app.
- See that they are different
Cause
A sales order has three levels where the field "RequestedDeliveryDate" appears:
- Header (Req. Deliv. Date): Editable by the user. Defaults to all items and schedule lines.
- Schedule Line (Delivery Date): Copied from the header date, but can be adjusted. ATP check uses this to confirm quantities and can potentially split the schedule line.
- Item (First Date): Read-only information, calculated as the earliest delivery date across the item's schedule lines.
The app "Sales Order Items - Backorders" uses the RequestedDeliveryDate field and focuses on the sales order header level (items are hidden by default). Using the header date avoids a performance cost because, the item-level date (First Date) is a calculated field that requires joining and aggregating schedule line data at runtime.
Resolution
If the other fields are necessary to be displayed, it is possible to build a custom analytical report using custom CDS views (cube/query) to implement any specific logic, including the item-level calculated date. In this scenario, the CDS View that should be used is I_SalesDocumentScheduleLine.
Keywords
cds, view, header, delivery, date, sales, document, schedule, line, analytical, report, requested, sales orders, items, backorders, atp, , KBA , SD-ANA-2CL , Analytics (Public Cloud) , Problem
SAP Knowledge Base Article - Public