Hi Friends,
Recently we came across a requirement in transportation management where the freight value has to be calculated as fixed price till a minimum weight and then calculate as rate per weight unit. I just wanted to share how the requirement was handled.
Requirement:
I have a condition type, say FB00 (with access sequence) for freight calculation in transportation. The requirement is that the freight value has to be calculated as fixed price till a minimum weight and then calculate as rate per ton.
For example, let the minimum weight is 5 tons and rate per ton is 10 USD per ton. If the weight is 4 tons (or any value below 5 tons), then the condition should calculate over the minimum weight, that is 5*10 = 50 USD. If the weight is 6 tons (or any value above 5 tons), then the freight has to be calculated as the actual weight * rate per ton.
Solution:
I have achieved the solution through the following steps:
1. Create scale for Transportation Management.
2. Maintain the scale in the condition type of transportation management:
3. Maintain the condition record for transportation management in TK11 transaction.
4. Test the scenario:
Note: I used another condition type ZF04 referencing FB00, to achieve another business requirement. The calculation will be similar to FB00.
Case 1: weight 1 Ton: Condition Value = 50 USD
Case 2: weight 4 Ton : Condition value = 50 USD
Case 3: weight = 5 Ton: Condition value = 50 USD
Case 4: Weight = 6 tons, Condition value= 60 USD (6*10 = 60 USD)
Result:
Now, the system is calculating the freight cost as per the requirement.
Reference: Scales (SAP Library - Transportation (LE-TRA))
Courtesy: jrgen.lins
Thanks & Regards,
AKPT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |