I posted recently this same content at SCN and I decided to post it here too. It goes a little bit away of the main focus of this blog (SAP Brazil Localization and S/4HANA, HANA, In-Memory and etc.) but it is still SAP and I meant to help.

If you like it, please, go to SCN and rate my post there. Five starts are appreciated 🙂

The Links for SCN posts are:

LE-TRA – Config Guide for Shipment & Shipment Cost Document – Part I

LE-TRA – Config Guide for Shipment & Shipment Cost Document – Part II

LE-TRA – Config Guide for Shipment & Shipment Cost Document – Part III

I wrote this configuration guide for Logistics Execution Transportation (LE-TRA) sometime ago for my own reference and kept updating it while my company was changing the process, projects were going on, merges, acquisitions and etc. This document is more focused on freight payments and Shipment Cost Document, but it has a nice overview of all configuration required until a Shipment Cost Document can be created. This includes of course, the shipment configuration in a higher level.

I hope you enjoy reading as much as I enjoyed writing and I hope you find this helpful.

Index / Content

Part I

  1. SAP Language
  2. Transportation – Shipment
  3. Master Data
  4. Maintain Transportation Planning Point
  5. Define Routes
  6. Define Modes of Transport
  7. Define Shipping Type
  8. Defining Transportation Connection Point
  9. Defining Transportation Zones
  10. Define Transportation Groups
  11. Setting up Weight Groups
  12. Define Routes and Assigning Routes
  13. Definition of routes
  14. Maintain Stages for all Routes
  15. Determining Routes
  16. Route Determination in Sales Order
  17. Configuration of Shipments
  18. Maintain Transportation Relevance
  19. Set Up Transportation Planning Points
  20. Define Shipment Type

Part II

  1. Transportation – Shipment Cost Document
  2. Shipment Cost Document Structure
  3. Define Date Rules
  4. Define and Assign Tariff Zones
  5. Define and Assign Activity Profile
  6. Define Shipment Cost types
  7. Define Item Categories:
  8. Assign Shipment Cost Type and item categories
  9. Maintain Shipment cost relevance and default for shipment cost type
  10. Define shipment cost relevance for shipment type
  11. Pricing

Part III

  1. Define and assign shipping type procedure group
  2. Define and assign item procedure group
  3. Define Service Agent Procedure Group for Shipment Costs
  4. Maintain Price Procedure
  5. Define Pricing Procedure Determination for Shipment Costs
  6. Maintain Condition Type
  7. Settlement
  8. Assign Purchasing Data
  9. Account Determination
  10. Group Together Valuation Areas
  11. Define Valuation Classes
  12. Automatic G/L account Determination
  13. Automatic determination of CO assignments
  14. Business Process Procedure
  15. Create transportation condition records
  16. Create Delivery Document
  17. Create Shipment Document
  18. Creating Shipment Cost Document & Cost Settlement
  19. Effects of Shipment cost settlement and related documents
  20. User-Exits
  21. BADIs

SAP Language

Here are some common terms that you will see while dealing with LE-TRA in SAP:

Forwarding Agent / Service Agent – Agent who provides the transportation, also known as Carrier or Logistic Service Provider. This is usually (but not always) the vendor who will be paid by the freight service.

Routes – The route is a component of LE-SHP and plays an important role in the Shipping process creation and planning, determining itinerary (the leg or stage in the shipment), determines Means of Transport, like truck, train, plane or ship and they usually carry a departure point information (e.g. Shipping point) and Destination Point (port of destination, customer and etc).

Handling Unit – The handling unit is the packaging in the shipment that will contain the materials/products that are been transported. For example, in a shipment you may have all your products packed in a Container, then the container is your handling unit. However, depending on the size of the shipment you may have multiple containers and those containers are loaded in a big vessel, then besides the containers, you will also have a vessel as a packing unit, or a handling unit. The handling unit in a shipment can also be called “Equipment”. The Handling Unit plays an important role in the shipment cost calculation, they are represented as sub-items in the SCD items.

Shipment – The Shipment document containing details based on predecessor deliveries, including who are the service agents, the routes, what are the stages, and the deadlines for planning and execution times. This document is the pre-requisite to the Shipment Cost Document.

Shipment Type – Shipment type contain primary settings to the shipment document such like: the Direction (inbound or Outbound), number range, partner information, stage determination procedure and etc.

Shipment Cost Document – This document is created subsequent to the Shipment, using this document as reference. The Shipment Cost Document (SCD) contains the necessary data to pay the service agent (agreed rates, price, invoice party and etc.) and also accounting data (G/L Account, Cost Center and etc.) This document when created correct will be used in most of the times to trigger an accrual in the system.

