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.

Prerequisites:

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

/wp-content/uploads/2015/08/troiz1_762054.png

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.

/wp-content/uploads/2015/08/troiz2_762055.png

Next popup needs a transaction code. Enter transaction 0VRF

/wp-content/uploads/2015/08/troiz3_762086.png

Next screen appears and press button “New Entries”.

/wp-content/uploads/2015/08/troiz4_762087.png

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

/wp-content/uploads/2015/08/troiz5_762088.png

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

/wp-content/uploads/2015/08/troiz6_762101.png

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

/wp-content/uploads/2015/08/troiz7_762102.png

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.

/wp-content/uploads/2015/08/troiz8_762108.png

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

/wp-content/uploads/2015/08/troiz9_762109.png

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

/wp-content/uploads/2015/08/troiz10_762113.png

Then enter Maintain Source Fields.

/wp-content/uploads/2015/08/troiz11_762114.png

Then enter Maintain Structure Relations.

/wp-content/uploads/2015/08/troiz12_762115.png

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.

/wp-content/uploads/2015/08/troiz13_762116.png

Then goto Specify Files

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

/wp-content/uploads/2015/08/troiz14_762117.png

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.

/wp-content/uploads/2015/08/troiz15_762118.png

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

Enter:

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

/wp-content/uploads/2015/08/troiz16_762131.png

Then goto Assign Files:

/wp-content/uploads/2015/08/troiz17_762132.png

Then goto Read Data

/wp-content/uploads/2015/08/troiz18_762133.png

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.

/wp-content/uploads/2015/08/troiz19_762143.png

Then goto Convert Data

/wp-content/uploads/2015/08/troiz20_762144.png

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

/wp-content/uploads/2015/08/troiz21_762145.png

Then goto Create Batch Input Session

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

/wp-content/uploads/2015/08/troiz22_762155.png

Execute this transaction (F8)

/wp-content/uploads/2015/08/troiz23_762156.png

Then goto Run Batch Input Session

/wp-content/uploads/2015/08/troiz24_762157.png

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

/wp-content/uploads/2015/08/troiz25_762161.png

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

/wp-content/uploads/2015/08/troiz26_762162.png

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

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Ravi Kumar

    Hi,

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

    Regards,

    SRK

    (0) 
    1. Kasper Peters 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.

      (0) 
  2. 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

    (0) 
    1. Kasper Peters 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.

      (0) 

Leave a Reply