Transportation Cost VI01

[Former Member]

In shipment cost / freight cost (VI01) we need to distribute transportation cost throw the weight of each subposition. Nowadays, the total cost of the transport is set to the last subposition. We need the following:

For example:

Total Transportation Cost: USD 500.-

Pos. -

---

Weight -

---

Cost

10 -

---

30kg -

---

USD 150.-

20 -

---

70kg -

---

USD 350.-

Is it possible to do this in SAP? Any ideas?

Nowadays, it works like this

Total Transportation Cost: USD 500.-

Pos. -

---

Weight -

---

Cost

10 -

---

30kg -

---

USD 000.-

20 -

---

70kg -

---

USD 500.-

Thanks in advance.

Esteban

Poinst will be assigned!

[Former Member]

I solved it.

I have created a formula, and added some code there to calculate what I needed!

[Former Member]

Hi Lakshmipathi!

Thank you for your answer, but I´m still having some questions:

Where do I have to load the USD 500 amount ? In the sales order?

I have to put several sales orders / deliveries into the transportation document, so I donu2019t know whatu2019s the amount for each sales order / delivery at the moment of creation of each document.

In addition, I have information of the transportation document that modifies the calculation of the expense of freight. At the moment I create the sales order, I do not have the cost of freight.

That´s why I have to calculate everything when I create the document with transaction VI01. In this moment, I have the whole information.

Any ideas?

Thanks in advance!

Esteban

[Lakshmipathi]

Dear Este Wild

Go to V/06, create a header condition type say ZFRE and maintain the following

Cond. class:::::::::A

Calculat.type:::::::B

Cond.category::::::F

Plus/minus::::::::::A

Group condition::::X

Header condition:::X

For the field Manual entries, you can maintain either C or D, depending upon your requirement.

Maintain the above condition type in your pricing procedure with Account Key as ERF.

Now create a sale order / delivery and against the condition type ZFRE, input the value USD 500, and you can see that the freight amount is proportionated equally based on your weight.

thanks

G. Lakshmipathi