0

# How to create a condition with scale by the material price?

Dec 12, 2017 at 09:12 PM

48

I have a requirement from a customer to build a condition for freight payment, in SAP-LE-TRA, related to the value of transported material.

Exemple:

Material value from 0 - 100.000, freight is 2,80% of material value

Material value from 100.001 to 300.000, freight is 2,50% of material value

Material value above 300.001, freight is 1,8% of material value

Any clue on how to do it?

Any help is appreciated.

Thanks

Cleberson Nascimento Dec 19, 2017 at 12:02 PM
0

Solved, I did it with developments (tables and formulas).

How I did:

- Created one formula to get the material value from the Purchase Order and assigned to a pricing condition (ZVNF), set it as statistical in the calculation scheme;

- Created 2 tables to store the condition value, one is the header and the other is the item (scale by 'up to' value);

- Created another formula to get the condition value from those 2 tables and assigned to another pricing condition (ZFN1) in the calculation scheme, set the basis value from the condition ZVNF;

Hope this can help someone else.

Thanks.

Share