Table of Content

Objective

The objective of this document is to describe the process for creating / maintaining transportation routings & shipment costs in the Rhodia Core System (RCS). 

Application (perimeter)

This process applies to all modes of transportation routings and shipment costs maintained in RCS for the Asia Pacific region. 

Definitions

Rhodia Core System (RCS) – SAP system of Rhodia Legacy 

Logistic Buyer (LB) – Logistics Buyer from Purchasing Department

Data Logistics (DL) – Data Logistics Team of the SBS Delivery Front Office OtC stream

Shipping Point – The "shipping point" is the physical location from which the item is shipped.

It represents both the location from which goods are despatched and the organisation responsible for deliveries.

It can be called "loading points".

Destination Point – The "destination point" is the physical location/port from which the goods are unloaded. It can be called "Port of unloading"

DG – Dangerous Goods

Plant – A plant is "a place where either materials are produced or goods and services provided". It belongs to one company code.
A plant contains one or several storage locations 

Scope

ERP

References

Attachments

Route template.xls

TemplateMassUpload1route.xlsx

Shipment Cost Template.xls

Ad hoc China Samples.xls

02 Shipment Cost_Korea domestic.xls

Price_Template_Monodimensionnel.xlsx

Price_Template_Multidimensionnel.xlsx

Solvay Mail – Re_Data Logistics SOP.pdf

 

 

1. Process Outline for Creation / Amendment Request

1.1 Route Creation / Amendment Process

The production / operation sites will send their request for route creation / amendment to Purchasing Logistics Buyer (LB) via an Excel file named "Route_Template" (refer to 4.3 – Appendix C) that contains the requirements of the transportation routings

Upon receipt of the excel file, Purchasing LB will verify the route specification, and forward the approved route request to SBS-APAC-DATA-LOG (sbs-apac-data-log@solvay.com)

Data Logistics (DL) will create / amend the requested transportation routing in RCS, update respective entries in "Route_Template" (such as the Route ID created), and send the updated excel file to the requesting Purchasing LB and parties

Process Flow Reference – 4.1 – Appendix A 

1.2 Shipment Cost Creation / Amendment Process

The production / operation sites will email Purchasing Logistics Buyer (LB) their request for Shipment cost for a new / existing trade lane.

Purchasing LB will obtain quotations from the suppliers / shipping companies, decide / approve the shipment cost to be used, and submit request for creation/amendment of shipment cost in RCS to DL via email to SBS-APAC-DATA-LOG (sbs-apac-data-log@solvay.com). The email will include the following information:

  1. Shipping Line
  2. Loading Port
  3. Destination Port
  4. Shipment Cost for Non-DG / DG
  5. The type of equipment
  6. The validity of the Shipment Cost

Data Logistics (DL) will create / amend the requested shipment costs in RCS, and send the creation/amendment confirmation to the requesting LB and parties

Process Flow Reference – 4.2 – Appendix B 

2. Creation / Amendment of Transportation Routing in RCS

The production / operation sites will send a Route Creation template filled with their new transportation routing requirements to Purchasing LB. Once verified and approved, Purchasing LB will forward the completed template to Data Logistics (DL) team

DL team will create / amend the route in RCS, update respective entries (such as the Route ID number created) in the template, and then send the updated template back to the requesting Purchasing LB and parties 

2.1 Direct road transportation route

Creation of Direct Road Transportation Route

  • Refer to requester's data input template "Route_Template" for parameters
  • Enter the transaction 0VTC in the tool bar – In DISPLAY mode, use [Position] function to locate the last Route ID code created
    • Increment this last routing ID number by 1 to obtain the new routing ID number
  • Toggle DISPLAY mode to CHANGE mode by Clicking the [Change icon] at the top left hand corner of screen

Click on the "New entries" button in order to create the new route 

