Introduction -
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.
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.
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
Testing
Sales Order: 110 and 111 - >
Freight Units 200000250 and 200000251 were created.
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
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
Conclusion
This blog post walks you through various steps involved in collective settlement using grouping rules and rate determination accordingly.
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.
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 |
| >=300 | ZCUST_VIR | 15 | Per Kg |
| >=500 | ZCUST_VIR | 10 | 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
/SCMTMS/TCM_RULES - Grouping Rule
Assign grouping rule in Calculation sheet along with resolution base:
TM Fiori app Edit Calculation Sheet
Calculation Sheet and Grouping Rule
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
Rate Table based on weight and Destination Loc
Testing
- Create two Sales Order for the same destination with different requirement date
Sales Order: 110 and 111 - >
Sales Orders for the same destination
- Create outbound Delivery 80000173 and 80000173 for the above sales order
Delivery 80000173
Delivery 80000174
- 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
Freight Order charge calculation as per Ind Rate
Freight Order charge calculation as per Ind Rate
- 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
Collective FSD option
FSD posted for collective weight
Conclusion
This blog post walks you through various steps involved in collective settlement using grouping rules and rate determination accordingly.
- SAP Managed Tags:
1 Comment
