Skip to Content
0
Former Member
Jul 02, 2012 at 07:30 AM

Restrict join result of an infoproviders

18 Views

hi, guys!

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)

BOM_ITEM-QUANTITY

PLAN_CUBE-CALDAY

PLAN_CUBE-QUANTITY

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!