This is a continuation of Mass update of route determination with LSMW. See Mass update of route determination with LSMW

Due to restriction of amount of images loaded in previous post, this part continues with the LSMW upload for the TROLZ upload.

TROLZ upload

Now the TROIZ entries have been loaded, we can load the entries for shipping conditions and loading group.

Create a new object in transaction LSMW with different name.

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

Goto Maintain Object Attributes and create a new recording as described in the TROIZ load. Also use transaction 0VRF. In the first transaction we now press the button “Position” first. A popup appears and enter the Country of departure, Zone, Destination Country and Destination zone.

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

Then select the line and press the button “route determination w/o weight group”.

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

In the next screen press button “New Entries”

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

Then SAVE the entries and the popup of the transport request appears again.

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

Confirm and return to the batch input overview using the BACK button.

Then change the values here as shown in the screenshot – like the TROIZ steps.

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

Enter the name of the recording in the attributes.

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

Then maintain source structure as described in the TROIZ upload.

Then goto Maintain Source Fields and enter the following fields.

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

Then maintain structure relation as described in the TROIZ upload.

Then goto Maintain Field Mapping and Conversion Rules

Same steps as in the TROIZ upload. Map the source fields to the structure.

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

Then goto Specify Files.

Source file should look like in Excel.

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

Save the file as a .CSV. Make sure the leading zero’s don’t get lost.

Then enter the file details like the TROIZ upload.

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

Then execute the same steps as the TROIZ load (see Mass update of route determination with LSMW).

– Assign Files

– Read Data

– Convert Data

– Create Batch Input Session

– Run Batch Input Session

After running the batch input session in background the entries in 0VRF are now completed.

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

Note that the generic entry is also created. In this example it would be sufficient to load only the generic entry. Then you only need to load the ‘exceptions’. This saves some maintenance and amount of entries in the customizing table.

This completes the steps for loading route determination via LSMW.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply