disaggregation field/calculation between different base planning levels

[former_member687629]

Hi experts,

Does anyone kindly tell me how to handle the following situation?

Now, I want to KF Demand Planning Qty(@WKPRODLOCCUST) to be disaggregated based on the value of another KF called Location Sourcing Ratio(@WKPRODLOCLOCFR). I tired to input the Location Sourcing Ratio for the Key Figure Proportionality Field of Demand Planning Qty but the KF did not appear in the field. Assuming the reason why I failed is that both KF belong to different planning levels, I think what I should do is to set the Proportionality Field to "Disaggregation Expression". Now I have two questions;

Q1: Is my understanding right that it is only the KF which has same base planning level that appears in the

filed of Proportionality?

Q2: Assuming if Q1 is right, concretely speaking, what kind of expression is necessary in the disaggregation expression field to realise the below? I have already checked the sap link, I could not get any useful idea.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2008/en-US/135c2c558934753ce10000000a17...

Best Regards,

Kenta Kono

[revanchatraban · Accepted solution]

Hi,

Q1: Is my understanding right that it is only the KF which has same base planning level that appears in the filed of Proportionality?

Yes, your understanding is correct. The proportional key figure should have the same base planning level to add in the key figure for dis-aggregation.

Q2: Assuming if Q1 is right, concretely speaking, what kind of expression is necessary in the dis-aggregation expression field to realise the below? I have already checked the sap link, I could not get any useful idea.

- Here attached you one example. I am dis-aggregating my demand plan based on the generated statistical forecast qty(Just example to show you the dis-aggregation expression).

The rules for dis-aggregation expression are:

- All the key figures in the expression must be stored and must have the same base planning level as the key figure for which the expression is defined

- All the attributes must be from the base planning level of the key figure for which the expression is defined

Additional examples are

"KEYFIGURE1"

"KEYFIGURE1" + "KEYFIGURE2"

"KEYFIGURE1" +"ATTRIBUTE"

(IF(ISNULL("ADJUSTEDACTUALSQTY"),"ACTUALSQTY","ADJUSTEDACTUALSQTY"))

The advantage is you can use multiple key figures to arrive at your proportional factors for dis aggregation.

Regards,

Revan C