Skip to Content
Author's profile photo Former Member

LSMW : Data Migration-City (RSADRLSM02)

Define Number Ranges for Cities

1.     Access the activity using one of the following navigation options:

Transaction code



SAP NetWeaver > Application Server > Basis Services > Address Management > Regional Structure/City File > Cities > Maintain Number Ranges for Cities

2.     Choose Change intervals.

3.     Choose Insert Line (F6)and enter the number range.


From number

To number

NR Status







4.     Choose the Ext flag for the number range.

5.     Choose Save (Ctrl + S).

Data Migration – Step by Step

Transaction code


1.   Creating a transfer project

Start the LSM Workbench with Transaction ‘LSMW’. On the initial screen create a project, a subproject and a transfer project. Press F8 to continue.


2.   Maintaining object attributes

Depending on the type of data to be converted and whether you want to create one or more files with converted regional structure data you have to determine a certain object type at this point. For City migration, user object type 0612.


3.   Defining source structures

Here, you have to specify the data structure of the source data to be converted. This will usually be flat structures, equally positioned next to each other. No field specification occurs here.


4.   Defining source fields

Enter the source data of the respective fields for each defined structure. Strictly observe the instructions of the provider to avoid an incorrect reading of field contents.


5.   Maintenance of structure relationships

Enter the source structures on which target structures are to be mapped. Depending on the object type selected for the data conversion different target structures are provided. The assignment can be performed intuitively.


6.   Field mapping and conversion rule

Here, the source data is mapped to the target data field by field. It is possible to map the same source field to several target fields. You can also define rules and specify fixed values. You should be very careful to avoid problems with the data transfer. That is, you should take all special features in the field contents of the source data into account, for example, and possibly caught through monitoring, particularly if this concerns key values incompatible to the SAP system.

You must fill the following fields with values



7.     Specify Files

In this step you describe all files to be used in the following steps:


If your legacy data is on the PC:

  1. In change mode, position the cursor on the line “Legacy data — on PC (frontend)”.
  2. Select Add entry.
    A popup is displayed.

    3.   Specify file path (F4 help), file name and description and other properties.


In Converted Data :

   1.   Specify Logical Path (F4 help)

   2.   Specify Logical File (F4 help)


Create Logical Path

Transaction code


   1.   Select logical file Path Definition from the right side menu and then click on new entries.

         Write the name of the path and its description. Then save it.

   2.   Choose the path and double click on Assignment of Physical path to Logical path.

   3.   Click on new entries and choose Syntax group UNIX with Phisical path <FILENAME>.

         Then save the entry.


Create Logical File

Transaction code


  1.   Double click on “Logical File Name Definition, Cross-Client. And then select New Entries

  2.   Give the name of the file, which should reflect its function.

   3.    Input Converted File Name from LSMW to field Physical File.

   4.    Input New Logical Path Name to field Logical Path


8.   Assign Files

The system automatically defaults the filename to the source structure

9.   Reading and converting data

Having performed the preparations described above the source files can now be read and filtered concerning the defined source structures. Then the determined data records have to be converted. As a result, the target files for the use in report RSADRLSM02 are generated.

10.  Start Direct Input Program

Input your Logical File Name to field log. file name city.


Assigned Tags

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

      good one

      Author's profile photo Former Member
      Former Member

      Really really useful...well done

      Author's profile photo Former Member
      Former Member


      In Converted Data :

         1.   Specify Logical Path (F4 help)

         2.   Specify Logical File (F4 help)


      As per this comment, when i'm clicking on Converted Data, i'm not able to see these input fields for Specify Logical Path and Specify Logical File.

      Is there a setting which is missing?

      Here's a screenshot -