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

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

10|10000 characters needed characters exceeded

Dec 19, 2017 at 12:02 PM

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.