cancel
Showing results for 
Search instead for 
Did you mean: 

Distribute with Reference Data

Former Member
0 Kudos

How does the internal distribution logic for the planning
function 'Distribute to Reference Data' work?



It should be made a sales plan on product level. At first the sales plan should distributed top down according to given ratios. In detail the sales plan should distributed from sales organisation to sales offices, from sales office to sales groups, from sales group to sales reps and from sales rep to customers.

For the distribution I have set up the following distribution planning functions:



1. For distribution from Sales Organisation to Sales Office:

Similar to 4. For distribution from Sales Rep to customers (please see 4.)

2. For distribution from Sales Office to Sales Group

Similar to 4. For distribution from Sales Rep to Customers (please see 4.)

3. For distribution from Sales Group to Sales Rep

Similar to 4. For distribution from Sales Rep to Customers (please see 4.)

4. For distribution from Sales Rep to Customers



Definiton of Level

- among other things:

Chararcteristics:


Planning Area = Area Plan
Planning Version = Version Sales Plan
Value Type = Type Plan
Product
Sales Organisation
Sales Office
Sales Group
Sales Rep
Customer
....

Key Figures:


Sales Quantity Plan (BW definition:

INT4

- 4-byte-integer, integer number with sign /

Length 10 , Decimal Places 0

)
Ratio Quantity Customer (-> Precentage % in format xx,xx for distribution to Customer (BW definition:

DEC

: Counter or amount field with comma and sign /

Length 17, Decimal Places 3

)
...

Definition of Planning Function 'Distribute with Reference Data'



With

Fields to be changed:
Customer

Fields for contition:
Key Figures
Planning Version
Value Type

Reference Character:
Key figure name
Local currency
Planning Version
Planning Area
Value type


Definition of Parameter Group



With

'Only Distribute Unassigned' is not activated.

Conditions:
Key Figures = Sales Quantity Plan (BW definition: see above)
Planning Version = Version Sales Plan
Value Type = Type Plan

Reference Data:
Key figure name = Ratio Quantity Customer (BW def.:see above)
Local currency = #
Value type = Type Plan
Planning Version = Version Ratio Customer
Plannig Area = Area Ratio

After execution of the distribution function I have gotten the
following results and I have compared these SAP results with Excel
calculation. I don't unterstand the rounding in SAP or rather the logic
to make the balance for the integer (whole-number) of sales quantity in
SAP? Which rules does SAP use in this case?

1. Example:


E.g Sales Quantity of 353 pieces for Sales Rep are distributed to
Customer according the following ratios:

Customer |% |Excel |SAP
7000100035 |6 |21,180 |21
7000100142 |2 |7,060 |7
7000100144 |9 |31,770 |32
7000100163 |5 |17,650 |18
7000100233 |2,13 |7,519 |7
7000100341 |4 |14,120 |14
7000100511 |4 |14,120 |14
7000100598 |4,69 |16,556 |17
7000100817 |4,87 |17,191 |17
7000101147 |1,33 |4,695 |5
7000109119 |2,62 |9,249 |9
7000109789 |9,23 |32,582 |33
7000109849 |0,48 |1,694 |1
7000110969 |34,52 |121,856|122
7000111076 |2,47 |8,719 |9
7000111327 |2,64 |9,319 |9
7000111418 |3,11 |10,978 |11
7000111808 |1,55 |5,472 |6
7000111903 |0,36 |1,271 |1
Customer planned 353

Especially please look at assigned sales quantity to customer 7000109849.

2. Example:


E.g Sales Quantity 36 for Sales Rep are distributed to Customer according the following ratios:

Customer |% |Excel |SAP
7000100035 |6 |2,160 |2
7000100142 |2 |0,720 |1
7000100144 |9 |3,240 |3
7000100163 |5 |1,800 |2
7000100233 |2,13 |0,767 |1
7000100341 |4 |1,440 |1
7000100511 |4 |1,440 |2
7000100598 |4,69 |1,688 |1
7000100817 |4,87 |1,753 |2
0000000000 |1,33 |0,479 |
7000109119 |2,62 |0,943 |1
7000109789 |9,23 |3,323 |4
0000000000 |0,48 |0,173 |
7000110969 |34,52 |12,427 |12
7000111076 |2,47 |0,889 |1
7000111327 |2,64 |0,950 |1
7000111418 |3,11 |1,120 |1
7000111808 |1,55 |0,558 |1
0000000000 |0,36 |0,130 |
Customer planned 36

Especially please look at assigned sales quantity to customers 7000100341, 7000100511, 7000100598 and 7000109789.


Thank you and best regards, Evi Jäger

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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!

Former Member
0 Kudos

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

0 Kudos

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