Enter the new transportation routing data on the Route Details page.

  • Click on “Enter”

  • On the main 0VTC transaction page, click on the line which has just been created.
  • Select the languages into which the new transportation routing should be translated

  • Select three languages: ZH/FR/KO
  • Copy the English details of the transportation routing into other languages.
  • When done, click Save
  • Take note of the routing ID created, update the requester's data input excel template "Route_Template" and send the updated excel file back to the requesting parties

2.2 Maritime transportation route

Creation of Maritime Transportation Route

  • Refer to requester's data input template "Route_Template" for parameters
  • Enter the transaction 0VTC in the tool bar – In DISPLAY mode, use [Position] function to locate the last Route ID code created
    • Increment this last routing ID number by 1 to obtain the new routing ID number
  • Toggle DISPLAY mode to CHANGE mode by Clicking the [Change icon] at the top left hand corner of screen

Click on the 'New entries' button in order to create the new route ID 

  • Enter the new transportation routing data on the Route Details page.
  • Click on “Enter”

  • Re–select the Route line on the main page
  • Click on the “Route Stages” on the left menu
  • Click Save

  • On the main 0VTC transaction page, click on the line which has just been created
  • Select the languages into which the new transportation routing should be translated

  • Select three languages: ZH/FR/KO
  • Copy the English details of the transportation routing into other languages.
  • When done, click Save

Take note of the routing ID created, update the requester's data input excel template ("Route_Template") and send the updated excel file back to the requesting parties

2.3 Air transportation route

Creation of Air Transportation Route

  • Refer to requester's data input template "Route_Template" for parameters
  • Enter the transaction 0VTC in the tool bar – In DISPLAY mode, use [Position] function to locate the last Route ID code created
    • Increment this last routing ID number by 1 to obtain the new routing ID number
  • Toggle DISPLAY mode to CHANGE mode by Clicking the [Change icon] at the top left hand corner of screen

 

  • Enter the new transportation routing data on the Route Details page.
  • Click on "Enter"

  • On the main 0VTC transaction page, click on the line which has just been created.
  • Select the languages into which the new transportation routing should be translated

  • Select three languages: ZH/FR/KO
  • Copy the English details of the transportation routing into other languages.
  • When done, click Save

Take note of the routing ID created, update the requester's data input excel template ("Route_Template") and send the updated excel file back to the requesting parties

3. Inputting Transport Prices

Shipment costs are transport route–specific; they are entered and kept in RCS as price condition records via transaction TK11 

3.1 Inputting road transport prices

3.1.1 Full Truck Load (FTL)

FTL prices are inclusive prices for road transport, and they are recorded as price condition type 'Z122' 
The elements necessary for inputting an FTL price are as follows:

  1. The service agent code
  2. Ship Type
  3. The country of departure
  4. Transportation zone of departure
  5. The country of destination
  6. Transportation zone of destination
  7. The packaging material code
  8. The currency unit
  9. The price validity start and end dates

These elements are provided in an Excel file sent by the Purchasing LB
The procedure for entering this type of prices is as follows:

  • Enter transaction TK11 in the tool bar and press enter

  • Enter 'Z122 FTL/Trsp zone' under Condition Type and a list of Key combination will appear
  • Select "FTL with Shipping Material' and click Enter

The fields that are required are:

  1. Shipping Type : e.g. 01 Truck
  2. ServAgent (Vendor Code)
  3. Country of Departure : e.g. CN China
  4. Departure Zone : e.g. 0000310100 Shanghai City
  5. Destination Country : e.g. CN China
  6. Destination Zone :e.g. 0000120200 Tianjin City
  7. Packaging Material code : e.g. 1858331 6 Ton Wing Truck
  8. Amount (Rate in local currency)
  9. Unit (Currency)
  10. Valid From / Valid to (Contracted rates start and end date)
  • Click on 'Save' when done

3.1.2 Less Than TruckLoad (LTL)