Shipment cost type and item categories – Shipment cost types and item categories carry settings to control the shipment cost document, like number range, status requirements for the shipment documents, shipment costing settings, shipment transfer/settlement settings.

RatesRates are loaded in the system via Condition Technique (using condition types predefined) and they are carried over to the SCD when the document is created. The rates can be created in more than one condition to the same document, for example if you want breakdown the agreed freight cost with the service agent between what is freight service, what is toll, what is fuel surcharge and etc.

Transportation Planning Point – Aka. TPP, it is an organizational level in Logistics that is responsible for planning and processing shipments. They can also be represented by a group of people inside of the organization, for example, TPP for mode Ocean, TPP for mode Truck and etc, to segregate the Logistics Planners and also perform sap security segregation. Each Shipment is assigned to a TPP.

Transportation – Shipment

Master Data

  1. Business Partner Master Data > They are the Service-Agents (Freight-Forwarder), Ship-to, Sold-to, Bill-to, Brokers and Customs Agents, Carriers, Customers, Vendors and etc.
  2. Material master data > You can’t have a shipment without products (material). The material master data willdefine the products that will be transported and also they represents the handling unit (packaging material). All products and materials transported using the transportation system (shipments) must have a material master data.
  3. Organizational master data > To the whole process flow from Sales Order to Delivery, Shipping, Shipment Cost Document, Invoice Payment and etc., system will need to have the following Organization Level created and properly assigned: Business areas, Sales Organization, Sales Area, Distribution Channels, Transportation Planning Points, Plants, Routes, Shipping Points, Purchase Organization, Purchase Group, Controlling Area and etc.

Maintain Transportation Planning Point

TCODE SPRO or SM30
Path SPRO > Enterprise Structure > Definition > Logistics Execution > Maintain transportation planning point
Table/View V_TTDS

Also called “TPP”, it is an organizational level in Logistics that is responsible for planning and processing shipments. They can also be represented by a group of people inside of the organization, for example, TPP for mode Ocean, TPP for mode Truck and etc, to segregate the Logistics Planners and also perform sap security segregation. Each Shipment is assigned to a TPP.

A Transportation Planning point can be responsible for multiple Shipping Points and the Shipment is assigned to one transportation planning point only, which can contain multiple deliveries assigned and those may belong to multiple shipping points that belongs to the same transportation planning point:

Maintain Transportation Planning Point

In the same SPRO path, you assign the transportation planning point to a company code, as per screenshot above. This assignment is required to when the Shipment triggers a Shipment Cost Document, then the freight costs calculated are posted to the proper company code (see more below Shipment Cost Document and Settlement details).

Define Routes

The route is a component of LE-SHP and plays an important role in the Shipping process creation and planning, determining itinerary (the leg or stage in the shipment), determines Means of Transport, like truck, train, plane or ship and they usually carry a departure point information (e.g. Shipping point) and Destination Point (port of destination, customer and etc)..

TCODE 0VTC
Path SAP Easy Access > Logistics > Logistics Execution > Master Data > Transportation > Routes > Define Routes > Define Routes and Stages
Table/View TVRO

To create the routes, you need to do the following:

  • Inform the modes of transport that will be assigned to that route
  • Inform the shipping types that are allowed in that route (for example, you will not allow ocean in a route that is from New York 5th Avenue to New York Broadway St.)
  • Inform the transportation connection points and maintain the relevant data on the detail screen
  • Inform routes and route stages

You can also maintain the route stages for several stages.

Define Modes of Transport

TCODE 0VTB
Path SPRO > Logistics Execution > Transportation > Basic Transportation Functions > Routes > Define Routes > Define Modes of Transport
Table/View V_TVTR_COM
  1. Define which modes of transport are relevant to your process
  2. Assign the mode of transport to a mode-of-transport type. The mode-of-transport type is responsible for classification of modes of transport in DG management.

  0002

Define Shipping Type

Here you will inform what are the shipping types and their mode of transport. See below in the screenshot some example of Shipping Types. They are suggestions only. Create them according to your business requirements.

TCODE 0VTA
Path SPRO > Logistics Execution > Transportation > Basic Transportation Functions > Routes > Define Routes > Define Shipping types
Table/View V_T173_COM

To create The Shipping Types you have to do the following steps:

  1. Define the shipping types
  2. Assign one or more modes of transport to each shipping type
  3. Assign the shipping types to a shipping type group. (This is important to automatically determine the freight pricing procedure that will calculate the freight costs and freight rates, see more below in the Shipment Cost Document Section).

0003

Defining Transportation Connection Point

