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 precarriage

The FCL precarriage 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 precarriage rate are as follows:


(ex : 3 FR FOS)

Used codifications :

container 20'dry

1055651

container 40' dry

1055652

container 40' High cube

1753761

container 20' reefer

1846370

container 40' reefer

1846371



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 
dangerous goodsNon 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 precarriage ones with the exception of the following elements:

  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 keys combination.
  4. If there is already a registered rate, type TK12 (modify rate condition)
  5. Select the appropriate combination of keys


If dangerous goodsIf 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 :



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:

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


  1. In SAP enter 0VTC transaction
  2. Get in edit mode «change View Routes


  1. Click on «   » 
  2. 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 GBU9 (if the request is from the Google form)


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 label must follow the following order:
-10 FCL Carrier-Port of Load–Port of discharge–Lead time–Transit time
Enter the following information :
Type the label and copy paste in the "Route ID " line.Type the transit time (pre-carriage time + sea transit) / the lead time / the Calendar type.Tick on « Rel. transport ». It will enable the generation of the SCD automatically when using this route.Fill in :Service agent code / Mode of transport = 1 (Sea) / Shipping type = 04 (Sea).The route number (as explained above)

Enter the following data: Service agent code / leg indicator = Main leg / Shipping type= 04 (Sea).Enter the departure point (starting with a 3 => Port) and the arrival point (starting with a 3 => Port).Click on « ShpmntCostsRel » ». It will enable the generation of the SCD automatically when using this route.







Translate the route following the stages stated below:





  1. Route creation with reference

!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.




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.


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 code2) 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:


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.