Logistics TrainingRoutes ManagementPresented by SBSDecember 2013NOH Belgium 
Introduction
●Routes Management Introduction ●Routes Codification and Description
●Data and Tool required to maintain Routes
...
- 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.
...
○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
...
■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
...
■ 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
...
Maintain Routes & Routes Determination Maintain Connection Points 
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
- You access the transaction in Display Mode
Display Routes To display the Route DeterminationTo create Connection PointsTo switch to Change Mode
...
- 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 Points
●Single creation of Route
...
- Using transaction Z1T_ROUTE
- 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!
...
- Departure point (= station of departure)
- Destination point (= station of destination)
- Shipping type
- Service agent
- Transit duration
- Calendar
- Leg ID (2 for main leg)
- Special Processing Indicator
- Single creation of a Route 4 12345678910 12345678910 Shipment cost relevance box needs to be flagged 10. Distance in km
- Using transaction Z1T_ROUTE
- 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
- For Sea Routes, it is necessary to create transportation stages relevant for each 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 Points
Agenda●Single creation of Route
...
- 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 Points
Agenda●Single creation of Route
●Single creation of Route Determination
...
■ 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
- 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
- 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
To upload the Excel file for mass creation of Routes (continued):
Click on Upload Road
Mass upload for Routes creation 1
2Select your txt file 3 Click on Open, the upload starts
- Using transaction Z1T_ROUTE
- 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 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
© 2011, SOLVAY S.A.
- Using transaction Z1T_ROUTE
- 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
- To upload the Excel file for mass creation of Route Determination:
- 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
- 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
- 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
To upload the Excel file for mass creation of Route Determination:
When the upload is completed, the following log appear
IntroductionIntroduction
●Routes Management Introduction
●Routes Codification and Description
●Data and Tool required to maintain RoutesDisplay 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
- © 2011, SOLVAY S.A.
- 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
© 2011, SOLVAY S.A. 
Double-click on the connection point
- Connection point creation using Z1T_ROUTE
Anchor _GoBack _GoBack - 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
...