I need an advice.
There are bill of material in SAP exists, I need to build a report "Planning for the consumption of raw materials".
For bill of materials I was created two extractors:
1. BOM header data
2. BOM items data
And in SAP BW exists planning info-cube with quantities for an end-products.
BOM headers contains date 0VALIDFROM.
BOM items contains dates 0VALIDFROM and 0VALIDTO.
Plan data contains production plan data, 0CALDAY.
I need to link 2 DSOs of BOM and plan cube by next criteria:
BOM_HDR-MATERIAL = BOM_ITM-MATERIAL
PLAN_CUBE-MATERIAL = BOM_HDR-MATERIAL
PLAN_CUBE-CALDAY BETWEEN BOM_ITM-VALIDFROM AND BOM_ITM-VALIDTO
And result set must be like that:
BOM_ITM-component(component of the BOM)
Which way to use to join all 3 infoproviders with date validations? InfoSet will no result because there is no way to write WHERE conditions. I think we must use APD? So how we must? 😊 THanks for any help!