SAP TM rate table for product and stage

[former_member688963]

Hello experts,

I am using road freight orders and I need to use rate tables, schemes and freight agreements to calculate costs in freight orders. So I need a specific rate table for each product so than in freight order I will be able to see costs for every stage that is loaded with FUs with that product. I know that I need to specify a scale in rate table as "PRODUCT_ID" and Calculation Resolution Base in Scheme as "PRODUCT". For example:

I have a FO with 3 stages

1) Location A ---> Location B loaded with 10 FUs of Product1 each 1 ton

2) Location B ---> Location A empty

3) Location A ---> Location B loaded with 5 FUs of Product2 each 1 ton

I have 1 rate table with 2 rows:

1) Product1 = 10$/ton

2) Product2 = 8$/ton

Should I create a Scheme with 2 rows with both rate tables and Calculation Resolution Base in Scheme as "PRODUCT"? Or any other suggestions so I can get this Result:

1) Location A ---> Location B || 10 * 10 = 100$

2) Location B ---> Location A ||

3) Location A ---> Location B || 5 * 8 = 40 $

Regards,

Georgiy