Logistics TrainingRoutes ManagementPresented by SBSDecember 2013NOH Belgium

Introduction

●Routes Management Introduction ●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

●Single creation of Route
●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.
Introduction to the Routes in the ERP●Route: Distance to be covered between a shipping point and a destination point. A route can be made up of several legs.

The Route is a Logistics Master Data, and a mandatory data inserted in the Sales Order or the Stock Transfer Order.
The route is used as a criteria to select deliveries for a shipment and is a control parameter for shipments.

The Routes and the Route Determinations are created in SAP by the Transport Manager.

Introduction to the Routes in the ERPThe Route contains the following information:
1. The Shipping Type. The Shipping Type determines the Means/Mode of Transport that can be used to carry out the Shipment (truck, train etc). This is important for the Shipment Costs as it determines the Pricing Procedure.

○ The Service Provider. It is the carrier who will execute the shipment.
○ The Duration and Calendar: Lead Time and Transit Time, Factory Calendar.
○ The Stages created for border requirements, with their corresponding Connection Points.
■ The Connection Points identify railway stations, ports, airports...
Introduction to the Routes in the ERP■ They are used in Route stages to determine a transportation leg where specific costs are generated (loading/unloading, duties, customs clearance etc.)

The Route contains the following information (continued):
1. The Mode of Transport at the Border. This is to identify the mode of transport (road, rail, sea...) by which the goods cross the border during export.

○ The Relevant for Transport flag. This indicates that Route can be used for creating Shipments.
○ Stage Category - 3 Types:
■1 - Transportation
■2 - Load Transfer (loading/unloading)
■3 - Border Crossing

Introduction to the Routes in the ERPThe Route contains the following information (continued):
1. Leg Indicator (stage level): it has a strong impact on Shipment Type and Shipment Costs

■1 - Preliminary leg
■2 - Main leg
■3 - Subsequent leg
■4 - Direct leg
■5 - Return leg
○ Special Processing indicator (stage level): Determines the tax rules for the costs in the stage when the country of Tax is different from the departure country.
Introduction to the Routes in the ERP○ Pricing Procedure (stage level): determines which tariff schema must be assigned to the shipment costs, when it differs from the standard one assigned to the shipment type.

Route Determination: the Route can be automatically determined based on the following criteria:
1. The Country and Transportation Zone of the Shipping Point

○ The Country and Transportation Zone of the Ship-to party
○ The Shipping Condition (coming from the Order)
○ The Transportation Group (coming from the Material Master)

The Route Determination takes place at the item level of the Sales

Order or the Stock Transfer Order (if route/shipping point are empty in M3/M5)

Introduction to the Routes in the ERPWhen the Delivery is created, the Route is copied from the Sales Order to the Delivery.
Transportation Zones: a country is divided into Transportation Zones to support the calculation of transit times.These Transportation Zones are assigned to the Customers.
Route StructureRoad Routes
1. No Stage except for Point to Point routes

○ Multimodal cases: to avoid complexity, we consider Multimodal as Road. Only the Shipping Type differs to select the right tariff line.
○ Point to Point Road routes: depends on the Incoterm -DAT, DAP. The final destination is different from the Ship-To. A leg is created with the Departure Point (always identify the delivering plant in these cases) and the Arrival Point (Border crossing, City etc.). The second part of the Incoterm must be created as a Connection Point.

Rail Routes
1. Include 2 Connection Points identifying the railway station of departure and the railway station of arrival

○Depending on the railway company, the route can be unique for a Ship-To (with a specific Transportation Zone)
Route Structure○ The distance has to be inserted in the Direct leg and issued from DIUM for Europe. Units allowed are KM and MEI for US rail routes.

Air Routes
1. The Departure and Arrival Airports are created as Connection Points.

○ When the carrier takes in charge the transport from the Departure Plant to the Departure Airport: 2 Direct legs are created, only 1 is relevant for Shipment costs.
○When 2 separate shipments need to be created (1 preliminary and 1 main), the legs are defined accordingly: Preliminary leg + Main leg.

Sea Routes
1. Sea routes contain many Stages and will generate at least 2 shipments: one Preliminary and one Main. Depending on the Incoterm used, Subsequent Shipments can also be generated, as well as additional legs for Customs fees or Loading/Unloading activities.