TCP is the place where goods are received, issued, re-shipped or processed. Those processes can include activities like customs clearance or railway car cleaning, railway station for example. For each TCP, you can define the type (for example: load transfer point, airport or border), who is the responsible customs office, calendar and stopover time. You can also refer it to a plant or shipping point, a customer or vendor or to an address.

TCODE 0VTD
Path SPRO > Logistics Execution > Transportation > Basic Transportation Functions > Routes > Define Routes > Define Transportation Connection Point
Table/View V_TVKN_COM

0004

Defining Transportation Zones

It is where you will specify all the regions that you plan to cover with your routes. The routes will be from a departure zone to a destination zone.

There are three kinds of transportation zones:

• Direct zone > Can be allocated to explicit locations

• Postal code zone > Contains all locations corresponding to the valid postal code areas of a particular country

• Region zone > is defined by entering a country and region, and contains all locations in that region

You can also have a mixed zone which is a combination of the types above.

TCODE OVR1
Path SPRO > Logistics Execution > Shipping > Basic Shipping Functions > Routes > Route Determination > Define Transportation Zones
Table/View V_TZONE

The zones you set up here will be used in the master data. The location of each customer and vendor will be identified using the Transportation Zone field on the Address tab in the customer (or vendor) master record.

0005

You can also specify the zones for each of your shipping points here:

TCODE OVL7
Path SPRO > Logistics Execution > Shipping > Basic Shipping Functions > Routes > Route Determination > Maintain Country and Transportation Zone for Shipping Point
Table/View V_TVST_RF

Select the shipping point, and specify the country and transportation zone.

  0006

Define Transportation Groups

The transportation group specify the materials that will have similar requirements for transportation. For example, you can group products that are bulk or non-bulk, Pallet or Box and etc. You assign those groups in Material Master Records.

TCODE OVSY
Path SPRO > Logistics Execution > Shipping > Basic Shipping Functions > Routes > Route Determination > Define Transportation Groups
Table/View V_TTGR

0008

Setting up Weight Groups

If the weight of the delivery plays a role in route determination, you can set up weight strategy here.

TCODE OVS8
Path SPRO > Logistics Execution > Shipping > Basic Shipping Functions > Routes > Route Determination > Define Weight Groups
Table/View VC_TVLG
  • First you need to Maintain Weight Group, creating a new weight group with the corresponding description.
  • Then you need to maintain details for Weight Group where you will specify the maximum weight that is allowed in each weight group and then when the delivery is created, SAP will take the weight in consideration and determine the right route based on the rules you created. If you decided not to use this feature, the route determination will take place in the sales order and be copied into the deliveries.

0009

Define Routes and Assigning Routes

Here is where you will define routes, route stages and maintain the transportation connection point, all them required for shipment stages strategies.

Definition of routes

First you need to define the routes, doing the following steps:

  • List the routes that are relevant to your process/company.
  • Create the routes
  • If necessary/required, inform additional data to the route, which can be:
    • Shipping type > You can assign a shipping type to the route, to the preliminary leg, and to the subsequent leg.
    • Transportation service agent
    • Transit time
    • Transit planning lead time
    • Factory calendar, work time
    • Driving time (transit time minus breaks, distance)
    • You can assign a mode of transport to the routes for processing export activities.
TCODE 0VTC
Path SPRO > Logistics Execution > Shipping > Basic Shipping Functions > Routes > Define Routes > Define Routes And Stages
Table/View V_TVRO_COM

Identification: The identification is the description of the route and the Route ID, which is a complement to the description. If not required, I recommend repeating the description here.

Processing: If the route is managed by a specific vendor, you can inform the Service Agent here. By doing this, when the shipment is created to that route, the vendor (service agent) will be automatically proposed, saving some time from logistics planner, who will not need to inform it manually. You can also inform the Shipping Type field here. Another very important field here is the “Rel.transport”, which will determine if that route when used in a delivery document can be used to create a Shipment.

Scheduling: Most important fields in this section are:

  • Transit Time: Transit Time is the total time that the products will take to arrive at the customer following that route. This time is taken into consideration to planning and determining the date on which the product will reach the customer (and also when it needs to leave the plant in order to meet the customer’s requested delivery date). It is represented in calendar days, 2 decimals.
    • Trav.dur: Travel Duration is represented here in hours and minutes, is a subset of the total transit time seen above. It is the time taken for the actual travel along the route. This time is not used for delivery scheduling purposes.
    • TransLdTm. Transportation Lead Time is the time needed for planning and arranging transportation considering

0010

0011

Maintain Stages for all Routes

You can process stages for several routes at the same time. So, instead doing it one by one, use the transaction or path below to maintain it in a more efficient way.

TCODE 0VTE
Path SPRO > Logistics Execution > Shipping > Basic Shipping Functions > Routes > Define Routes > Maintain Stages for all Routes
Table/View

