OBJECTIVE AND SCOPE


The purpose of this document is to present the rates and routes management process regarding the sea transport packaged shipping i.e. FCL (Full Container Loaded).

SCOPE

This operating procedure (OP) applies to all rates and routes to be processed in the European area (excluding Gorzow, in Poland), and exclusively with regard to the sales transport.

REFERENCE DOCUMENTS


DEFINITIONS


EMEA LP = Europe, Middle East, Africa, Logistics Purchasing (ex DAL= Direction des Achats Logistiques).
SID = Shipment Identity: this file is a summary of the necessary elements to perform a transport: route's name, used carrier, shipping point, destination point, mode of transport, etc…
SCD: Shipment cost document = It is generated when using the transport mentioned in the SID.
Shipping point: It is an assigned code to each site depending on both the nature of the shipped product and the used mode of transport.
Shipment organization point: It is an assigned code to each administrative entity. It defines which site is in charge of both organization and payment of each transport.
RRI /POC: Point Of contact. It is the interface between different actors of the site for which it is responsible: i.e. OtC Logistics Data and the accounting department. It is in charge of solving anomalies related to missing or wrong SCD.
ISSD:  Information System Solutions and Design Data (ex GDA et MAGDA), SBS OTC support Team in charge of data management i.e. SAP structure and developments
Google form = It is a form that allows sites to make emergency requests for creation or modification of routes.

FCL RATE ENTRY ( Full Container Load)


Process for entering FCL rates


WHO ?



WHAT ?


HOW ?

 

EMEA LP

Global (Brussels)

If from tender

 

EMEA LP

Local (EPA)

If rates update only

 

 

 


SBS-OTC LD






Sends rate database

(Tender or rate updated)


Entry rates








Via eRoom/e-mail






TK11 or TK14/

ZWOC90B






The FCL tender's tariffs include 2 parts: one for the pre carriage rate and the other one related to sea transport.
Tender's Tariffs are sent by EMEA LP Global (Brussels) via an Excel file.
Rates' updates are sent to SBS OTC LD team by EMEA Local team (EPA) via eRoom.

FCL maritime pre-carriage

