on 07-21-2016 11:31 AM
Dear Guru's,
I would like tounderstand in detail the disaggregation calculation method of SAP.
We have 7 levels of planning in our CVC’s
Now we have two key figures
1. Statistical Forecast (ZDPDANT)
2. Budget (ZBUDGET)
We fill in the BUDGET key figure manually on Product group, Country and Sales organization level.
The statistical Forecast key figures is calculated via a macro based on historical sales (lowest level of the CVC).
The disaggregation rule for the key figure Budget (ZBUDGET) in customizing is “Based on other keyfigure”, key figure ZDPDANT.
So for far the settings.
Question now is how does disaggregation calculate the BUDGET on product level / delivering location level?
Example
Statistical Forecast (ZDPDANT)
Total 3000
Product 10, Product group A, Sub product group A,Country NL,
Delivering location X, Sales organization X, Sales region Y 1500
Product 10, Product group B, Sub product group A,Country NL,
Delivering location X, Sales organization X, Sales region Y 500
Product 10, Product group A, Sub product group A, Country BE,
Delivering location X, Sales organization X, Sales region Y 1000
Budget (ZBUDGET)
Total 6000
Product group A, Country NL, Sales organization X 3000
Product group A, Country BE, Sales organization X 3000
What is ZBUDGET on the level:
Product 10, Delivering location X, ?
Which sequence does the disaggregation rules takes for ZBUDGET? And which level the disaggregation “Based on other keyfigure” is taken into account if the system must calculate to Product, Delivering location level.
Can anybody explain us the sequence or level(s) of disaggregation in this situation?
Best regards,
Frank van Amelsvoord
Frank,
You can't answer that question without knowing the values of 'delivering location' in ZDPDANT.
I will speak to the case where you have no Macros active that re-calculate and alter any of the Key figures during the display of the planning book. I will further assume you are not talking about a Planning area with aggregates, which is another topic all by itself.
During disaggregation, everything is disaggregated to the lowest level. (the detail level). There is no 'sequence' between levels. Data is then stored at the lowest level. No data is stored at the various possible sublevels. In your case, the disaggregation is done and stored according to the ratios implied by ZDPDANT Keyfigure.
Assuming that your sales history included 'delivering location', then the historical ratios for delivering location were calculated when you created and stored your ZDPDANT KF. When you then open the planning book, and display ZBUDGET, all your displays, regardless of the level that you display, are re-summarized, from the detailed data that was stored, according to ratios found in ZDPDANT..
If you change a key figure, regardless of the level, the changed value is then re-disaggregated to the lowest level, according to the ratios implied in ZDPDANT KF.
Best Regards,
DB49
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi DB49,
Thanks for your quick response.
I checked your answer and that is correct. The lowest level of disaggregation of the CVC is correct. The aggregation to an other level I can not explain. So if I Add up all lowest level values the aggregated level I can not explain. I just thought to add up all lowest levels but that seems not the case. If you want I can sent you in a PM the download of the planbook in an excel file format.
Best regards,
Frank van Amelsvoord
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.