Creating Rate Table / Calculation Sheet.

[Former Member]

Hi Gurus,

I have the following requirement.

Rate table has to be prepared based on 2 criteria.

1. Distance Travelled.

2. Cargo Quantity

For ex: If a Truck travels 1000 kms with 50 Ton cargo,

then the price is calculated as 1000*50*20 (where 20 is the rate per km)

How this can be implemented in a rate table.

Distance - Consider I have only 4 Distance slabs - i.e  Scales - 100, 500, 700, 1000 KM

Quantity - Whatever quantity is transported.

Price - 20, 18, 16, 15 for the above 4 distance scales.

How Rate table / calculation sheet prepared for the above requirement,

Any Help appreciated. Thanks.

Message was edited by: Deepan M

[tarunkumar · Accepted solution]

Hi Deepan,

You need to create a rate table with one calculation base (ACTUAL_DISTANCE); maintain scale items as 100, 500, 700 and 1000 and maintain your rate values against these scale items.

After that go to calculation rule tab and maintain a calculation rule with ACTUAL_DISTANCE and another calculation rule with QUANTITY_VAL keeping calculation rule quantity as 1 for both.

Later attach this rate table to your TCCS, your scenario will work.

Thanks & Regards,

Tarun Kumar

[Former Member · Accepted solution]

Hi Tarun,

Thanks for the reply. Let me try this

One more clarification needed.

For Quantity_Val, consider capacity of vehicle is 50 MT.

Upto 45MT, whatever the actual cargo weight, charge should be calculated for 45MT,

beyond 45 MT actual weight should be calculated for charge calculation upto 50 MT

For ex :

if cargo weight = 40MT, rate = 20, Dist = 1000KM

charge = 45*20*1000

if cargo weight = 47MT, rate = 20, Dist = 1000KM

charge = 47*20*1000

How this can be implemented.

Thanks,

Deepan

[tarunkumar · Accepted solution]

Hi Deepan,

This logic to pass the right weight (45 or 47 in your example) you have to write in calculation base helper classes.

Earlier you mentioned "cargo quantity" so I proposed you to use QUANTITY_VAL calculation base as a dimension in your rate table but if your scenario is for weight of the cargo then you should use any weight based calculation base like GROSS_WEIGHT, NET_WEIGHT etc.

Thanks & Regards,

Tarun Kumar

[tarunkumar · Accepted solution]

one more thing, your scenario looks more like a BREAK-WEIGHT calculation logic. if you explain your problem statement further then it can be of help.

[Former Member · Accepted solution]

Thanks for the Reply , Tharun.

Here is the exact problem statement.

Upto certain weight, Whatever the weight transported, rate is calculated by a Minimum accepted weight.

For ex : Transported weight = 15MT.

Minimum accepted weight = 20 MT.

So upto 20 MT whatever the weight transported, the rate would be calculated for 20MT. Beyond 20 MT the actual weight will be used for calculation.

Can you please throw some more light on calculation base helper classes

Thanks.

[Former Member · Accepted solution]

Hi Mike

Have you solved your issue?

Regards

Eduardo Chagas

[Former Member · Accepted solution]

No.

[tarunkumar · Accepted solution]

Hi Michael,

Calculation base helper class can be created by implementing /SCMTMS/IF_TCC_CALC_BASE interface. This class has to be mentioned in your calculation base customizing and it will be called at runtime, now you can write the logic to pass the right weight 45 or 47 to the CT_CALC_BASE_VALUES parameter.

System will automatically consider this weight.

You can look at the code of /SCMTMS/CL_TCC_CB_DISTANCE class as a sample implementation.

Thanks & Regards,

Tarun

[former_member194187]

Hi,

Did you try to use calculation rule in rate table?

I think you can use calculation rule in rate table indicating that all rates are per kg

Regards,

Sunish

[Former Member]

Any help....?