on 09-25-2006 5:48 PM
How does the internal distribution logic for the planning
function 'Distribute to Reference Data' work?
For the distribution I have set up the following distribution planning functions:
4. For distribution from Sales Rep to Customers
Definiton of Level
- among other things:Chararcteristics:
Key Figures:
INT4
- 4-byte-integer, integer number with sign /Length 10 , Decimal Places 0
)DEC
: Counter or amount field with comma and sign /Length 17, Decimal Places 3
)Definition of Planning Function 'Distribute with Reference Data'
Definition of Parameter Group
1. Example:
2. Example:
Hallo Evi,
The rounding problem occurs, when you copy the data from from Excel Data sheet and just paste it in the Excel-In place in BPS.
Eventhough after pasting the values, the values seems to be transferred properly, but after saving it into the cube, one notices the rounding problem.
In order to overcome the rounding problems, one should always set the number of decimal places to required precision using the button "add decimal places" (Dezimalstelle hinzufügen), the next button to Euro symbol () for all cells.
Best regards!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Thank you for your answer!
I haven't uploaded or copied plan data from Excel into the planning folder.
The Excel calculation was just in order to test the results of the SEM BPS distribution function. At first I executed the planning function and then I did the Excel calculation and then I compared the SEM BPS data with Excel-data (data calculated via Excel). I saw that e.g. in example 2 SEM BPS calculated for the following customers the following values:
Customer 7000100341, which should get <b>4%</b> of 36 pieces, gets <b>1 piece</b> (calculation via Excel: 4% of 36 = 1,440)
Customer 7000100511, which should also get <b>4%</b> of 36 pieces, gets <b>2 pieces</b> (calculation via Excel: 4% of 36 = 1,440)
Customer 7000100598, which should get 4,69% of 36 pieces, gets 1 piece (calculation via Excel: 4,69% of 36 = 1,688)
Customer 7000109789, which should get 9,23% of 36 pieces, gets 4 pieces (calculation via Excel: 9,23% of 36 = 3,323)
I don't unterstand the results of the SEM BPS distribution function, especially for these four customers.
The result of the planning of the quantity in pieces should be a whole-number (integer). That means the result should be a number without decimals. But I don't unterstand the internal SEM BPS rules, which comes to the whole-numbers (integers).
Do you have any idea?
Best regards, Evi
Hi I have done some analysis and came to the conclusion that while SAP is distributing these values one by one , it also keeps a running total of the distribution done so far. While doing the distribution for the next value it keeps track of the rule of rounding [<0.5 = 0, >0.5 = 1] for the running total so far as well.
This is the reason why 4% of 36 gets 1 in first occurance and the very next occurance gets 2.
See the corresponding values in the table you gave:
CustomerNo,_____%,SAP,_Excel,SAP_Run_Total,Excel_Run_Total
7000100035,_____6,__2,__2.16,____________2,___________2.16
7000100142,_____2,__1,__0.72,____________3,___________2.88
7000100144,_____9,__3,__3.24,____________6,___________6.12
7000100163,_____5,__2,__1.80,____________8,___________7.92
7000100233,__2.13,__1,__0.77,____________9,___________8.69
7000100341,_____4,__1,__1.44,___________10,___________10.13
7000100511,_____4,__2,__1.44,___________12,___________11.57
7000100598,__4.69,__1,__1.69,___________13,___________13.26
7000100817,__4.87,__2,__1.75,___________15,___________15.01
0000000000,__1.33,__0,__0.48,___________15,___________15.49
7000109119,__2.62,__1,__0.94,___________16,___________16.43
7000109789,__9.23,__4,__3.32,___________20,___________19.75
0000000000,__0.48,__0,__0.17,___________20,___________19.93
7000110969,_34.52,_12,_12.43,___________32,___________32.35
7000111076,__2.47,__1,__0.89,___________33,___________33.24
7000111327,__2.64,__1,__0.95,___________34,___________34.19
7000111418,__3.11,__1,__1.12,___________35,___________35.31
7000111808,__1.55,__1,__0.56,___________36,___________35.87
0000000000,__0.36,__0,__0.13,___________36,___________36.00
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.