○If Route is used for Stock Transfer Orders, the Import Duties are paid with the Order, and are not included in the stage (not cost relevant)

Agenda

Introduction

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

●Single creation of Route
●Single creation of Route Determination
Route Codification●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.
First digit: main Mode of Transport (1-Sea, 2-Rail, 3-Road, 4-Air, 5-Mail & Parcel, 7-Pipeline, 8- Inland Water)
Second digit: Country of departure
Third digit: Business Code or random digit
Fourth digit: Random digit, or specific business rules. Ex. for Rusvinyl:
Shipping Type (A container 20, B container 40, L liquid, P powder, 0 standard - R return)
Route Description for ROADFifth letter: Random digit, or specific business rules. Ex. for Rusvinyl: S for salt/salted water or number
Sixth digit: random digit
Ex: 3OV001 - 1T0529 - 2D0513 - 4IC004 etc.

Route Description (40 digits): The description must define precisely the usage of the Route.
The first part is mandatory and includes:
1. The Departure Country or the Site of Departure ○ A separator: "-"

○ 2 digits to indicate:
■ Dangerous or Non-dangerous goods. ■ Physical nature of the goods:
■ Bulks: Liquid, Gaz, Powder
■ Packed: E
Road Route Examples○ A separator: "-"
○ 3-4 digits with a short description of the product. Ex: PVC, LSC, SALT ○ A separator: "-"

The second part is recommended to give more information:
1. The carrier name, when relevant.

○ The arrival zone. For short routes, give the average distance of the relation.
○ 2 Digits to indicate the Transit duration : nbr of days + T
○ 2 Digits to indicate the Transportation Lead Time : nbr of days + L ○ Etc.
●Examples of Road Routes and their description:
○ 3U1055 : WN-DE-H2O2-BOWKER-Transit 6 Day- Europe
■ Departure Warrington to arrival zone of Europe for H2O2 Dangerous and Packed products. The Carrier is Bowker, the Transit duration is 6 days.
○ 3F0005 : DO-NE-XXXX-AUBRY-200/250KM-1DAY
■ All arrival zones located between 200 and 250 km from Dombasle, for Non Dangerous Packed products, by haulier Aubry, Transit duration is 1 day.
○ 3H0001 : AXA1-NE-SODA-TARGET-SUEZ-2DAYS
■ Departure SASC DEKHEILA PORT to arrival zone of Suez. Non Dangerous Packed Soda products. Carrier is Target Logistics, Transit duration is 2 days.

Route Description (40 digits): The description must define precisely the usage of the Route. We divided in 2 parts.
The first part is mandatory and includes:
1. 2 digits to indicate the country of origin

○ A separator: "/"
○ 2 digits to indicate the site of departure
○ A separator: "-"
Route Description for RAIL○ 2 digits to indicate the country of destination
○ A separator: "/"
○ 6-7 digits to indicate the customer number :eg 1201026 ○ A separator: "-"
○ 2 digits to indicate:
■ Dangerous or Non-dangerous goods. ■ Physical nature of the goods:
■ Bulks: Liquid, Gaz, Powder
■ Packed: E
○ A separator: "-"
○ 3-4 digits with a short description of the product. Ex: PVC, LSC, SALT ○ A separator: "-"

The second part is recommended to give more information:
1. The carrier name, when relevant.

○ The type of container (container on railcar), when relevant. Eg C40 for 40' containers
Route Description for SEA○ RET for return, when relevant. ○ Etc.

Examples of Rail Routes and their description:
1. 2OV008 : RU/KV-BY/337711-NP-PVC-RZHD

■ Departure country Russia. Loading in Kstovo. Destination country Belarus. Customer
337711 (BELORUSKALYI OAO) for PVC Non-Dangerous and Packed products. The Carrier is RZHD.

Route Description (40 digits): The description must define precisely the usage of the Route.
The first part is mandatory and includes:
1. The Departure Country or the Site of Departure ○ A separator: "-"

○ 2 digits to indicate:
Route Description for SEA■ Dangerous or Non-dangerous goods. ■ Physical nature of the goods:
■ Bulks: Liquid, Gaz, Powder
■ Packed: E
○ A separator: "-"
○ 3-4 digits with a short description of the product. Ex: PVC, LSC, SALT ○ A separator: "-"
○ Country Code and Port of Departure
○ Country Code and Port of Arrival

