IBP Disagregation Operator

[former_member623252]

HI,

Have a requirement to copy the values of Key figure at Planning Level WKPRODLOCLOCFR to WKPRODLOC. When Use the Disag Operator as PRDID to be aggregation level, the values are dis aggregated to all locations of the product. Instead of Dis aggregating to all Locations it should written to only one location where Attributes Location type = S and Location Ratio = 1. Tried to write Dis aggregation expression in the Target Key figure but didn't work.

Awaiting for your quick response.

[piyush_parekh · Accepted solution]

Hi,

If I understood the question correctly, you are looking for aggregating WKPRDLOCLOCFR values of multiple LOCID to WKPRDLOC level for a specific LOCID as shown below. There could be two approaches-

Create a planning level WKPRD and copy data from Source KF to KF1 at PRDID level. With a pre-requisite, you already have a stored key figure and planning combination available at PRDLOC level, create a dummy figure at WKPRDLOC level which will always have value as 1.

In calculated target KF at WKPRDLOC level, you can write a calculation which multiplies dummy key figure with KF1. Add a filtering calculation in this expression stating LOCTYPE = S. The limitation of this approach is hard-coding of filter condition.

Another approach is using data realignment functionality (which is more flexible compared to first approach). Refer below link on similar topic and how data realignment can be used in this situation:

https://answers.sap.com/questions/12705718/quality-lead-time-consideration-along-supply-chain.html?c...

Hope this helps!!

Regards,
Piyush

[former_member623252]

Thanks Piyush. Now Disag results looks much better.