Symptom
When you check in the standard report "Production Request Fulfillment" (SCMPRFU01_Q0001), you find key figure "Delays in Days" shows odd value like -738.416 d.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to work center Business Analytics.
- Access view Design Reports.
- Search SCMPRFU01_Q0001, click Edit With Web Browser.
- Enter ABC (ABC represents production request ID) in Production Request ID, click Apply.
- In the result, for input products, Delay in Days is -738.416 d.
Cause
The key figure "Delay in Days" is calculated based on output product rather than input product.
Resolution
If you remove characteristic "Input Product" from row, you will find Delay in Days displays normally with below formula:
Delay in Days = (([Production End Date] - [Planned Production End Date]) * [PARA_NUMBER_OF_DAYS])
PARA_NUMBER_OF_DAYS is a hidden parameter whose default value is 1. It is used for conversion of the difference in date to quantitative value.
Keywords
SCMPRFU01_Q0001, Delay in Days, Input Product, Output Product , KBA , AP-PE-REQ , Production Request , Problem