User defined Calculation Rule for disaggregation in DP

[mario_scheibe]

Hi,

does anybody know, whether there is a possibility to have an own User definfed Calculation Rule for disaggration in Demand Planning like in SNP.

Is there a user-exit or badi in /sapapo/msdp_admin to add an addtional own defined Keyfigure Calculation Rule.

Thanks a lot,

Regards,

Mario

[former_member583013 · Accepted solution]

Hi Mario,

In DP the disaggregation happens in livecache.So we can use only predefined i.e standard disaggregation rules in DP.

Regards,

Sunitha

[Former Member]

Hi,

There is no option of creating User defined calculation Rule. What kind of rule does the business require?

One option is to manually maintain Proportional Reference. With the help of macros, you can edit these Prop ref values as required by the business.

Hope this helps.

Thanks

Mani

[mario_scheibe]

We require a dissagregation rule like in SNP. First of all dissagragtion should be done based on Demand (based on Keyfigure - exisiting Sales Orders) for the remaining quanties a predefine ratio should be applied. (other Keyfigure). Example:

Sales Ordes 100 PC

Plannend Demand 200 PC

Dissaggregtion 100 PC according Sales Orderes and 100 PC according standard ratio.

Regads,

Mario

Edited by: Mario Scheibe on Apr 6, 2010 9:03 AM

[Former Member]

Hi,

There is no standard functionality to achieve this. I can suggest a way using 3 KF.

KF1 - This should have a disagg type 'P' and based on KF Sales Order.

KF2 - This should have a disagg type 'P' and based on prop ref KF.

KF3 - This will be the sum of KF1 & KF2. This should have disagg type 'N' - No Calculation.

Load KF1 with Sales Order value or the Planned Demand whichever is lesser in your example this will have a value of 100. Load this at the highest level, so that it disaggregates based on the Sales Order at the detailed level.

KF2 = Planned Demand - Sales Order. Load this also at the highest level so that it disaggregates based on the Prop Ref factors you will have defined.

KF3 = KF1 + KF2. We should do this at the detailed level so that disaggregation from KF1 and KF2 is carried forward into this. All of these functions can be achieved thru macros available in the Planning books.

Based on the freq of change, you can decide to run it in background once a day or make it a at Save macro in the planning books.

I am confident this will serve your purpose.

Hope this answers your query.

Thanks

Mani

Edited by: Mani Suresh on Apr 6, 2010 3:54 PM

[mario_scheibe]

Thanks a lot,

great idea.

Regards,

Mario