Symptom
In the standard report Production Request Fulfillment when we add the Input Product, Product Lot fields in the Row fields,
we notice that for every production lot there is additional line included for input product and # is displayed.
Environment
SAP Business ByDesign
Reproducing the Issue
1. Go to Business Analytics workcenter and Design Reports view
2. Open Production Request Fulfillment report.
3. Run the Report.
4. Add the field Production Lot and Input product and check the values.
You will see the last record as # in the input product against every Production lot.
Cause
The underlying Data Source SCMPRFU01 is an union Data source of two data sources SCMPRFB01 and SCMPRFB02.
But input product id is mapped only from data source SCMPRFB01. Due to this for some rows where the data from the second data source SCMPRFB02 is present input product id value will be '#' since no value is available for this field in second data source.
Resolution
Data Source SCMPRFU01 is an union Data source of two data sources SCMPRFB01 and SCMPRFB02.
For some rows where the data from the second data source SCMPRFB02 is present input product id value will be '#'
Keywords
Production Request Fulfillment, SCMPRFB01, SCMPRFB02, SCMPRFU01, datasource, Production Lot , KBA , production request fulfillment , scmprfb01 , scmprfb02 , scmprfu01 , datasource , production lot , AP-PE-REQ , Production Request , How To