cancel
Showing results for 
Search instead for 
Did you mean: 

Rate Table with weight band and percentage

Former Member
0 Kudos

Hi there,

I am currently trying to create a rate table for fuel surcharge calculation, which should determine a percentage depending on the gross_weight.

Example:

< 1000 LB -->  10%

>= 1000 LB -->   20%

Here is how the charge calculation should look if the weight is 500 LB:

Charge TypeLine No.Reference line fromChargeRate
Truck10$1000
FSC2010$10010%

Does that make sense?

Any suggestions?

I need to be able to model this in SAP TM 8.0

Thank you,

Adrian

Accepted Solutions (1)

Accepted Solutions (1)

tarunkumar
Active Participant
0 Kudos

Hi Adrian,

You can achieve it by modelling a rate table for FSC having goss_weight as a calculation base and keeping the 'calculation type' as absolute for your scale items. Also for your charge type(in customizing) you have to maintain value as percentage.

System will automatically take the value from rate table and apply it as a % on the reference line.

Thanks & Regards,

Tarun Kumar

Former Member
0 Kudos

Hi Tarun,

It worked like a charm. Thank you for the quick reply. 

I did have Gross_Weight as the calculation base. However, I had the scale values as relative, which required a calculation rule, which doesn't work for this example.

Thanks again.

Regards,

Adrian

Answers (0)