Defining Calculation Sheets

When setting up the calculation sheet, you can specify the following:

General data

The general data contains charge usage. Charge usage determines if the calculation sheet is valid for the customer and/or service provider.

Hierarchy items

Under the hierarchy items, you can specify the instruction, charge type, and instructions on how the charge type should be calculated. This calculation schema shows the steps and the specifications that the system takes into account during calculation.

Preconditions and general terms

Preconditions can be specified in the assignment of the calculation sheet to the freight agreement. Such conditions for applying the calculation sheet, and payment terms or other general terms, can be specified.

The Items screen area contains the details of the calculation sheet items and you can create rate tables for each calculation sheet item.

The following columns are mandatory in the Items screen area:

Instruction Type

Sum: This is used to evaluate the total sum of all the lines under the sum line. The charge item with the sum instruction evaluates the sum of all the lines below. Each calculation sheet has an initial mandatory sum line. You cannot delete this line. You can only maintain the rounding rule for this line because you cannot define a charge type.

Subtotal: This is used to evaluate the subtotal amount of all lines included in a range defined by a reference-from line and a reference-to line.

Standard: This is a standard line, as this charge item results in a direct charge when the item refers to a charge type.

Compare High/Low Value: This evaluates the line to be considered for the calculation among a set of two or more lines. This evaluation is based on the highest or the lowest value of the affected lines. You use this value in combination with the Operation attribute. This charge item triggers a comparison of other charge items. If you set the operation to High, for example, the most expensive charge item remains and the cheaper charge items are deactivated.

Charge types

This is an itemized list of valid transportation charges. Charge types can be grouped into categories or subcategories. During calculation, it can result in a positive (surcharge) or negative (discount) value. If the charge item represents a percentage, it must refer to another charge item or subtotal that produces an absolute value to result in a chargeable amount.

Rate table details

Charge type instructions are sometimes called rate table details, consisting of the specifications for how the charge type will be processed.

The Rate Table/Charge Type details area contains the following important information:

• Rate
• Basic Data
• Classification
• Preconditions
• Notes

The Rate tab page of the Items screen area has the following important fields:

• Amount: If you maintain this field, the charge item is not derived or calculated but is always equal to this amount.
• Currency/Percentage: You can enter eight, the currency code, or %.
• Reference-From and Reference-To line numbers: If the calculated amount falls outside the minimum or maximum amounts specified here, these values are substituted.
• Rate Table Determination Rule: This rule determines the rate table from which the single charge item is derived using a condition or a BAdI.
• Rate Table: The rate table is fixed and predefined for each charge item. The rate calculation works in the same way as the rate table determination.
• Calculation Rule: The value with which the single rate is to be multiplied.
• Index Table: The index table is used, for example, to calculate the fuel surcharge.

The Basic Data tab page of the Items screen area has the following important fields:

• Charge Type: The types of transportation charges such as haulage, ocean freight, and fuel surcharge.
• Manual Charge Item: If you select this checkbox, the system does not calculate the charges for this charge item, but instead expects you to enter an amount manually.
• External Calculation Flag: This specifies whether the system uses an external charge engine, such as SMC3.
• Logistical Data Specification: You can specify logistical data, such as stage category, shipping type, or dangerous goods for which the charge type is to be applied.
• Resolution Base: This defines which logistical data is used to determine the rate. Logistical data can be booking, container, main item, package, root (or Header of the document), or document stage. You can also determine if a grouping rule is to be used to group selected input data together, such as stages. The group stage is then the basis for a new charge item, that is, this rule is used together with the resolution base.
• Rounding Profile: You define if and how the calculated amount or charge is rounded.

  Adjustment Profile: This allows you to change all involved calculation bases. You use this profile, for example, to adjust the logistical weight by any factor or logic. That is, you adjust the gross weight in such a way that the system only considers the chargeable weight for the rate table access

• Dimensional Weight Profile: If the charge type is relevant for dimensional weight calculation, a specification of dimensional factor, such as Imperial cubic pound factor 166 or 194, is applicable. Metric factors can also be specified.
• Calculation Method Type and Calculation Method: You can enable a special calculation method for each charge item, for example, whether the system calculates the charges by considering the break-weight or not.

The Classification tab page has the following important fields:

• Mandatory: You use this field in preconditions and for checks based on Business Add-Ins (BAdIs). If the system cannot calculate the charge item properly, it creates a warning message. If the system cannot calculate a mandatory charge item, it creates an error message during invoice creation before transferring it to SAP S/4 MM.
• Tax: Indicates that the charge is a tax.
• Statistical Charge: The charge is informational or statistical only and not to be charged to the customer.

The Preconditions tab page has the following important field:

• The Preconditions tab contains the Precondition rule field. The precondition rule checks if certain charge items are to be processed before charge calculation, according to the given logistical data source.
• On the Notes tab page, notes can be added, distinguished by text type.

During charge calculation, the system determines the calculation resolution base by the origin of the data upon which the charge aspect is based.

For example, you want to determine the freight rate based on the gross weight of the order. To do this, you must use the calculation resolution base of the root. However, if you want to calculate the freight on a prepackage basis, the calculation resolution base should be package.