The LTL prices are defined by per weight range, and they are recorded as price condition type 'Z363'
There are no packing articles for this type of transportation.
The elements necessary for inputting an LTL price are as follows:

  1. The service agent code
  2. Ship Type
  3. The country of departure
  4. Transportation zone of departure
  5. The country of destination
  6. Transportation zone of destination
  7. Scale ID
  8. The currency unit
  9. The price validity start and end dates

These elements are provided in an Excel file sent by the Purchasing LB.
The procedure for entering this type of prices is as follows:

  • Enter transaction TK11 in the tool bar and press enter

  • Enter 'Z363 Rate per Net Weight' under Condition Type and a list of Key combination will appear

  • Select "FTL with Shipping Material' and click Enter

  • The fields that are required are:

    1. Shipping Type : e.g. 01 Truck
    2. ServAgent (Vendor Code)
    3. Country of Departure : e.g. CN China
    4. Departure Zone : e.g. 0000310100 Shanghai City
    5. Destination Country : e.g. CN China
    6. Destination Zone :e.g. 0000120200 Tianjin City
    7. Packaging Material cod
    8. Amount (Rate in local currency)
    9. Unit (Currency)
    10. Valid From / Valid to (Contracted rates start and end date)

  • Press F2 to enter Scale ID
  • Enter the amount as given by Purchasing LB
  • Click on 'Save' when done

3.2 Inputting maritime transport prices

3.2.1 Full Container Load (FCL)

FCL maritime freight corresponds to transportation across the sea, and they are recorded as price condition type 'Z510' 
The procedure for entering this type of prices is as follows:

  • Enter transaction TK11 in the tool bar and press enter
  • Enter 'Z510 Freight FCL' under Condition Type and a list of Key combination will appear

  • Choose the Key Combination as follows:

Dangerous Goods (DG) – Ship line / Dep.point / Dest.point / PackMatls / Trans.Grp
Non-Dangerous Goods (non-DG) – Ship.Line / Dept.Pt / DestPoint / PackMatls

The fields that are required are:

  1. Shipping Line: e.g. COSCO 00403
  2. Departure point (Loading Port): e.g. 3 CN SHA Shanghai
  3. Destination point (Destination Port): e.g. 3 SG SIN Singapore
  4. Packaging material (Container type): e.g. 1055561 20" Container, 1055562 40" Container
  5. Amount (Rate in USD currency)
  6. Unit (Currency)
  7. Per (Rate for how many container)
  8. Valid From / Valid to (Contracted rates start and end date)
  • Click on 'Save' when done

3.2.2 ISO Tank

An ISO tank is a tank container which is built to the ISO (International Organisation for Standardisation) standard. ISO tanks are designed to carry liquids in bulk, both hazardous and non-hazardous. There are mainly two types of ISO Tank shipment – 'Door to Door' and 'Door to Port', and they are recorded as price condition type 'Z513' 

3.2.2.1 Door to Door Shipment

The procedure for entering 'Door to Door' type of shipment is as follow:

  • Enter transaction TK11 in the tool bar and press enter

  • Enter 'Z513 Freight sea/Contain.' under Condition Type and a list of Key combination will appear
  • Select 'ServAgent/Ship.type/Ship Point/Packmatls/Ship-to' and Enter

The fields that are required are:

  1. ServAgent (Vendor Code)
  2. Ship Type : e.g. 04 Sea
  3. Ship Point: e.g. E214 Zhangjiagang Bulk
  4. Packaging material (Container type): e.g. 1059333 ISO Tank
  5. Ship-to (Customer Code in RCS)
  6. Amount (Rate in USD currency)
  7. Unit (Currency)
  8. Valid From / Valid to (Contracted rates start and end date)

Click on 'Save' when done

3.2.2.2 Door to Port Shipment

The procedure for entering 'Door to Port' type of shipment is as follow:

  • Enter transaction TK11 in the tool bar and press enter

  • Enter 'Z513 Freight sea/Contain.' under Condition Type and a list of Key combination will appear
  • Select 'ServAgent/Ship.type/Ship Point/Dest.point/PackMatls' and Enter

