Charge Calculation in SAP TM: Rate Tables & Freight Charges

Charge Calculation in SAP TM: A Complete Guide to Calculation Sheets, Charge Types, and Rate Tables

Freight costs are rarely reduced to a single figure. A single shipment may be accompanied by a base cost for freight and a fuel surcharge the peak season surcharge and handling charges as well as customs fees, and two or more discounts, all calculated in a different way and incorporated into a particular order. If you do this incorrectly, you risk paying too much to carriers, underbilling customers or spending a lot of time reconciling invoices after the month's end.

This is the exact issue charging calculation in SAP TM (Transportation Management) was designed to fix. This is the system that determines the amount a shipment is expected to cost, based upon agreements rates, business rules that are set up within the system, ensuring that the cost of freight as well as customer billing and settlement are all constant and auditable.

In this article we explain how charge calculation functions in SAP TM as well as the concepts behind it along with the step-by-step calculation process and common errors in configuration and how it is integrated in the larger lifecycle of freight orders to settlement. It doesn't matter if it's an SAP TM consultant or logistics analyst or someone looking to evaluate SAP TM training this article will give you the complete, comprehensive understanding of the subject.

What Is Charge Calculation in SAP TM?

The charge calculation process in SAP TM is a process that the system uses to automatically calculates transportation charges for a freight booking or freight booking forwarding orders. It utilizes a predefined collection of master data items, including calculations sheets, freight agreements charges, charge types, and rate tables to determine which charges are applicable to a specific shipment and how they are calculated and when they are added up to the total cost.

The charge calculation output directly feeds into two key downstream processes:

• The settlement of the freight, in which SAP TM reimburses the carrier on basis of the calculated costs
• Forwarded settlement, also known as billing to the customer in which charges are billed to the customer

Since charge calculation is at the heart of both revenue and cost and revenue, its accuracy directly affects the visibility of margins and dispute resolution with carriers as well as customers.

Why Charge Calculation Matters for Logistics Teams

Costing for freight by hand doesn't scale. A mid-sized shipping company that works with many carriers on ocean, air, road and rail routes could effortlessly be dealing with hundreds of rate structures that are unique to each every one with its specific surcharges, minimums and validity dates. Without automation, teams could:

• Use flat estimates that do not reflect the actual terms of the contract which can lead to leakage of margins
• Manually verify invoices from carriers line by line
• Problem of explaining the billing differences to customers since there's no clear calculation logic

The charge calculation system of SAP TM tackles the three main issues. Since every charge is calculated from master data that has been configured rather than manually entered it creates an unambiguous and traceable log of calculation for each freight document. This is why the resolution of disputes with carriers, audits, and billing issues with customers simpler to solve.

Key Master Data Objects Behind SAP TM Charge Calculation

Before we look at the actual calculation process it is important to know the elements which drive the process. Think of them like layers with each is reducing from a larger contract to a certain number.

1. Freight Agreement

The freight agreement defines the commercial contract between a carrier or a customer. It defines the nature of the contract, as well as the validity period, the transportation mode that are covered, as well as the business partner who is involved. A freight agreement may contain different calculation sheets, based on the shipping stage or mode of transportation like pre-carriage main-carriage and post-carriage.

2. Calculation Sheet

Calculation sheets are the primary structure that is responsible for the charge computation. It's a hierarchical chart that lists the charge types that are allowed in the document as well as the exact order in which these charge types are assessed. Since the line items of calculations sheets can be placed in a nested arrangement or made dependent upon previous calculations, it can support an extremely sophisticated pricing system such as a base freight rate that is first calculated, followed by the fuel surcharge, expressed as a percentage of the base price, and then an agreed discount.

Calculation sheets basically answer three questions on every charge line: which charge is applicable, how it calculated and how is it analyzed relative the other charge.

3. Charge Types

A charge type is a classification of the charge line in its entirety such as base rate charge, the fuel surcharge or handling fee or discount. Charge types can be set up in customizing under Transportation Management basic functions, charge calculation Basic Settings delineating charge types. Each type of charge has specific attributes that govern the way it is used during calculation for example:

• It is a matter of whether it will result in an amount that is positive or negative (a discount for example generally is negative)
• If it is expressed as an absolute number or as a percentage
• What charge category and subcategory to which it is in order to report and group for reporting and grouping
• The usage of its charge is what determines if it can be utilized in particular calculations sheet or table of rates

