Skip to Content

Define Number Ranges for Cities


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

Transaction code

SRN1

SAP CRM IMG menu

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.

No

From number

To number

NR Status

Ext

01

000000000001

999999999999

0

X

4.     Choose the Ext flag for the number range.

5.     Choose Save (Ctrl + S).


Data Migration – Step by Step


Transaction code

LSMW


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.

LSMW1.png


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.

LSMW2.png


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.

LSMW3.png


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.

LSMW4.png


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.

LSMW5.png


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

For cities: LANGU, STATUS, CITY_CODE, REGION, REGIOGROUP, CITY_NAME

LSMW6.png


7.     Specify Files

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

      LSMW7.png

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.

      LSMW8.png

In Converted Data :

   1.   Specify Logical Path (F4 help)

   2.   Specify Logical File (F4 help)

     LSMW9.png

Create Logical Path

Transaction code

FILE

   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.

     LSMW10.png

Create Logical File

Transaction code

FILE

  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

     LSMW11.png

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.

LSMW12.png

To report this post you need to login first.

2 Comments

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

Leave a Reply