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
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.