Charge types may be classified according to charge category and subcategories to help keep charge structures that are large well-organized, which is crucial when an organization is managing hundreds or even thousands of charge lines that are distinct across different carriers.

4. Rate Tables

In the event that the calculator sheet outlines the charges that are applicable and when the rate table outlines the price. Rate tables are structured price lists that are that is tied to a particular charge type. The system assigns the rate table to a calculation sheet line item if the charge types are compatible and the pricing information is appropriately mapped to the appropriate charge.

Rate tables can be constructed with various dimensions based on the amount charged, such as per unit or range of weight, or per mile or in a flat amount and have their own validity dates.

5. Scales

Scales determine how the numbers in a rate table alter depending on factors such as volume, weight or distance. For instance, a scale could specify that the cost of freight per kilogram will decrease once the weighs over a particular threshold. Scales enable the single rate table to display graduated or tidied pricing instead of one flat rate.

The relation is like this the freight agreement comprises calculation sheets, calculations sheets are used to reference charge types within the order they are specified and each charge line item is pulled from its actual value from a table of rates which is formed by the scales.

Step-by-Step: How the Charge Calculation Process Works

If a freight request or freight booking forwarding order is made or updated in SAP TM The system will run a process of rating freight which generally is based on these steps.

1. The agreement is determined. The system identifies the relevant freight contract by analyzing the transaction information including the type of transportation, service, carrier modes, and location. If there are multiple agreements that match each other, the system will use either a specified led charge kind or priority settings to determine which one is more important.
2. Calculation sheet collection. Once the agreement is chosen it determines the calculation sheet in that agreement is applicable to the document, based upon the mode of transport, the stage of shipment or other requirements that are defined during the setting up.
3. Evaluation of charge type. The system works through the line items on the calculation sheet in order, evaluating every charge type pertinent to this document.
4. Base calculation and table search. For each charge line, the system calculates the base of calculation (for instance gross weight volume, volume, or the quantity of packaging) and searches the relevant rate table.
5. Scale program. Using the calculation base as an input it examines the scale in the rate table to find the right rate tier, and then returns the value.
6. Calculation of charge value. The charge value is calculated either in absolute value or as a percentage an earlier charge, depending on the way in which the type of charge and the calculation sheet line item is configured.
7. Logging and summation. All calculated charge values are combined into one total, and the system keeps a detailed record of the calculation. The log file is among the most effective tools for troubleshooting that is available, since it details the exact agreements, calculations sheets and rate table was used to calculate each charge line.
8. Results display. The calculated charges appear directly on the freight or freight booking forwarding order. From there, they feed into settlement.

Since this entire sequence is controlled through configuration rather than manually entered data, any modification to a freight agreement calculation sheet or rate table will be reflected in the calculation of future charges without requiring modifications to the documents used to conduct transactions.

Charge Calculation and the Freight Settlement Process

Charge calculation isn't all that is left of the tale. After charges are calculated based on a freight order, that information flows into freight settlement where SAP TM generates the actual invoices to the freight carrier. On the other hand, for the customer the same structure is used to support forwarding settlements, where the charges calculated from an order for forwarding serve as the basis for invoices to customers.

This is the time when freight terms are brought into the picture. Freight terms define the way in which collect and prepaid charges are handled by, for instance, in calculating prepaid charges on the export leg, and collecting fees for import portion of the same order for forwarding. Making sure that freight terms are correctly set with charge types is vital for international shipments, when various companies are responsible for various costs for different parts.

Because both of the settlement processes draw straight from the process of calculation, differences between the amount a business pays carriers and the amount it bills customers can be much more easy to track. If a particular number appears incorrect on an invoice the calculation log can point directly back to the line item on the calculation sheet and the rate table for that.

Common Challenges in SAP TM Charge Calculation

Teams who implement or manage the charge calculation process in SAP TM often face the same problem:

• Rate table and charge type do not match. The system only connects a rate table with an item on a calculation sheet when the charge types are exactly compatible. A tiny configuration mistake is a sign that a line of charge is unable to calculate, and is usually found only after an invoice appears to be insufficient.
• Conflicting or overlapping contracts. When multiple freight agreements are applicable for the same shipping, ambiguous priority or the type of leading charge configurations could cause the system to choose the wrong one which can result in incorrect pricing.
• Poorly designed calculation sheets. Calculation sheets that don't follow logically such as, for instance, using an a percentage-based surcharge prior to when the basis charge has been calculated result in charges that aren't in line with the commercial intent.
• Gaps in scale. If a rate table's scale does not encompass the entire range of possible weights and volumes shipping outside the tiers defined can not calculate, and default to an incorrect rate.
• Charge misuse. Since charge usage limits the rates tables or calculation sheets that a particular charge type can be utilized in improper usage settings could stop charges that are correctly configured from being made available when required.