Examples of Sea Routes and their description:
1. 1B0001: XX-NE-XXXX-BE/ANVERS-GR/PIRAEUS-CONT40

■For all Belgian sites, all non dangerous packed products, port of departure Antwerp, port of arrival Piraeus (Greece) by container 40'
○ 1F0002 :TA-DE-CLM-FR/FOS-GR/PIRAEUS
■ For Tavaux, dangerous packed product, CLM, port of departure FOS, port of arrival Piraeus.

Agenda

Introduction

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

●Single creation of Route
Creation of a Route - Required Data●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

Data required/mandatory to create a Route:
1. The Carrier, is mandatory when this carrier always executes the service. The Carrier must be created as a Vendor in SAP.

○ The Shipping Type is mandatory. It is used for Shipment Cost determination. Select a Shipping Type related to the product type that will be associated for Route Determination.
Creation of a Route - Required Data ○ The Transit Duration is the number of calendar days required for delivering the goods from the Shipping Point to the arrival point.

Data required/mandatory to create a Route:
1. The Transportation Lead Time is the number of calendar days required for organizing a Shipment for shipping the goods.

■ The Time Unit is the DAY.
■ Remark: 0,5 = 1 DAY and 0,49 = 0 DAY.
■ A Transit Time of 0 DAY means that the customer is delivered on the same day as the Loading date.
○ The Factory Calendar is the calendar that is valid for this Route. Use the calendar of the Shipping Points "Z0 (365/365)".
○ The Mode of Transport at the Border is 3 for Road, 2 for Rail, 1 for Sea etc.
© 2011, SOLVAY S.A.
Creation of a Route - Required Tool●The transaction Z1T_ROUTE is a tool box dedicated to the maintenance of the Routes.
○ You can use it in Display Mode for displaying the Route and the Route Determination.
○ You can use it in Change Mode for the creation of the Routes, the Route Determination and the Connection Points:
■ Single creation mode is used to create data one by one.
■ The Excel file can be uploaded for mass creation of the data.
○ Use this transaction in Change Mode only when required. Accessing it in
Change Mode locks the tables behind this transaction. You can access in Change Mode only if you have authorizations to maintain and create Routes.

Agenda

Introduction

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination

Maintain Routes & Routes Determination Maintain Connection Points

●Single creation of Route
Display Routes & Routes Determinations●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

Using transaction Z1T_ROUTE
1. You access the transaction in Display Mode

Display Routes To display the Route DeterminationTo create Connection PointsTo switch to Change Mode

Using transaction Z1T_ROUTE (continued)
1. To display a Route, insert its code in the field and press Enter. You can search for a Route with the matchcode:

© 2011, SOLVAY S.A. Click on the matchcode to search for a RouteEnter the first digits of the Route to restrict the search (in this example: all Road routes from Italy)Then click on 1 2 4 You can also select by Service Agent (carrier) 3

Using transaction Z1T_ROUTE (continued)
1. Display Routes The list of Routes is displayed according to the selection criteria entered previously:

○Double-click on a Route code to display its details.

Display Routes Using transaction Z1T_ROUTE (continued) ○ Display Route details:

Display Route Determination Using transaction Z1T_ROUTE (continued) ○ Display Route Determination:

To display the Route DeterminationThe system switches to the Route Determination area 1 2

Display Route Determination Using transaction Z1T_ROUTE (continued) ○ Display Route Determination:

Enter the following data (use the matchcode):- Departure Country / Departure Zone- Destination Country / Destination Zone 1 Press Enter. The list of proposed Routes is displayed 2

Display Route Determination Using transaction SQ00, User Group LOGISTIC_USR, query ROUTE_ANALYS (Routes analysis)

○Display Route Determination:Enter the selection criteria and execute 1 The list of proposed Routes is displayed

2

Agenda

Introduction

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

●Single creation of Route

●Single creation of Route Determination
Transaction Z1T_ROUTE - Change Mode●Mass upload for creation of Route
●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

Using transaction Z1T_ROUTE
1. You can access the transaction in Change Mode