In the example below, I selected 3 route stages (selecting the checkbox) and I click in the “change” icon (the pencil). SAP pops-up the “attribute proposal for selected route stages” and whatever you maintain in there, it is going to be maintained to all the selected stages, lights will change from red to yellow. Then you need to “Save” and the lights will change from yellow to Green to confirm the modification.

0012

0012-1

Determining Routes

To the route be automatically determined, the following parameters are taken in consideration:

  • Country and departure zone (Shipping Point address)
  • Country and destination zone (ship-to party address)
  • Shipping condition (It is informed in the Sales Order and carried over to the subsequent documents)
  • Transportation group (from the material master)

In the deliveries routes determination, you can also add weight groups to the list of controlling factors, if you are using weight as a criteria for routes determination, which is optional as explained more above.

TCODE 0VRF
Path SPRO > Logistics Execution > Shipping > Basic Shipping Functions > Routes > Route Determination > Maintain Route Determination
Table/View VC_TROLZ

0013

0014

If you are using weight as a criteria to determine the route (as explained more above) here is where you will enter the weight group that you created, so to this combination of 4 elements explained above + the weight of the delivery, the route will be determined automatically.

Route Determination in Sales Order

The route is automatically pulled to the Sales document according to the combination below:

1. Departure zone or country of the shipping plant
2. Destination zone or country of the Ship-to-Party/Customer.
3. Shipping condition from Customer master.
4. Transportation Group from Material master.
5. Weight Group (if in use)

The route can also be manually entered or overwritten when you create or change a Sales Order document and also it can be re-determined in the Delivery document based on weight (weight group) if you are using the weight as a criteria (explained more above).

Scheduling and Delivery dates takes into account the following times: Transit Time / Loading Time / Pick/Pack Time /Transportation Lead/Planning Time.

Configuration of Shipments

See below what is required to configure the Shipment.

Maintain Transportation Relevance

Before configuring shipment documents, it is necessary to select the relevance to transportation.

TCODE 0VTR
Path SPRO > Logistics Execution > Transportation > Shipments > Maintain Transportation Relevance
Table/View V_TVLK_TR / V_TVLP_TL / V_TVRO
  • Delivery Type (V_TVLK_TR)

0015

  • Delivery Item Type (V_TVLP_TL)

0016

  • Route (V_TVRO)

0017

Set Up Transportation Planning Points

Once the transportation relevance is defined, you will need to configure the organizational structure that will run after transportation, for example, the shipment documents are created using the transportation planning point (which is tied to other organizational elements, such as shipping points, plants and etc.)

Define Shipment Type

The shipment types are related to the different ways of transporting and processing products, either from sales or stock transfer orders and etc. There are even situations where a Shipment Type for “Inbound” processing is required, for goods coming in.

There are 3 distinct transportation categories::

  • The Individual shipment when one or more delivery documents are assigned and transported by a single transport mode from a departure point to a destination point.
  • The Collective shipment where one or multiple deliveries are transported by one single transport mode from one or more departure points to one or more destination points.
  • The Multi-modal shipment when deliveries are transported by several different transport modes between one or more departure points and one or more destination points.
TCODE OVTK
Path SPRO > Logistics Execution > Transportation > Shipments > Define Shipment Types
Table/View V_TVTK

0018

Here I will discuss some of the main fields:

Number Systems: It is where you maintain internal or external number range assignment that will be used when documents are created.

Document Content: This section is where the core of the Shipment Type’s configuration is. It is like the Shipment’s identity. See below some of the fields and what they mean.

  • Shipment Completion Type: Identify the type of the shipment, if this is an inbound or outbound shipment, if it is loaded or empty.
  • Shipping Type: This identifies if the shipment is road, air, ocean, rail  or any other means of transport you have created in your system.
  • Process Control: Identifies how the shipment type will be performed, if it is individual shipment or collective shipment, single mode of transport or multiple mode.
  • Leg Indicator: The leg or stage is the representation of two transportation connection points or a single connection point where a transportation is performed (for example customs borders, loading transfer point). To each leg in a route it is possible to define the section type that this leg belongs, that can be a transportation, load transfer point or customs borders. It is also possible to identify if the leg is primary leg, main leg, subsequent, direct or a return leg. In a direct leg shipment type for example, the process will be performed in a single shipment but if it is a primary leg, main leg or subsequent leg, it will have more than one shipment connected to the delivery and the shipments will be linked to each other. And that’s where you can use theShTypePrelimLeg and SubseqLegShType to indicate the shipping type to those preliminary or subsequent legs.
  • Determine Legs: A rule to assign the legs in a shipment can be defined here. Let’s say you pick 1: Legs Determined according To Departure Point & Itinerary in a collective shipment. Then the leg determination will be pulled to the shipment based on departures and destinations sequence

