SAP Knowledge Base Article - Public

3789455 - Which "Requested Delivery Date" field is used to be displayed in the "Sales Order Items - Backorders" app? - SAP S/4HANA Cloud Public Edition

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

  1. Go to Display Sales Orders - VA03
  2. Compare the information from the field Delivery Date with the information displayed in the "Sales Order Items - Backorders" app.
  3. 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

Product

SAP S/4HANA Cloud Public Edition all versions