Table of contents

Objective and Scope

Objective of this Procedure

This document presents the general process for managing air transport rates and routes in WP1 system.

Scope

This process applies to all tariffs and deliveries to be processed in the EMEA zone (except Gorzow in Poland), and exclusively with regard to sales transport.

Definitions

SD : Shipment Document. This file is a summary of all the elements necessary for carrying out a transport: route, carrier used, point of departure, point of arrival, mode of transport used ...
SCD : Shipment Cost Document. It is generated during the implementation (= ex works) of the transport mentioned in the SD where the accrual of the transport cost is created.
SHIPPING POINT : This is a code assigned to each site according to the nature of the product transported and the type of transport used (Ex: Collonges = 0151).
TARIFF ZONE : Division of a country to avoid having to enter the same tariff as many times as there are departments in the same geographical area (Ex: ZT Rhône-Alpes can include 01, 38, 69, 42)
EMEA : Europe, Middle East and Africa
TRANSPORT PLANNING POINT (TPO) : This is a code assigned to each administrative entity. It defines which site is responsible for organizing and paying for each transport.
RDT*TDA - versão francesa e bastante utilizada :* Route Determination Table. This table allows that a route populate automatically in an order.
GOOGLE FORM : It is a way that allows sites to make emergency route requests.
DG and NDG : If we are dealing with a Dangerous Goods or Non Dangerous Goods flows

Entry of Tariffs and Route Creation

Entry of Tariffs

Tariff creation

Tariffs are created on Primary and Back-up flows.
Before creating a price, check that it does not exist in SAP (via TK13)
Our rate base can be found in the following path:
My Disk > 01. SBS OtC Logistics Data EMEA > TENDER > Rates Global data warehouse > FINAL Qlikview Files *Do not delete*
The Air price scheme corresponds to a lump sum from the shipping point to the destination airport, price/kg (gross weight), including a minimum (without weight range).

1. Enter transaction TK11
2. Condition Type: Z800 Air Freight
3. Choose the right key combination:

1. Fill in the fields corresponding to the chosen key combination.

You may find your data by using the matchcode available for each field:

• Airline : Airline code (ex: DHL 01801 ou SDV 02301)
• Shipping type for shipment stage : note, 06 for Air passenger shipments and 11 for Air cargo.
• Departure Point corresponding to the shipping point (ex La Rochelle: 1 FR 7677).
• Destination point : set 5 xx xxx (ex Alexandrie : 5 EG ALY)

xx = country xxx = airport code

• Shipping condition : Strategy for the delivery of goods from the vendor to the customer.
  • • AZ : Direct Service (quickest service with direct flights 24 to 48 hours airport to airport for DG and NDG)
    • BA : Consolidated Service (freight forwarder consolidation 96-120 hours airport to airport for NDG)

There are no prices for hazardous materials in consolidated service

• Indicator: Document contains dangerous goods
• Rate unit (currency or percentage)
• Calculation type for condition : T Multi-dimensional
• Validity start date and Validity end date : Agreement date

1. Click on and enter the scale code chosen (depending on the agreement* use scale ID 458895 GROSS WEIGHT UP-TO 5T / 460133 GROSS WEIGHT UP-TO 8T).
2. Enter the prices in the table that appears, indicating the Minimum price and the price per kilo in the Amount column.

1. Save.

*Sent by email in the beginning of the Tender

Other taxes related to air transport

If needed we can use some existent price condition depending on the surcharge to be created.
As an example, how to create a fuel surcharge (Fuel per Weight) and managed in a separate price condition.
The fuel costs are variable quarterly, on information from Purchases.
Enter the price under condition TK11: Create condition records

• Condition Type = Z070 Fuel per Weight
• Click on "Key combination"
• Choose the right combination according to the Purchasing data

Route Creation

Route requests

Checking if existing route

Routes are created only on Primary flows.
The request can reach us either by google form (for spot requests from sites) or via an update of the AIR tender by Logistics Purchasing.

• Before creating a route, you must first check whether it exists in SAP. We have a query that lists all of the available routes.

Procedure:

• we open the transaction SQ00
• choose user group ZW_RCS_OC

Go to the "change user group" icon , and "Enter"
Select ZW_RCS_OC

• click on the request 0VTC_INFO

• Select the line, click on

Leave nothing, click directly on
Make a layout with the elements listed below:

• Click on the

Enter

If necessary, export to Excel and save

Route structure

Carrier 1
Shipping PointDestination Airport
The elements required to create this type of route are:

• Shipping point
• Departure connection point designation (shipping point : 1 FR xxx)
• Departure airport name
• Arrival airport name
• Arrival connection point designation
• Transport mode (always 4)
• Shipping type (always 11)
• Relevance for transportation ID
• Calendar key (always 10)
• Carrier name (forwarder)
• RCS carrier code
• Lead time
• Transit time

"The AIR tariff construction is based on the following schema: minimum rate and rate per Kg from shipping site to destination airport.
It is therefore necessary to create a route by shipping point and by destination according to each needs."
This information is very detailed because it allows not only to create the route but also to check / request the price for the given flow.
It should be noted that for air shipments departing from France, the border point corresponding to the place where the goods leave European territory must be indicated (the border connection point: 7 FR xxx).

Route creation

• Transaction 0VTC – Route definition

In the Route tab, click on the "Position" icon. We assign the route number ourselves.
Check the last number on the list by entering "5" (air routes start with 4), assign our route number.

• Enter the following information on Route level:

Indicate the route number by the chosen route number.

Enter the new data:

Enter the description and copy this designation to the "Route ID" line. 

Service agent code

Mode of transport = 4 (Air)

Type of shipment = 11 (Air cargo).

Transit time

Lead time

Factory calendar key = 10 (All days are work days).

Check "Rel.transport". This will automatically generate a DFT when using this route.

Route description

The wording of the routes must follow 3 essential rules:

• All routes must be entered in capitals;
• The description of the routes cannot exceed 39 characters.
• The must be written in English and translated into English for all other languages.
  Calendar + AIR + Supplier (3 letters abbreviation) Site (shipping point) -Departure airport (3 letters IATA code)-Arrival airport + Lead time + Transit time
  Example:
  EN: 10 AIR DGF VALENCE–LYS–MUMBAI 1D 7D

• Click "ENTER"
• Click on the "Route Stage" tab:

• Click on the icon or to add or insert a new entry;

• Enter the following information on Route Stage level:

Enter the departure connection point (starting with 1 xx  => Site / Shipping Point) and arrival airport (starting with 5 xx => Airport).
Enter the new data:

Service agent code

Leg indicator = 2 (Main leg)

Shipping type = 11 (Air cargo)

Stage category = 1 (Transportation)

*Click on "ShpmntCostsRel{*}". This will automatically generate a SCD when using this route.

• Click on the icon to add a new entry for the border point;
• Enter the border connection point as "7 xx xxx" (for example: Lyon St Exupéry airport: 7 FR LYS) and in stage category: 3

• Save.
• Perform the translation:
• Click on "Edit" in the Menu bar and then in "Translation"
  
• Select all the languages and perform the translation in English for all of them.