0019

Transportation – Shipment Cost Document

Before we move to the Shipment Cost Document (aka SCD or Shipment Cost) configuration, let’s briefly discuss the role that this document plays in Transportation.

The shipment Cost Document is created in reference to a Shipment Document where one or more stages are relevant for Shipment Costs.

When the Shipment Cost Document Item is assigned to an item category that is relevant for settlement, you can take advantage of additional features that includes freight cost calculation, accrual and invoice payments.

Usually, you have the freight rates agreed with your logistics service agents and those rates can be maintained upfront in the system and calculated using the pricing and conditions functionality. If rates are maintained in the system, they will be calculated regardless the item category been relevant for settlement or not, but with the item been relevant for settlement you can forward the shipment rates for FI/CO (GR/IR accrual, Cost elements assignments, purchase order and service entry sheet posting, Invoice verification and etc).

The reference to the shipment cost calculation is the shipment document, but the rates that are calculated based on the condition and pricing procedure are stored in the shipment cost document.

Shipment Cost Document Structure

The Shipment Cost Document is composed by: Header, Item and Sub-item.

  • The header as you can imagine, contains data that is valid to the whole document and items, such as processing status, who created or changed the document, what is the document’s reference (the shipment number) and etc. The header also brings the Shipment Cost Document Type, which you can define to each type different processing rules and settlement procedures. See more below how to do that at Define Shipment Cost types section.
  • The item(s) contain data required to the freight calculation like who is the service agent, the invoice presenter, the pricing date used for calculation, settlement date, item status and etc.  See more below how to configure it atDefine Item Categories section. The items will refer to the header, of course, but they are also assigned to a specific Shipment’s stage. That helps for example when you have to charge certain costs that refers to the whole shipment or charges that refers only to a certain shipment leg (see section Assign Shipment Cost Type and item categories for more details).
  • The sub-item(s) is where price is assigned. The sum or all sub-items will determine the total cost of the shipment. The cost is calculated via Condition Records using condition types. The condition types can vary their characteristics to cover your business needs, where you can define the calculation base per whole leg’s weight for example or based on the Handling Unit/Shipping Unit (pallets, trucks, container and etc.). You can also use scales to meet the prices agreed with your service agent.

Define Date Rules

Here you create “Date Rules”. They are used to determine what are the dates to be taken in consideration when a shipment is created, to the Pricing Date, Settlement Date. Since you may have different Shipment Item Types (Item Categories), they may have different rules to the dates, if so, you can create different rules here and assign them to the Shipment Item Type.The dates will come from Shipment’s deadlines dates (either actual or planned dates).

TCODE T_60
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Basic Functions > Define Date Rules
Table/View V_TVFTR

This slideshow requires JavaScript.

 

 

Define and Assign Tariff Zones

Here is where you will inform the tariff zones along with their respective postal codes areas assigning to the tariff zones for each transportation planning point. You can use the Tariff Zones in the shipment cost calculation, based on a region (defined by a set of Postal Codes) assigned to a given Freight Agent.

TCODE T_76
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Basic Functions > Define and Assign Tariff Zones
Table/View TVFPTZ

Define and Assign Activity Profile

The profiles are very useful to calculate shipment cost document during the sales order creation to allow have an estimated freight amount.

TCODE T_80
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Define And Assign Activity Profiles
Table/View V_TVTK_PROF

Profiles are assigned based on Shipment Type and you can define different profiles depending on the Shipment’s status.

0028

 

Define Shipment Cost types

In many businesses situations, it is common to have different needs for settlement procedures to the shipments. To handle those different needs, you can create different Shipment Types and assign them to their respective shipment types.

TCODE T_56
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Shipment Cost Document > Shipment Cost Types and Item Categories
Table/View V_TVTF

The Shipment Cost type allows define what number range is going to be used, what is the status that the shipment’s deadlines needs to reach to allow the SCD creation. It is my personal suggestion that makes more sense to define that the Shipment must be in status 6 – Shipment Started, until a Shipment Cost Document can be created. That guarantees that the Freight document (SCD) will only be created if the Goods really left the plant. This last one is controlled via Ov.stat. Shipmt indicator.

0030

0031


Define Item Categories

The Item Categories (shipment cost item types) contains settings for calculation and settlement of a shipment’s stage/leg.

TCODE T_56
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Shipment Cost Document > Shipment Cost Types and Item Categories
Table/View VC_TVFTK / V_TVTF /  V_TVFT / V_TVFTK

