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
- Open the Delivery Reliability report (SRMPO_U02_Q0001)
- 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.
- 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.
The system behavior is as designed.
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.
KBA , SRD-CC , Cross Components , How To