Distribute freight value through freight order stages

[former_member574375]

hi, I would like to have an idea on the following requirement regarding pricing in TM

The rate table is based on means of transport / shipping point transportation zone / customer transportation zone. The transport may contain more than one destination zone. If so, the rate used will be the one defined for the shipping point transportation zone and the last transportation zone (longest distance).

But we must calculate freight values for each stage, these values being a distribution of the overall value (source zone-last zone) based on the weight. Rates are FTL.

Example:

rates

SP_001 - Transportation zone 1 - 500 USD customer 1

SP_001 - Transportation zone 2 - 800 USD customer 2

SP_001 - Transportation zone 3 - 1000 USD customer 3

The shipment will deliver goods to these 3 customers.

Stages would be:

Origin destination delivery weight (not the total stage weight)

SP_001 --> customer 1 200 kg

customer 1 --> customer 2 300 kg

customer 2 --> customer 3 500 kg

Freight = 1000 USD (for transportation zone 3)

Then, the value for each stage should be:

200 USD

300 USD

500 USD

Using LE-TRA this would be easily done using header conditions, but I don't know how to do this in TM.

Is there a standard way to achieve this?

We are using embedded TM in S/4, 2021.

Thanks for any help.

Paulo Café

[former_member612493]

Hi Paulo,

Use Calculation resolution base as Stage at Calculation sheet level.

Thanks & Regards,

Raju

[former_member574375]

Hi Raju, thank you for the answer but when I use "STAGE" in the calculation sheet the values are gone (see picture). The upper picture is for ROOT resolution, the lower one, STAGE. We do not have details of the stage calculation. (calculation profile is defined per stage too)cost-calculation-non-stage-stage.jpg

Best regards,

Paulo Café