In the box Calculation you can define the Date Rules (see more above about date rules) that will be used to pick the pricing date. You will also be able to define a partner function that the item category will be allowed to use for and the item determination group, which plays an important role in the pricing automatic determination.

0032

In the box Settlement you will see the following:

Cost Distribution > Cost distribution CO

0033

This is to define in what level the cost distribution of shipment costs will be allocated during account assignment and document posting.

The following levels are possible to select:

  1. Shipment cost item
  2. Delivery
  3. Delivery item

You will be able to restrict the level of cost distribution using the field Origin of CO in this same configuration screen.

If you intend to use COPA (profitability analysis) it is important to know that the Cost distribution B (Delivery) or C(delivery item) must be selected, so the Profitability Object can pull the data from Delivery or Delivery Item, since the Shipment Cost (A) do not hold data that is used to the CO-PA Characteristics.

Account Assignment Category

0034

The account assignment category is the cost collector that will be used (for example:cost center, Profit Segment, Account Number and etc). Note that even if you use for example the Profitability Segment, the costs will still be posted “statistically” to cost center, and it will be available to read in the cost center’s reportS_ALR_87013611. The available options are:

  • 9              Unknown
  • A             Asset
  • B             MTS prod./sales ord.
  • C             Sales order
  • D             Indiv.cust./project
  • E             Ind. cust. w. KD-CO
  • F              Order
  • G             MTS prod./project
  • K             Cost center
  • M            Ind. cust. w/o KD-CO
  • N             Network
  • P              Project
  • Q             Proj. make-to-order
  • T             All new aux.acc.
  • U             Unknown
  • X             All aux.acct.assgts.
  • Z             Profitability Segment

Settlement Date

0035

Once again, check the Date Rules explained more above. Here you will assign one of the Date Rules you have created and this is the date that will be taken in consideration for “settlement” which is the accounting posting date (to the GR/IR accrual document)

Origin of CO assignments

0036

The options that you can select for Origin of the CO assignments are: A – General ledger account, B – Sequence: Delivery, Sales Order or C – Sequence: Delivery, order, G/L account. In case you use profitability segment, it is recommended to select “C” so you can have the Sales Order and Delivery Document information flowing to CO-PA characteristics.

Relevant for settlement

0037

Here is where you indicate if the shipment cost item is relevant or not for “settlement” (posting the GR/IR accrual). If you want to have the system creating PO’s automatically with subsequent GR/IR accruals, Service Entry Sheet, all behind the scene, automatically, you must select X here.

Purchase Order Generation

0038

At the time that the shipment cost is posted (transferred), SAP can create a PO (or assign an existing PO depending on the configuration). Here are the options you can select: Field in Blank – Do not generate purchase order / A – Generate purchase order for validity period of 1 day / B – Generate purchase order for validity period of 1 week / C – Generate purchase order for validity period of 1 month.

Item Categories

Create as many as you need or use the standard delivered. Here is one example of what I had to do:

  • YE01       Add cost Outbnd
  • YO01      Out Frt Truck
  • YO02      Out Frt Rail
  • YO03      Out Frt InlndWter
  • YO04      Out Frt Ocean
  • YO05      Out Frt Air Cargo
  • YO06      Out Frt Air Pssng
  • YO07      Out Frt Others
  • Y002       General costs
  • Y003       Insurance
  • Y004       Cleaning
  • Y005       Load transfer
  • Y006       Customs
  • YFOR     Forwarder Cost
  • YIAD      Inbound Add Csts
  • YINB      Inbound Frt Csts
  • YINT       Interco. Freight

Assign Shipment Cost Type and item categories

TCODE T_56
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Shipment Cost Document > Shipment Cost Types and Item Categories
Table/View V_TVFTK

0039

To each Shipment Cost Type, you need to do the proper assignments of Item Categories to specify when and how those item types will be pulled into the Shipment Cost Document. You also assign the Valuation Class, which plays an important role in the G/L account determination.

The Rec.indic. is directly tied to the stage type (in the shipment) and depending on the stage type (if it is based on Shipment Header, Shipment Leg, Load Transfer point and etc.) you assign what is the correct Item Type/Item Category to be used in the shipment cost document.

You can also select if to that shipment type, a given item category will be automatically assigned or if manual assignment is allowed, or even if the item category can shows twice in the same document.

Maintain Shipment cost relevance and default for shipment cost type

TCODE SPRO
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Shipment Cost Document > Shipment Cost Relevance and Default for Shipment Cost
Table/View VC_TVTK_VF

Here is where you will assign the shipment cost types to the respective shipment types:

0042

0043

Define shipment cost relevance for shipment type

TCODE T_57
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Shipment Cost Document > Shipment Cost Relevance and Default for Shipment Cost
Table/View VC_TVTK_VF

