on 04-07-2007 12:48 PM
Hi All,
Please help me in resolving the issue regarding incorrect key figure disaggregation in the planning book. The key figure value which is disaggregated is based on another keyfigure. The calculation type and disaggregation type set up in the planning area for these two key figures are
Calculation type Based on KF Time based disaggregation
KF1 S P
KF2 P KF1 P
I am providing an example as below.
You select one SKU (50058801807) in the planning book. These three characteristic value combinations exist for the SKU: CVC1, CVC2, and CVC3. You enter 100 pieces as the actual impact of promotional events quantity (KF2) in the month of May (month five).
You save the data. The system first performs time-based disaggregation. In other words, it first disaggregates the 100 pieces of the SKU level into technical periods based on the number of workdays in each period. In this example, factory calendar has been defined in the planning area, so there are five workdays in each week. The month of May has 22 workdays (one day public holiday). No proportional factors exist.The calculation is as follows:
Level1: The system collects the rounding differences from all the periods.
Technical Number of DaysCalculation Result Brought Forward
Period in TP
5/1-5 5 100 * 5/22 = 22.727 23 -0.273
5/8-12 5 100 * 5/22= 22.727 23 -0.273
5/15-19 5 100 * 5/22 = 22.727 23 -0.273
5/22-26 5 100 * 5/22 = 22.727 23 -0.273
5/29-31 2 100 * 2/22 = 9.090 9 0.090
Total: 101 1
Level 2: Distribution of the difference -1
Technical Number of Days Calculation Result Brought Forward
Period in TP
5/1-5 5 -1 * 5/22 = -0.227 0 -0.227
5/8-12 5 -1 * 5/22 = -0.227 0 -0.454
5/15-19 5 -1 * 5/22 = -0.227 0 -0.681
5/22-26 5 -1 * 5/22 = -0.227 0 -0.908
5/29-31 2 -1 * 2/22 = -0.090 -1 0
Total: -1 0
The result:
Technical Result
Period
5/1-5 23
5/8-12 23
5/15-19 23
5/22-26 23
5/29-31 8
Total: 100
As an example, the 23 pieces, which are to be distributed in several technical periods (5/1-5, 5/8-12, 5/15-19, 5/22-26 and 5/29-31), are calculated below for the three characteristic value combinations:
CVC Calculation Result Remainder
CVC1 23 * 1/3 = 7.666 8 -0.334
CVC2 23 * 1/3 = 7.666 8 -0.334
CVC3 23 * 1/3 = 7.666 8 -0.334
Total: 24 -1.002
The remainder -1.002 is distributed to the three characteristic value combinations:
CVC Calculation Result Remainder
CVC1 -1.002 * 1/3 = -0.334 0 -0.334
CVC2 -1.002 * 1/3 = -0.334 0 -0.668
CVC3 -1.002 * 1/3 = -0.334 -1 0
Total: -1
The following table shows which of the seven characteristic combinations the system assigns how many pieces:
CVC Result
CVC1 8
CVC2 8
CVC3 7
Total: 23
Calculation for 8 pieces:
CVC Calculation Result Remainder
CVC1 8 * 1/3 = 2.666 3 -0.333
CVC2 8 * 1/3 = 2.666 3 -0.333
CVC3 8 * 1/3 = 2.666 3 -0.333
Total: 9 -0.999
The remainder 0.994 is distributed to the five characteristic value combinations:
CVC Calculation Result Remainder
CVC1 0.999 * 1/3 = -0.333 0 -0.333
CVC2 0.999 * 1/3 = -0.333 0 -0.666
CVC3 0.999 * 1/3 = -0.333 -1
Total: -1
The following table shows which of the seven characteristic combinations the system assigns how many pieces:
CVC Result
CVC1 3
CVC2 3
CVC3 2
Total: 8
This means that each characteristic combination is assigned the relevant proportion from the table for each technical period for which the system can distribute 8 pieces. In the period 5/29-31, eight pieces are distributed to the three characteristic combinations.
The results are displayed schematically in the following figure:
Technical periods in which data is saved:
5/1-5 5/8-12 5/15-19 5/22-26 5/29-31
23 23 23 23 8
Disaggregation in technical periods at SKU level:
For value 23
23
8 8 7
For value 8
8
3 3 2
Disaggregation in technical periods at detailed level:
Now according to the above calculation,
CVC 1 gets value 35
CVC 2 gets value -35
CVC 3 gets value-30
The planning book values are:
CVC 1 33.623
CVC 2 -50.276
CVC 3 -16.101
Please note: 3 decimal places set for the key figure in the planning area, but this calculation is based on one decimal place.
Even then the differences should not be this high.
Please provide me some examples on disaggregation of kf based on another kf with no proportional factors maintained.
Thank you in advance for your help and support.
Kind Regards,
Hi
Your calculations seem to be in line with the <a href="http://help.sap.com/saphelp_scm50/helpdata/en/26/53f1f3758211d398490000e8a49608/content.htm">SAP help for rounding and disaggregation</a>
If there is no preexisting proportions in both KF1 and KF2 what you expected should be the values comng up. It is possible that there is any other proportions that are existing in the KF1 that dont appear in your selections but are causing this to aggregate in KF2. (if you have a remote cube you can LISTCUBE whats in the planning area and check all the CVCs)
it would be also a good idea to check both KF in a details( all) mode for the CVCs and also have the time buckets in technical periods and see if that matches your calculations
to see the planning book in technical periods, from the planning book ... go to the period structure settings and choose 9ASTORAGE. (you cant use this permanently in the planing books though)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.