The FCL pre-carriage rate corresponds to the inland part of the transport. Prices depend on the carrier and vary according to each shipping company.
The price condition used in SAP is Z500
The necessary elements for entering the pre-carriage rate are as follows:

  • The shipping company (= AIRMER Cie: ex : OOCL 00101
  • The freight forwarder (if merchant haulage)
  • The type of shipment :
      • 05 Carrier Road
      • 08 Carrier Rail & Road
      • 09 All Barge
      • 14 Carrier Barge & Road


  • The shipping point (departure site ex : 0151)
  • The destination point : it is necessarily an embarcation's port (ex : 3 FR FOS)
  • The packaging: type of container 

Used codifications :

container 20'dry

1055651

container 40' dry

1055652

container 40' High cube

1753761

container 20' reefer

1846370

container 40' reefer

1846371


  • The goods hazardousness
  • The amount
  • The currency
  • The start and end validity tariff.


The process for entering the tariff (especially related to the rates' update) is as follow:

  1. Check within the TK13 transaction (display condition) that the rate to be entered is not already registered in SAP system (Z500 condition)
  2. If there is no rate, type TK11 (create rate condition)
  3. If there is a rate already registered, type TK12 (modify rate condition)
  4. Select Z500 condition. The condition type determines the choice of the keys combination.


Choose the appropriate combination of keys 

If dangerous goods or Non dangerous goods
Enter the data related to the rate in the next screen. Each field with must be filled:

Example of a precarriage's rate for non-dangerous goods :
From the shipping point of Saint Fons Spécialités (0157), type of shipping: Carrier road (05), packaging item 1055651 (20' dry) with CMA-CGM (00501), Arrival point:
Anvers (3 BE ANR)



Example of a precarriage's rate for dangerous goods :


The amount to be entered for the shipment's tariff of dangerous goods is: the precarriage tariff + precarriage hazardous surcharge.
For the shipment of dangerous goods, in addition to the combined key with "C.DG"", you must tick the field C in the rate's pricing table.
Note that the sea approach FCL rates are always packages.

The FCL Ocean freight


The FCL ocean freight is the part of shipment performed on the sea,.i.e.from the port of load to the port of discharge (Main transport).
The price condition used in SAP is Z510
The necessary elements for entering the ocean freight are the same as the pre-carriage ones with the exception of the following elements:

    • The port of load* = departure point (it is the arrival point of the pre-carriage), Ex : 3 FR FOS
    • The port of discharge* = arrival point Ex: 3 TH BKK
    • The FCL freight shipping type is always 04 (sea)

The process for entering the tariff is as follows:

  1. Check within the TK13 transaction (display condition) that the rate to be entered is not already registered in SAP system (Z510 condition)
  2. If there is no rate registered, type TK11 (create rate condition)
  3. Select Z510 condition. The condition type determines the choice of the key combination.
  4. If there is already a registered rate, type TK12 (modify rate condition)
  5. Select the appropriate combination of keys


If dangerous goods or non dangerous goods


Enter the data related to the rate in the next screen. Each field with must be filled
Click on « Enter ».
Example of a FCL Ocean Freight with a packaging item 1055651 with dangerous goods


In case of shipment of hazardous goods, in addition to the combined key with "Contains DG", you must tick the field C in the pricing table.
Please note that :

  • The FCL ocean freight rates are always flat rates including the departure THC (Terminal Handling Charges)
  • For sea freight, consider the column « New Ocean freight with bunker revision » of the FCL rate database
  • The amount to be entered for the shipment's tariff of hazardous goods is: the pre-carriage tariff + Precarriage Hazardous Surcharge

Additional FCL shipping costs:


In eRoom, there is a specific Excel file containing the various additional fees applied by each freight forwarder and by each shipping company.
Rate conditions to be used:

  • Management fees: Z590 – Table 904 – Service agent/Ship. type
  • Customs fees: Z591 – Table 904 – Service agent/Ship. type
  • Express Mail: Z570 – Table 904 – Service agent/Ship. type
  • Extra customs trucking (multistop) : Z597 – Table 990 – Shipping line / Ship.type / Ship.point /Dest.point /PackMatls
  • Additional fees (all in per container): Z511 – Table 598 - Service agent / Shp.type / Country of dep / Packaging materi
  • Table -

    The mass loading rates

Download the template Excel file with the ZWOC90D transaction depending on the used condition (Z500 or Z510)


Take the tender provided by the purchasing department then copy and paste in the pre-filled columns whilst respecting the set table.
The different types of tables:
989: Pre-carriage of dangerous goods
990: Pre-carriage of non-dangerous goods
913: Main transport of non-dangerous
940: Main transport of dangerous


Convert the Excel file in text format (.txt) and save it on your desktop before downloading it in ZWOC90B transaction
Once these manipulations are performed, download the files (pre-carriage and ocean freight) in ZWOC90B transaction.
Define the condition type (Z500 or Z510)
The file Header Line number is always 2
Please see the example below :


VI. ROUTE CREATION


 

WHO ?

 

 

WHAT ?

 

HOW ?

 

EMEA LP

Global (Bruxelles)

If tender

 

EMEA LP

Local (EPA)

If updated tariffs

 

 

 

GBU Plant

 

 

 

 

 

 

 


 

SBS-OTC DL

 

 


 

Sending Price list

 

(tender or updated tariffs)

 

 

 

 

 

 

Sending the route request




Route creation

 

 

 

Via eRoom/ email

 

 

 

 

 

 

 

 

 

Google form

 

 

 

 

 

0VTC/

ZWOC42A

 

 

Manual route creation


  1. New creation


  • In SAP enter 0VTC transaction
  • Get in edit mode «change View Routes
  • Click on «   » 
  • Type the new route's number (the latest created route's number + 1) and seize information either from the Price list database or from the Google form (in this case, the route's number must start by GBU).


Information provided by the plant for the route creation are as follows :In the routes' tab , click on the icon « Position » and seize ANPE or GBU (if the request is from the Google form)

  • The GBU name
  • The SAP system (RCS)
  • The type of request
  • The mode of transport
  • The shipping point
  • The type of shipment
  • The port of load
  • The port of discharge
  • The incoterm
  • The carrier code
  • The lead time
  • The transit time
  • The calendar
  • The border point


These information are very detailed because they enable us to create the new route and also to check the tariff related to the flow.
Note that for all the sea shipment departing from France, the border point corresponds to the place where the goods leave the European territory.


How to create a route?

  • The route's name must be in capital letter with a maximum of 39 digits.
  • The route description must follow the following order:

10 FCL Carrier-Port of Load–Port of discharge–Lead time–Transit time


Enter the following information :

The route number (as explained above)

The description and copy paste in the "Route ID " line.

Service agent code

Mode of transport = 1 (Sea)

Shipping type = 04 (Sea).

Transit time (pre-carriage time + sea transit)

Lead time

Calendar type.

Tick on « Rel. transport ». It will enable the generation of the SCD automatically when using this route.


  • Press « Enter»
  • Click on the tab «Route stages»
  • Click on the icon « insert new entries »
  • Click on «2 Columns»

Enter the following data:

Departure point (starting with a 3 => Port) and the arrival point (starting with a 3 => Port)

Service agent code

Leg indicator = Main leg

Shipping type= 04 (Sea).

Click on « ShpmntCostsRel » ». It will enable the generation of the SCD automatically when using this route.

Save. 

  • Click on the icon « Add new entry» to integrate the border point.
  • Type the border point node « 7 xx xxx » with stage type 3 as indicated below.

  • Save


Translate the route following the stages stated below:

  • Select the route in the main page
  • Menu Edit => Translation




  • Select all the languages and translate to English for each of them.
  • Save


  1. Route creation with reference
  • 0VTC Transaction – « IRoutes » : Summary
  • Click on the pen «Display»
  • Select and double click on the reference route number, then paste

!worddav1f70816e1c697b0f6c916b771a48123c.png|height=169,width=624!Type the new route numberPaste

Route modification


Sometimes some plants can request for a route modification: service agent code, lead time, transit time, calendar …
However, some parameters must be checked before performing such modifications.

  • The first thing to do is to check if the route is used by other plants


    • Check if the route is set up in the plant's determining route table



For that, use the ZWOC46A transaction (List route determination)

Type the route number2) Press on this icon
The code plants using this route l'itinéraire
The following screen appears :

This table show which plants have set up the route in the 0VRF table.
Before any modification, you should contact each mentioned plants in this table to check with them if they are involved by this request.

    • Check if the route is used by a plant without being set up in the 0VRF table.


It's possible that a plant use a route without setting it up, the route doesn't need to be set up to be used.
You have to select VT11 transaction.

1) Select the route code

2) Click on The following screen appears :
SID numberPlants codeRoute number



This table shows which plants used the route and if some « SID » are still being processed. Before deleting it, you must make sure that no SID is being processing with this route.

The route creation with the mass loading

For the route creation with the mass loading, use ZWOC42A transaction in SAP.
Download the Main and Legs files using the text format (.txt) that you have originally established and were provided with by the purchasing department.

Be careful when loading, tick Load General DATA for the Main file and Load Leg DATA for the Legs file.

Mass modification

ZWOC42B transaction is to be used for the mass route modification.

The loading will be done in the same manner as for the ZWOC42A transaction:

    • Changing the general data
    • Changing the route's stages


They are stored in the common server K with the link below:
K:\ACHATS_ODA_LOG\01-TEMPLATES DE CHARGEMENT EN MASSE\02-Acheminements

When loading, if one of the field has no value, the system will automatically affect a blank value.