The majority of these issues can be prevented by a strict master data setup procedure and by examining the log of calculations in the course of testing, not only when you go live.

Best Practices for Configuring Charge Calculation in SAP TM

• Establish the charge category and its subcategories in the early stages prior to the time that charge types multiply across modes and carriers to ensure that reporting remains organized.
• Create an default calculation base for each type of charge if it is it is possible. This helps reduce mistakes in manual entry when new line items for calculation sheets are added.
• Utilize leading charge forms or clear priority rules for agreements when multiple agreements may be in effect for the same transportation mode or route to ensure that there is no confusion in the agreement.
• Calculation sheets for test against actual scenarios of shipments, including edge cases, such as those which are located right at the boundary of scale, prior to shifting the configuration to production.
• Examine the calculation log as element of any investigation into charge discrepancies. It's usually faster than manually making calculations by hand.
• Keep rates tables and scales up to date to reflect current renewals of carrier contracts, as the absence of accurate rate data is among of the leading reasons for settlement disputes.

Charge Calculation in SAP TM vs Traditional TMS Pricing

As opposed to more simple transport management software that use rates that are fixed or manually entered The charge calculation system of SAP TM has been designed for high-level of complexity. The distinction between charge sheets, calculation sheets, rates, types, and scales, means that the same structure can show tiered pricing as well as multi-leg international shipping, mixed terms for collect and prepaid as well as the specific surcharge logic of each carrier with no any custom development. For businesses that have a large and diverse base of carriers, this system-based approach to freight rate is among the main reasons for choosing SAP TM over other less-weight options.

Frequently Asked Questions

• How is the charge calculated within SAP TM? Charge Calculation in SAP TM is the automatic method of determining the transportation costs for freight bookings, freight orders and forwarding requests using master data that is configured, such as calculations sheets, freight agreements as well as charge types rates tables, and charge types.
• What exactly is a calculator worksheet in SAP TM? A calculation sheet is an hierarchical table that specifies the charge types that are applicable to a particular document as well as the order in which the system analyzes them which allows for charges to be placed in nested groups and dependent on previous calculations.
• What's the distinction between charges types and rate table in SAP TM? A charge type defines a charge line, for example, fuel surcharge or base freight and defines the behavior and behavior, while rates tables store the actual price information for the charge type, and the way in which prices differ by the size.
• What is the process by which SAP TM decide which freight agreement to use for a particular shipment? The system determines the freight agreement on the basis of details of the freight order or booking. If several agreements are in agreement the system uses either a specified lead charge or priority settings to choose the right one.
• Where are charge types set up on SAP TM? Charge types are defined in Customizing, under Transportation Management Basic Functions charge calculation, basic settings Definition of Charge Types.
• What does the role of scales play in SAP rate tables for TM? Scales define how rates table values alter depending on variables such as weight volume, distance, or weight and allow one rate table to show an escalating or graduated price instead of a flat rate.
• What is charge calculation linked to the process of freight settlement? Charges calculated on the basis of a booking or freight order are directly incorporated into freight settlement for payments to carriers as well as charges for forwarding orders are incorporated into forwarding settlements for invoices to customers and invoicing, ensuring that both processes are consistent.
• Does charge calculation in SAP TM accommodate prepaid and collect charges for the same shipping? Yes. The terms of freight in SAP TM are able to be configured to ensure that, for instance that prepaid charges are calculated for the export portion and collect charges are calculated for the import part from the identical forwarding purchase.

Final Thoughts

Charge calculation is among the areas in which SAP TM's deep configuration capabilities really pay off in daily operations. When calculation sheets and charges types, rates tables and scales have been set up properly, the system can handle charges that otherwise necessitate constant manual intervention leaving an easy traceable and auditable for each charge for every single shipment. For SAP TM consultants as well as team members in the logistics department, knowing this system in detail is among the most practical abilities to acquire, as it is at the crossroads of configuration for the system as well as cost management for carriers and the accuracy of customer billing.

If you're looking to gain the skills you need to be proficient in SAP TM that includes the calculation of charges freight settlement, charge calculation, and other end-to-end transportation procedures look into SAP TM Training offered by ERPVITS for the best training in a structured and practical manner from skilled trainers.