Skip to Content

This is the first part of my blog about LSMW migration

The business case:

The SAP regional structure is delivered empty and must be filled by the customer, this means that the customer is responsible for obtaining the country-specific data for filling the regional structure. Also customers are responsible maintaining it. This country-specific postal data can usually be obtained from the relevant country’s post organization or an third party source.

Example described below- filling the regional structure for the country Germany.

Step 1. File in form:

CITY_CODE/REGION/CITY_NAME/CITYP_CODE/POST_CODE

Step 2. Program LSMW

1. Maintain Object Attributes

Object                        0602

Method                      0000

Program Name           RSADRLSM02

Program Type            D

2. Maintain Source Fields

Like file from pkt 1.

3. Maintain Structure Relations

Depend of target – mandatory two first.

4. Maintain Field Mapping and Conversion Rules

ADR_LSM0.DATA_ID        CT

ADR_LSM0.LANGU           D

ADR_LSM0.STATUS           Constant ‘’

ADR_LSM0.CITY_CODE   file

ADR_LSM0.REGION          file

ADR_LSM0.CITY_NAME  file

ADR_LSM0.CITY_CODE   file

ADR_LSM0.POST_CODE   file

ADR_LSM0.FLAG_DELIV Constant ‘X’

ADR_LSM1.DATA_ID         PC

ADR_LSM1.LANGU           D

ADR_LSM1.STATUS           Constant ‘’

ADR_LSM1.CITY_CODE   file

ADR_LSM1.REGION          file

ADR_LSM1.CITY_NAME file

ADR_LSM1.CITY_CODE   file

ADR_LSM1.POST_CODE   file

ADR_LSM1.FLAG_DELIV Constant ‘X’

5. Specify Files till convert Data – standard LSMW process

6. Start Direct Input Program [RSADRLSM02]

  1. log. file name city                  LSMW Specify Files->Converted Data
  2. log. file name postal codes    LSMW Specify Files->Converted Data
  3. log. file name log                   free file name

Read log if everything is OK!

Step 3. Important Settings

1. OY17 -> Details for country             City file active[x] and/or Street postcode [x]

2. SRN1- > Intervals                             Like intervals in file (CITYP_CODE)

Related Documents

http://wiki.sdn.sap.com/wiki/display/SI/RSADRLSM02

To report this post you need to login first.

4 Comments

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

  1. Pinar Oezalp

    Dear Krzysztof,

    I know that the SAP regional structure is delivered empty and must be filled by the customer, but is there any data providers supporting the customers to fill in the city/region/street files?

    thanks in advance,

    best

    Pinar

    (0) 
  2. Raj K

    Hi Experts,

    Is anyone aware of the regional structure update process using the Canada Post files. I would require the LSMW details to convert the Canada Post files into the RSADRLSM02 file format so that the most updated regional structure elements from Canada Post are loaded into SAP.

    Thanks

    Raj

    (0) 

Leave a Reply