Symptom
In data source SRMPO_B12, for a specific confirmed inbound delivery, key figures "Delivered Quantity in Base Unit of Confirmed Inbound Delivery" and "Delivered Quantity of Confirmed Inbound Delivery" show double delivered quantity.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to work center Business Analytics.
- Access view Design Data Sources.
- Search SRMPO_B12, click Preview.
- Under Selection, enter ABC (ABC represents purchase order ID) for Purchase Order ID, click Apply.
- Under View, add row fields "Purchase Order ID" and "Confirmed Inbound delivery ID".
- In the result, for confirmed inbound delivery DEF (DEF represents inbound delivery ID), key figures "Delivered Quantity in Base Unit of Confirmed Inbound Delivery" and "Delivered Quantity of Confirmed Inbound Delivery" show, for example, 41.800,00 KGM.
- Check in inbound delivery DEF, for corresponding product, fulfilled quantity is 20.900 kg.
Cause
Date source SRMPO_B12 shows the combined quantity (Delivery quantity + Quantity which is listed in delivery note) in key figures "Delivered Quantity in Base Unit of Confirmed Inbound Delivery" and "Delivered Quantity of Confirmed Inbound Delivery."
Resolution
If above combined quantities need to be shown separately, you can add row field "Quantity Role".
Keywords
Data Source, SRMPO_B12, Delivered Quantity in Base Unit of Confirmed Inbound Delivery, Delivered Quantity of Confirmed Inbound Delivery, Double , KBA , SRD-SRM-ANA , Analytics Content , Problem