Skip to Content
Author's profile photo Kasper Peters

Mass update of route determination with LSMW

This blog is to explain the steps for uploading route determination without weight group via LSMW.

During several rollouts or redefinition of routes we need to upload new route determination in the system. If the amount of records are not that many, best approach is to do it manual. However with a lot of records, we can use the LSMW tool for this activity.


  • Routes must be available.
  • Shipping conditions must be available.
  • Transportation groups must be available.
  • A basic knowledge of using LSMW tool.

Generic route determination:

In this post, I also load entries with a generic route determination. Refer to notes 386105, 414250, 656444 for this functionality. For the route determination maintenance in the Customizing, it is possible to generate entries for which shipping condition, transportation group, weight group are initial (generic). When entering a generic key, it will take the generic route entered in that key. So you only need to maintain the exceptions with an actual key. This can save a huge amount of records to be loaded.

2 step approach:

The route determination is contained in 2 tables:

  • TROIZ (keys for country from/to and departure zone from/to)
  • TROLZ (keys for shipping condition, transportation group, weight group (not used in this blog) and actual route)

To make it easy for the LSMW we load the records for each table so we need to have 2 LSMW’s.

Note: Before starting, go to transaction 0VRF and change/update one entry in the route determination table so a transport request is created. This transport request is used in the LSMW’s.

TROIZ upload

Goto transaction LSMW.

Create new project/subproject/object

Here we create a new load for the route determination load of the TROIZ table.


Maintain Object Attributes

This is the most important step of the LSMW, we create a recording for the TROIZ table. Using a batch input recording.


Next popup needs a transaction code. Enter transaction 0VRF


Next screen appears and press button “New Entries”.


Enter one key that does not exist in the route determination table. Else you get error message and have to start over.


Press the SAVE button. The transport request we created before starting comes up.


Confirm and go back with green arrow a couple of times so that the recording screen is shown.


Now double click on the fields ALAND, AZONE, LLAND, LZONE and TRKORR one by one and give the following names. I normally delete the default value and only keep the field name + description. The transport request number do not change.


SAVE the recording and enter the recording name in the previous screen (object attributes).


Then go to menu option source structure. Enter something similar below.


Then enter Maintain Source Fields.


Then enter Maintain Structure Relations.


Then enter Maintain Field Mapping and Conversion Rules.

Note: In the menu –> Extra’s –> Auto-fieldmapping will do the mapping more quickly. Else select the fields one by one and pressing button source field to assign the source fields manually.


Then goto Specify Files

You need to create your input file first. In Excel the source looks like this:


I normally save the Excel as a .CSV file (comma separated) for usage in the LSMW.

Note: always check if the keys are the same as in the Excel file. Sometimes the leading zero’s get lost in the conversion.


Then goto Specify Files select Legacy Data and double click on that node.


    • File name on your computer
    • Description (any)
    • Delimiter as Comma (we use .CSV)
    • Field names at start of file checked.
    • Field order matches source structure definition checked.

          SAVE the entries.


Then goto Assign Files:


Then goto Read Data


Execute this transaction (F8) and you get overview of loaded entries. When it shows read = written it’s ok. When not written there is something wrong. You should check your file or mapping when this is the case.


Then goto Convert Data


Press Execute (F8). The transactions read – written should be the same.


Then goto Create Batch Input Session

Screen should show the following, I always select ‘keep batch input’.


Execute this transaction (F8)


Then goto Run Batch Input Session


Select the line and press button “Process”. Select Background and press button “Process”.


This will result that the from/to route determination is loaded in your system. In transaction 0VRF all records are now loaded.


This is the end of the first LSMW load.

TROLZ upload

Please refer to next link for the upload of the TROLZ entries.

Mass update of route determination with LSMW part 2

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo R K
      R K


      Can the LSMW be used directly in PRD for upload of Route Determination or it will generate an transport request ?



      Author's profile photo Kasper Peters
      Kasper Peters
      Blog Post Author

      Hi, no this LSMW can not be used to load in PRD directly. Optionally, the TROLZ and TROIZ tables can be enhanced to create a maintenance view. Then another LSMW can be created to upload it directly in the tables.

      Author's profile photo venu gopal
      venu gopal

      Dear Peters,

      Your post is very nice with detailed explanation about LSMW.

      But my question is same to Kumar, generally we will upload directly in Production system.

      But in your case you are telling there is transport request will be generated, please kindly explain this point a bit.

      Thanks a lot

      Author's profile photo Kasper Peters
      Kasper Peters
      Blog Post Author

      This example works from development -> test -> production.

      To generate a transport request you go to 0VRF, change one entry. Transport request is created, use that request in the LSMW.

      Author's profile photo R K
      R K


      Not convinced on directly uploading routes into the SAP Tables. Could you please provide some details on it.