Freight Calculation based on the net value of the Line item

[Former Member]

Hi SAP Gurus,

I have one requirement for Freight calculation(Sales order is created through an IDOC) :

In the idoc,we will receive a freight dollar amount - which will be the total amount of freight.(example 100)

We will also receive sales dollar for each line item ,which is then passed to the pricing procedure, for a total amount of sales for that Sales order.

(examples below, for a total of 1500)

The 100 is to be posted to a freight G/L account.

The 100 is further divided by each profit center of the materials on the Sales order.

The freight is split out amongst the profit center , based on the net value of the line item.

Freight value to be allocated = Line item value/total value of the sales order * Freight amount.

Total of the sales order =1500

Line item value Freight value calculation Profit center

Material A: 800 800/1500*100 = 53 Profit center A

Material B: 500 500/1500*100 = 33 Profit center B

Material C: 200 200/1500*100 = 13 Profit center C

Please let me know how to achieve this functionality in pricing procedure or what changes i need to make in Freight condition type.

Thanks in advance,

Bhakar Saha

[Former Member]

Were you able to resolve this issue of allocating freight costs to line items/profit centers using the net value of the line items?