Symptom
When you check the master data of BoM ABC, there are X input products; however, check the same BoM in a report which created on standard data source "Production Bills of Material Variant and Assigned Line Item Details" (SCMPBOMU02), there are Y (Y>X) input products.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to work center Planning and Production Master Data.
- Access view Production Bills Of Material.
- Find BoM ABC, Click Edit.
- Select tab Input Products, select By Reference Date in Filter Options, select a date in Reference Date, in the below there are X input products.
- Go to work center Business Analytics.
- Access view Design Reports.
- Find report DEF (created on standard data source "Production Bills of Material Variant and Assigned Line Item Details" (SCMPBOMU02)), click Edit with Web Browser.
- In Selection, enter ABC for filter BoM ID, click Apply, in the result there are Y (Y>X) input products.
Cause
Date source like SCMPBOMU02 will retrieve all related line items of BoM, because it has no filter like "Reference Date" to display valid input products at a specific date.
Resolution
You can use Multi-Level Structure or Multi-Level Visualization (in the screen "Planning and Production Master Data - Production Bills Of Material") to display valid input products of a BoM at a specific date and then export it into a local Excel file.
Keywords
BoM, Input Products, Report, Reference Date, SCMPBOMU02 , KBA , AP-PMM-BOM , Production Bill of Material , Problem