SAP S4HANA (1909) TM Collective Rate Determination and Collective Settlement
In this blog post, you will learn how the grouping rule can be used in SAP TM to enable users to create collective settlement documents for multiple Freight orders wherein you can choose to sum up the values of the calculation bases with scales of different dimensions (as specified in the grouping rule) in multiple freight orders and determine a rate for the collective value.
The system controls the grouping based on the resolution base.
Using the grouping rule, the rates are fetched for the combined data source value of the charge items, not individual data source values. In this blog, you will understand this well using a sample scenario.
Carrier ZCARINT02 (XYZ Logistics Ltd.) regularly shipped material from plant ZVP1 (Shipping point location SP_ZVS5) to customer ZCUST_VIR.
A Truck goes 3-4 times weekly to the same destination. Using collective settlement and collective rate determination, the total freight cost can be saved rather than spending for each shipment and this was agreed upon with the carrier to post freight settlement on a weekly basis and the total weight shipped that week.
Below are the rate table charges agreed upon.
|Rate Table Weight Based|
|Gross Weight||Destination||Rate in INR||Unit|
|>= 100||ZCUST_VIR||20||Per Kg|
In this example, we will consider two freight orders shipped in a week. The next section will show you in detail how the collective rate gets determined while posting collective FSD.
Solution Approach –
The following section provides an important configuration step to process the collective settlement using the grouping rule in SAP TM.
Create a grouping rule for a resolution base
In this sample scenario, we are going to group based on the destination location. That means all freight orders for the same destination for a given carrier, the collective settlement can be posted.
T Code – /SCMTMS/TCM_RULES
Assign grouping rule in Calculation sheet along with resolution base:
TM Fiori app Edit Calculation Sheet
Create and Maintain Rate Table based on weight and scale as DESTINATION LOCATION
The rates are maintained as per weight and destination location which is part of the grouping rule.
TM Fiori App ->Maintain Rate Table
- Create two Sales Order for the same destination with different requirement date
Sales Order: 110 and 111 – >
- Create outbound Delivery 80000173 and 80000173 for the above sales order
- Once Delivery saves Freight Units are created in the background automatically.
Freight Units 200000250 and 200000251 were created.
- Using TM Optimizer freight units are planned, and Freight orders are created along with carrier selection as per the carrier selection setting in the planning profile.
Charges are updated as per the new rate table mentioned in the freight agreement via the Calculation sheet.
FO1 -610000704 – Charges calculated as per gross weight rata table with rate 20 Per KG = 2700 INR
FO2 -610000705 – Charges calculated as per gross weight rata table with rate 20 Per Kg = 5400 INR
- Create and Post collective Freight Settlement Document using TM Fiori app > Freight order for settlement worklist. Choose option Collective from the dropdown. This will consider the total weight of both freight orders and apply the rate table for the total weight.
So the total weight of both freight orders is 405 KG and as per the rate table for gross weight, more than 300 KG is 15 INR per KG. Hence total FSD value is 405 X 15 = 6075 INR
This blog post walks you through various steps involved in collective settlement using grouping rules and rate determination accordingly.