1822087 - Multiple values shown for the Schedule Line Delivery Date on the Delivery Reliability report

SAP Knowledge Base Article - Public

1822087 - Multiple values shown for the Schedule Line Delivery Date on the Delivery Reliability report

Symptom

The Schedule Line Delivery Date characteristic, on the Delivery Reliability report, shows two different delivery dates although when you check the respective Purchase Order Item details you see that only one delivery date is shown.

Reproducing the Issue

  1. Open the Delivery Reliability report (SRMPO_U02_Q0001)
  2. Add the desired characteristics and Key figures. For example: Supplier, Purchase Order ID, PO Item, Ordering Date, Schedule Line Delivery Date, Last Actual delivery date, Ordered Qty & Delivered Qty.
  3. From the Schedule Line Delivery Date column for a specific Purchase Order and related items you see two sets of dates although the customer expects to see only one; as shown from the  respective Purchase Order under item details then delivery date.

Cause

The system behavior is as designed.

Resolution

The reason why you see multiple dates for the Schedule Line Delivery Date characteristic, on the Delivery Reliability report, is because the data source the report is built on is an union data source (multiple data sources) and it shows the data from several basic data sources like Purchase Order Item with Goods and Service Receipts Item (SRMPO_B04), Purchase Order with Confirmed Inbound Delivery Items (SRMPO_B06), Purchase Order with Outbound Delivery Items (SRMPO_B07) and Purchase Order Schedule Lines (SRMPO_B09).

In this case, for the Purchase Order analyzed, the Scheduled Delivery Start Date on the Purchase Order Item is different from the one on the Goods and Services Acknowledgement.
In Order to display both the planned Purchase Order and actual Goods and Service Acknowledgement delivery dates two lines are created. One line in the report is showing the delivery date and quantity of the Goods and Service Acknowledgement and the other line is showing that of the Purchase Order.

Note: For some Purchase Order both the planned and actual delivery dates can be the same so you see only one line as there's no need to split the data.      

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711