To switch to Change Mode

Single creation of a Route To switch to the maintenance of Route DeterminationTo upload multiple objects with the Excel fileTo switch back to Display Mode

Using transaction Z1T_ROUTE

○To create a new Route:Enter the Code of the RouteEnter its Description Enter the code of the Service Agent who will execute the shipmentEnter the Mode of Transport at the Border 1 2 3 4 Enter here:- the Transit Duration (in days)- the Transportation Lead Time (in days)- the Calendar of the Shipping Point Flag the field Relevant for Transport so that the Route can be included in a Shipment 5 6 4

Using transaction Z1T_ROUTE ○ To create a new Route:

Single creation of a Route When all required data are inserted, press Enter, and check your data
Warning: Data are NOT saved yet!

Using transaction Z1T_ROUTE
1. Single creation of a RouteFor Rail Routes, it is necessary to create a transportation stage :

Enter here the:

1. 1. Departure point (= station of departure)
  2. Destination point (= station of destination)
  3. Shipping type
  4. Service agent
  5. Transit duration
  6. Calendar
  7. Leg ID (2 for main leg)
  8. Special Processing Indicator

Single creation of a Route 4 12345678910 Shipment cost relevance box needs to be flagged 10. Distance in km

Using transaction Z1T_ROUTE
1. For Sea Routes, it is necessary to create transportation stages relevant for each leg ■Preliminary Leg:

Single creation of a Route
■ Main Leg:

Using transaction Z1T_ROUTE
1. For Sea Routes, it is necessary to create transportation stages relevant for each leg

Single creation of a Route ■Subsequent Leg:

Using transaction Z1T_ROUTE ○ To create a new Route:

To save your data, click on The following message appears:

Introduction

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

Agenda●Single creation of Route

●Single creation of Route Determination

●Mass upload for creation of Route
Single creation of a Route Determination ●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

Using transaction Z1T_ROUTE ○ To create a new Route Determination:

To switch to the maintenance of Route Determination

Single creation of a Route Determination Enter the following data (use the matchcode):- Departure Country / Departure Zone- Destination Country / Destination ZoneIt is possible to enter a Valid From date hereEnter the Shipping Condition: Road (only one 30:used in Egypt)Enter the Transportation Group: check in the Material Master, view Sales/PlantInsert the Route that should be proposed according to the selection criteria entered 1 2 3 4
To save your data, click on 6 Using transaction Z1T_ROUTE ○ To create a new Route Determination:

Introduction

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

Agenda●Single creation of Route
●Single creation of Route Determination

Mass upload for Routes creation●Mass upload for creation of Route

●Mass upload for creation of Route Determination
© 2011, SOLVAY S.A.

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Routes:

■ The Excel templates can be found at the following URL: New Excel template 20120201
■ Fulfill the Excel file as required:

Mass upload for Routes creation

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Routes (continued):

■ Save the Excel file in txt format (text file):

Mass upload for Routes creation

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Routes (continued):

Mass upload for Routes creation ■Edit your txt file to remove undesired data (only data for Routes to be uploaded should remain):

The first line of the file correspond to the first Route to be created. There is no other entry after the last entry of the Route to be created.

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Routes (continued):
  Click on Upload Road
  Mass upload for Routes creation 1
  2
2. Select your txt file 3 Click on Open, the upload starts
Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Routes (continued):

SIS / CMR / Dec-12In case a Route already created in the system is included in the file, the system displays the following message. Press Yes or No.When the upload is completed, the following log appear

Introduction

●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain Routes

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

Agenda●Single creation of Route
●Single creation of Route Determination
●Mass upload for creation of Route

Mass upload for Route Determination●

Mass upload for creation of Route Determination

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Route Determination:

■ The Excel templates can be found at the following URL: New Excel template 20120201
■ Fulfill the Excel file as required: go to the tab "Determination"

Mass upload for Route Determination

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Route Determination:

■ Save the Excel file in txt format (text file):

Mass upload for Route Determination

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Route Determination:

Mass upload for Route Determination ■Edit your txt file to remove undesired data (only data for Routes Determination to be uploaded should remain):

The first line of the file correspond to the first Route to be created.There is no other entry after the last entry of the Route to be created.

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Route Determination:

Mass upload for Route Determination Click on Upload Determination 1 3 Select your txt file 4 Click on Open, the upload starts Click on Upload Determination 2

Using transaction Z1T_ROUTE
1. To upload the Excel file for mass creation of Route Determination:
  
  When the upload is completed, the following log appear
  Introduction
  ●Routes Management Introduction
  ●Routes Codification and Description
  ●Data and Tool required to maintain Routes
  Display Routes & Routes Determination Maintain Routes & Routes Determination

Agenda

●Single creation of Route
●Single creation of Route Determination
●Mass upload for creation of Route
●Mass upload for creation of Route Determination

Connection Points - GeneralitiesMaintain Connection Points

Connection points are data which identify railway station, airport, port, customer, etc.
They are used in route stages to determine a transportation leg or stage where specific costs are generated (loading & unloading, border crossing etc)
You can create missing connection point using Z1T_route either in one shot or through a mass maintenance Excel file.
Following slides will explain you how to create connection points EXCEPT FOR PORT which it is part of Sea routes creation.

Codification rule for all Connection Points except Ports:
Country Code on 2 digits
Letter identifying the type of Connection Point: A-Airport, B-Border Crossing, D-Storage Location, P-Sea Port, W-Inland Water Port, C-Customer, V-Vendor, S-Train Station
Official code, if any. Ex: UNO codification for Ports, Solvay Plant code for Storage Locations etc.
Codification rule for Ports:

Connection Points -

CodificationCode "rangée". Specific codification maintained by Solvay Export. On 2 digit.
Letter identifying the type of connection point, P sea port, W inland water port.
Official UNO codification for ports, including country code.

Transaction to display a connection point: Z1V_DISP_0VTC

Transaction to display a connection point: Z1V_DISP_0VTC

Double-click on the connection point

Connection point creation using Z1T_ROUTE
2 modes of creation
online just for urgent connection point
using an excel file & upload procedure for mass maintenance
the template displayed indicates the column in the excel for mass maintenance

Selection Screen:

Connection point related to a railway station:

Line A: the country code is mandatory ● Line B: connection point type = S.
Line C: give the Id number of your connection point (alpha num) recommendation = official railway number( without country id).
Line D: description
Line G: tick this box. if the railway is a border crossing point tick line H.
Line L: give the full railway station number including the country id.
Lines P to Line V must be filled.
Lines W to Y are optional.

in red box mandatory fields for a railways stationin green optional fieldsthe train station number (L) should be the official id.
When you need to identify a customer as a connection point, the recommendation is to identify only the town of destination in order to avoid creation of lot of points:

Line A: the country code is mandatory ● Line B: F for connection point type .
Line C: give the Id number of your connection point recommendation shorted town name .
Line D: Full town name.
Line E: tick at least load transfer point box.
Line N: link the connection point to the customer number
Line R: give the postal code if known
Line S: town name
Line T: country code ( iso 2 position)
Line V: language code Line

in red box mandatory fields for a final the connection id = the shorted name town description = full town name.customer of destination
Connection point related to a shipping point:

Line A: the country code is mandatory ● Line B: connection point type = D.
Line C: give the Id number of your connection point (alpha num example of Idnr: FRDTAP: TAVAUX (PVDF), DEDBWF: BadWimpfen(Fluor)
Line D: description
Line E: tick at least load transfer point box.
Line G: tick the box if the shipping point has its own railway station number, and give its number in line L
Line M: link the connection point to the shipping point.

Line A: the country code is mandatory ● Line B: no connection point type .
Line C: give the Id number of your connection point (alpha num) recommendation = to the supplier number.
Line D: description
Line E: tick at least load transfer point box.
Line O: link the connection point to the supplier number

in red box mandatory fields for a supplierthe connection id = the supplier numberdescription = supplier short name and (if necessary) town.
Thank you for your attention!

Space shortcuts

Page tree

Introduction

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

Agenda

Introduction

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

Agenda

Introduction

Display Routes & Routes Determination Maintain Routes & Routes Determination Maintain Connection Points

Agenda

Introduction

Display Routes & Routes Determination

Maintain Routes & Routes Determination Maintain Connection Points

Agenda

Introduction