Symptom
The Schedule Line Delivery Date characteristic, on the Delivery Reliability standard 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.
Environment
SAP Business by Design
Reproducing the Issue
- Go to the work center Business Analytics and the view Design Reports.
- Show all and search for standard report Delivery Reliability (technical ID SRMPO_U02_Q0001).
- Run the report and 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.
Cause
This is the expected system behaviour and it is working as designed.
Resolution
The reason why you see multiple dates for the characteristic Schedule Line Delivery Date is because the data source the Delivery Reliability report is built on is a union/combined data source 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.
See Also
More information about this behaviour is available in the Knowledge Base Article 2488796 - Multiple Lines in Combined Data Sources.
Keywords
SRMPO_B09; SRMPO_B07; SRMPO_B06; SRMPO_B04; Schedule Line Delivery Date; multiple lines; combined data source;
SRMPO_U02_Q0001; Purchase Order Delivery Reliability; SRMPO_U02 , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , SRD-SRM-ANA , Analytics Content , How To