In this configuration you will indicate in what level the shipment cost needs to be calculated.For example, if to a given shipment type you select “leg” that indicates that the shipment stage is relevant for shipment costing but not the shipment header. You can’t “post” your shipment cost document to be ready to finance if the Shipment type is not relevant for shipment cost.

0044

Pricing

Before you create a SCD, you must have the pricing procedures assignment with their respective set of conditions and to have rates maintained for those conditions. If rates are not maintained, the document will still be created (with 0.00 amount) but not transferred/posted. The whole Shipment cost calculation is based on the SAP Condition Technique. The Picture below shows how the Condition Technique operates.

0045

The condition technique, condition types, scales, pricing procedures and their main characteristics follows the same concept of pricing procedure for other SAP documents. We will not spend much time here on this topic as there are many other sources for that. Later I will work on some examples and explanation for this topic and update it here.

Define and assign shipping type procedure group

Here you will define the Shipping type procedure group which is associated to the Shipping Type (represented mostly as the Mode of Transport). The shipping type procedure group is important to determine the pricing procedure automatically that will be used to calculate freight when shipment cost document is created.

TCODE T_72 / T_08
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Pricing > Pricing Control > Define and Assign Pricing Procedures
Table/View VC_TVFCV

See below the relevant settings:

  • VC_TVFCV – Define and assign shipping type procedure group (T_72)

00460047

 

Define and assign item procedure group

When you create a Shipment Item Type (Item Categories), you have to assign an item procedure group. Here is where you create those item procedure groups, which are also used to pricing procedure automatic determination.

TCODE T_71
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Pricing > Pricing Control > Define and Assign Pricing Procedures
Table/View VC_TVFT_Z
  • VC_TVFT_Z – Define and assign item procedure groups (T_71)
    • This comes from item category group (Item type).

00480049

 

Define Service Agent Procedure Group for Shipment Costs

This is one additional element that you can use in Pricing’s automatically determination. The Service agent procedure group, as you can imagine, is informed in the Freight Agent Vendor Master in the control tab (XK01).

TCODE SPRO
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Pricing > Pricing Control > Define and Assign Pricing Procedures
Table/View V_TVFCD
  • V_TVFCD – Service Agent Procedure Group for Shipment Costs

0050

Maintain Price Procedure

To those are familiar with the Pricing Procedure concept (in Sales Order and Purchase Orders for example), the  Shipment pricing procedure is the same as the standard pricing procedure and uses Conditions and Access Sequence to retrieve the data from condition records (entered for example via TK11).

TCODE SPRO
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Pricing > Pricing Control > Define and Assign Pricing Procedures
Table/View VVC_T683_FA
  • VVC_T683_FA – Procedures

0051

Define Pricing Procedure Determination for Shipment Costs

Based on the combination of Item Category Determination group, Service Agent Procedure Group, Shipping Type Procedure Group you can have the pricing procedure automatically determined in the Shipment Cost Document. It is not possible to manually enter a procedure in the Shipment Cost.

TCODE T_73
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Pricing > Pricing Control > Define and Assign Pricing Procedures
Table/View VC_TVFCSF
  • VC_TVFCSF – Determine Price Procedure (T_73)

0052

The criteria on which the determination of the price procedure is assigned depends on:

  • Transportation Planning Point – Shipment Header
  • Item Group – Based on the SCD’s Item Category
  • Service Agent Group – Service Agent Master Records
  • Shipping Type Group – Based on Shipping Type

0053

Maintain Condition Type

The condition type needs to be “E”  if you want to calculate the freight based on net weight or D for Gross Weight based on Delivery’s weight.

TCODE T_06
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Pricing > Pricing Control > Define Condition Type
Table/View V_T685A

0054

0055

Settlement

As the Settlement triggers in most of the cases a Purchase Order and Service Entry Sheet creation, it is necessary  to maintain some assignments, such as Purchase Organization, Purchase Group and Plant to a given Transportation Planning Point and Shipment Type.

TCODE T_53
Path SPRO > Logistics Execution > Transportation > Shipments Costs > Settlement > Assign Purchasing Data
Table/View V_TVFP

0056

Account Determination

Group Together Valuation Areas

The account determination is based on valuation area and company codes. This is in most of the companies a FI job, not SD. For this reason, I will show it high level only.

TCODE OMWD
Path SPRO > Materials Management > Valuation and Account Assignment > Account Determination > Group Together Valuation
Table/View V_001K_K

0057

Define Valuation Classes

Here is where you create and assign valuation classes. The valuation class is assigned when you do the assignments of Shipment Type and Item Category (explained here previously).