The fields that are required are:

  1. ServAgent (Vendor Code)
  2. Ship Type : e.g. 04 Sea
  3. Ship Point: e.g. E214 Zhangjiagang Bulk
  4. Packaging material (Container type): e.g. 1059333 ISO Tank
  5. Destination Port: e.g. 3 US CHI Chicago
  6. Amount (Rate in USD currency)
  7. Unit (Currency)
  8. Valid From / Valid to (Contracted rates start and end date)

Click on 'Save' when done

3.3 Inputting air transport prices

3.3.1 Air Freight

Air Freight are recorded as price condition type 'Z800' 

The procedure for entering air freight prices is as follows:

  • Enter transaction TK11 in the tool bar and press enter
  • Enter 'Z800 Air Freight.' under Condition Type and a list of Key combination will appear

  • Select "Ship/Air L/Ship.type/Dep.point/Dest.point/Shpg Cond." and Enter

The fields that are required are:

  1. Ship/Air Line (Shipping Line code in RCS)
  2. Ship Type: e.g. 06 Air passenger
  3. Departure Point: e.g. 5 CN SHA Shanghai
  4. Destination Point: e.g. 5 KR INC Incheon
  5. Shipping Conditions: e.g. AH Air unloading point
  6. Scale ID
  7. Unit (Currency)
  8. Valid From / Valid to (Contracted rates start and end date)

  • Click on "Scales" (F2) to Enter Scale ID and rate

 

 

 

  • Click on "Save" when done

3.4 Mass uploading

3.4.1 Mass Route upload

Mass uploading of routes consists of two parts – General Data & Leg Data.

Fill up the data in the 'Main' sheet & 'Leg' sheet of the template – TemplateMassUpload1route.xls. Save separately into two text file (.txt).

  • Enter transaction ZWOC42A in the tool bar and press enter
  • To load the general data, select 'Load General DATA'
  • Select 'File name' and select the general data text file created earlier
  • Click 'Execute' or press F8 to enter the mass route loading page

  • Click 'Run Data Loading' or press F9 to begin uploading
  • Go to the last column of the page. If loading is successful, it will display 'Processed!'

  • Go back to the main loading page and select 'Load Leg Data'

  • Select 'File name' and select the leg data text file created earlier
  • Click 'Execute' or press F8 to enter the mass route leg data loading page

  • Click 'Run Data Loading' or press F9 to begin uploading

  • If loading is successful, it will display 'Processed!' in the column 'Error message or information'

3.4.2 Mass Freight Rates upload

There are two templates for mass uploading of freight rates – Price_Template_Monodimensional.xls and Price_Template_Multidimensional.xls. The type of template used depends on the condition type used. After completion, save the template into text file (.txt). 

  • Enter transaction ZWOC90B in the tool bar and press enter
  • Enter 'Condition Type' used for this upload
  • Enter '2' for File Header Line Number
  • Select the text file created earlier from the template
  • Click 'Execute' or F8 to begin uploading

  • If loading is successful, it will display the 'File Line number' and 'Status 53 – Application document posted' for each successful uploaded line.
  • If loading is not successful, it will display the File Line number' and 'Status 51 Application document not posted'

4. Appendix

4.1 Appendix A – Process Flow for Route Management

4.2 Appendix B – Process Flow for Shipment Cost Maintenance

4.3 Appendix C – Route Creation Input Excel Template

4.4 Appendix D – Route Creation Mass Upload Excel Template

 

4.5 Appendix E – Shipment Cost Inquiry Request Form – General

4.6 Appendix F – Shipment Cost Inquiry Request – China

4.7 Appendix G – Shipment Cost Inquiry Request – Korea

4.8 Appendix H – Mono Dimenstional Price Input Template – Mass Update

4.9 Appendix I – Multi Dimensional Price Input Template – Mass Update

4.10 Appendix J – SOP Approval email