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]
- log. file name city LSMW Specify Files->Converted Data
- log. file name postal codes LSMW Specify Files->Converted Data
- 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
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
Hi Pinar,
For which country You are loking for?
Regards
Krzysztof
HI for me I would like Czech Republic.
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