TCODE OMSK
Path SPRO > Materials Management > Valuation and Account Assignment > Account Determination > Define Valuation Classes
Table/View V_025K / V025 / V_134_K
  • V_025K – Account Category Reference

Create account category references under account category reference

0058

  • V025 – Valuation Classes

Under valuation class, define the valuation classes for each account category reference.

0059

  • V_134_K – Account Category Reference/Material Type

Under Material type/account category reference, assign an account category reference to each material type.

0060

Automatic G/L account Determination

From the Transaction “GBB” and combination of General Modification key “VBR” and valuation class the G/L account is determined for the posting to the freight accounts.

TCODE OMWB
Path SPRO > Logistics Execution > Transportation > Shipment Costs > Settlement > Automatic G/L Account Determination
Table/View

0061

From the Transaction “WRX” and value of valuation class as the G/L account is picked for GR/IR accounts.

0062

Automatic determination of CO assignments

When the shipment cost document is created, the G/L account is pulled in based on configuration above, including valuation class. But how is the cost center assigned in the document? Remember that I said that even if you don’t use the cost center as primary account assignment, it is still used to post statistically.

So, based on the configuration below, the Cost Center is going to be pulled to the document and used in the accounting posting (accrual).

TCODE OKB9
Path SPRO > Logistics Execution > Transportation > Shipment Costs > Settlement > Automatic Determination of CO Assignments
Table/View

0063

Business Process Procedure

Create transportation condition records

Here you maintain the rates agreed with the Freight Agent. This step is required in order to capture the cost / freight calculation automatically when the Shipment Cost Document is created.

TCODE TK11
Path SAP Easy Access > Logistics > Master data > Transportation > Shipment cost > Price
Table/View

Create Delivery Document

With reference the sales order, you should create a delivery and pick the goods. This document is required as it is the source document to the Shipment Creation. You can use VL01N for example or collectively via VL10B.

Create Shipment Document

After the status of the delivery is open for transportation planning, it is possible to create a shipment document to schedule the transportation.

Create a shipment using transaction VT01N.

You will need to inform the Service Agent (in some cases it can come automatically from the route as explained previously).

Make sure your Delivery is posted for goods issue and your shipment is “shipment start” before you go to the next step.

Creating Shipment Cost Document & Cost Settlement

Call transaction VI01, type the Shipment Number and press Enter:

0064

Then a screen like the one below will show and all you need to do it Save.

0065

If all was okay (a rate was found, G/L account and others accounts assignment were okay), the document will be automatically posted (accrual, GR/IR, ready for Finance pay the invoice).

Use VI03 transaction to display. Enter shipment cost no. and press enter.

0066

Note that the status of this document’s header is C C C, indicating that the document was calculated, account assignment was found and document was transferred (posted and ready to finance):

0067

Effects of Shipment cost settlement and related documents

After the shipment cost settled in shipment cost document, it has the following affects:

  • It creates a service entry sheet that refers to the purchase order determined.
  • It posts acceptance of services performed.
  • It creates an accounting document for the accruals.
  • Further subsequent documents are created in FI.

User-Exits

V54B0001 Shipment Costing: Configure pricing

V54B0003 Shipment Costs Calculation: Determine Rate Type and Currency

V54B0004 Shipment Costs Calculation: Determine Status

V54C0001 Shipment Costing: Description(s) shipment cost item(s)

V54C0002 Shipment Costing: Create shipment cost sub-items

V54C0003 Shipment Costs Processing: Determine Invoicing Party

V54C0004 Shipment Costs Processing: Determine Loc. for Tax Invoice

V54D0001 Shipment Costing: Determining the Tax Countries

V54KSFRC Determining the factors for apportionment of shipment costs

V54P0001 Extended Function Codes for Shipment Cost Information

V54U0001 Shipment Cost processing: Check whether changes made

V54U0002 Check shipment costs for completion

V54U0003 Specification of shipment cost number

V54U0004 Formatting for update of new objects (shipment costs)

V54U0005 Updating new objects in shipment cost processing

V54U0006 Shipment Purchase Order – Header Data Supply

V54U0007 Shipment Purchase Order – Item Data Supply

BADIs

BADI_SCD_ACCTG          Call During Shipment Cost Account Assignment

BADI_SCD_CREATE          When Generating a Shipment Costs Document

BADI_SCD_CREATE_CHCK     For Checks When Creating a Shipment Costs Document

BADI_SCD_PO_SELECT          Call for the Purchase Order Item Determination

BADI_SCD_PROCESS_CHK     For Checks During Shipment Costs Processing

BADI_SCD_SAVE          When Saving Shipment Costs Documents

BADI_SCD_TRANSFER          For Transferring Shipment Cost Items

That’s it, I hope it helps you…

Logistics.jpg

Advertisements