Skip to Content
0
Former Member
Jan 07, 2011 at 11:54 AM

Proportional Factors

75 Views

Hi Experts

I have a following requirment in Demand Planning:

We have 2 levels of disaggregation. Firstly region Level and secondly customer level.

Our planners want to take many factors for spliting the demand to the regioal level and then after customer level.

Regional level disaaggregation factors are 6 months sales history, Back Orders, Customer forecast.Once they finish region level forecast, account managers from each region is responsible to break demand to each customer based on different factors like customer forecast, customer target, back orders, sales history.

As per the standard SAP functionality we can generate proportions based on the History or Past forecast and it stores in the APODPDANT Keyfigure.

1) How to write macro to generate proportions for Customer forecast, Back Orders, customer target ?

2) In the above scenario, once forecast is updated by the Regional Planner at region level , by default regional forecast is further splitted to each customer level of that region since in APO DP the values are stored in the detail level of CVC.How to avoid this?

The reason behind the above requirment , our regional forecast have to get approved by management, after approval accont managers initiates to update forecast at each customer level with slighthly different logics.

Ours is Top Down approach.

Please give your valuable suggessions.

Thanks

Vicky