LSMW for OM Objects (org. unit, positions, jobs)

Hi Friends,

I want share some knowledge regarding how to upload the OM Objects like jobs, positions & Org. units through LSMW with batch input recording.
I know everyone is well versed with this LSMW, just consider it as a quick reference and step-wise document for who doing for the first time LSMW for OM Objects.


We have to create all the OM Objects External Number range before uploading the objects through LSMW. Because system will not consider for Internal number ranges while recordings.

T-code: OONR

lsmw 1.JPG

Creating Project / Subproject and Object:

Go to Tcode- LSMW

Click on Create button and give the name of the Project, Subproject and Object as desired

*Give Project names as SMALL otherwise while assigning upload file at step 7 Specify files, error will come. System path is not allowed more than 45 words (this is standard by the system)

lsmw 2.JPG

Press Enter

Recording: Sample recording of Objects

  1. In menu bar, Goto Recordings

lsmw 3.JPG

Now click on Create Recording and give the Recording name and description

lsmw 4.JPG

System will ask for Transaction code, give PP02

lsmw 5.JPG

Maintain the fields that are mandatory, to create object types

lsmw 6.JPG

Save the Record and click the button Back

Now system will show the recording results in the screen Create Recording
Click the Button Default All to default the system for Technical fields which are entered while recording

lsmw 7.JPG
Save the screen and go back our Recording was completed

lsmw 8.JPG
Once again go back to the LSMW screen and Execute the Project

lsmw 9.JPG

Now, we have to do step by step LSMW (14 steps)

lsmw 10.JPG

Step 1: Maintain Object Attributes

Select this radio button and click on executeà (Do same for other steps)
Now, click on Display/ Change icon (do this for every step, because by default it will be display mode)
Here, we are telling system that what kind recording should take into consideration while performing upload.
Select ‘Batch Input Recording’ and give name as shown below
Save and back

lsmw 11.JPG
Step 2: Maintain Source Structures

Source structures are helpful in building hierarchical relationships. While uploading the data system always checks highest level structure first before going for subordinate structure.
  1. Select source structure and createà
  2. Enter details as shown belowà

lsmw 12.JPG
Save and go back

Step 3: Maintain Source Fields

Here we assign all the fields which need to upload to source structure.
  1. Click on Object Overviewà select tableà

lsmw 13.JPG
Copy the fields and length in excel sheet (for temporary)
Note: exclude TABNAME and TCODE which are not required to maintain separately, system will take these from recording we made.
Make excel sheet as shown:

lsmw 14.JPG

  1. Now select ‘Maintain Source Fields’ button and execute
  2. Click on ‘table maintenance

lsmw 15.JPG

Paste from the excel sheet which we maintained.
* we can take either C or D for the Date format accordingly upload data has to be maintained

lsmw 16.JPG
Save and go back

Step 4: Maintain Structure Relations

Here we check whether structure relations between legacy and R/3 established or not.
In this step there is no need to change, just save and come back.

lsmw 17.JPG

Step 5: Display Field Mapping and Conversion

Here we establish the relationship between legacy and R/3 based on object fields.
In menu bar, go to Extrasà Auto Field Mapping
Note: Make sure that you select your recording before auto field mapping

lsmw 18.JPG
Click on accept proposal for all the fields which want to upload

lsmw 20.JPG

After auto field mapping complete, save and back.

Step 6: Maintain Fixed Values, Translations, User-Defined Routines

No need of this step-6

Step 7: Specify Files

In this step, you specify the location of the legacy file. The file in tabular form with first row field names

Now, double click on ‘Legacy Data – On the PC (Front End)

lsmw 21.JPG
lsmw 22.JPG

lsmw 23.JPG

Save and go back

Example of Excel file to upload in the .TXT form

lsmw 24.JPG

Step 8: Assign Files

Here, we just check whether file is assigned to source structure or not.
lsmw 25.JPG
Save and go back

Step 9: Read Data

Here our legacy data is read

lsmw 26.JPG
Execute Now, next screen shows how many number of records have been read

lsmw 27.JPG

Step 10: Display Read Data

Here, we can display all for part of the data by giving line numbers

lsmw 28.JPG
Check, whether data has been correctly fit into fields

lsmw 29.JPG
Step 11: Convert Data

Here, whatever data has been read will convert to SAP standards.

lsmw 30.JPG
Click on Execute button, it shows how many records have been converted. It should be same as data which have been read in step 9.

lsmw 31.JPG

Step 12: Display Converted Data

Here, converted data can be viewed for cross check.
lsmw 32.JPG
Data from the legacy file is fitting to correct fields, so we configured all prior steps without any mistake.
Note: If data is not fitting correctly, then we need to cross check Step3 and Step5.

Step 13: Create Batch Input Session

In this step, we create session for batch input
Make sure you check box for ‘Keep batch input folder’ is active

lsmw 33.JPG

Step 14: Run Batch Input Session

Here we run the batch input session which we created in step 13.
Select Session and execute process

lsmw 34.JPG

Here we can choose options, how upload should be done

lsmw 35.JPG
It is recommendable that, first 3 to 4 records upload foreground to make sure data is uploading correct, for rest of records select ‘Display errors only.

Now legacy data will we upload to Master data of employees in SAP system.

Testing: whether objects are created or not

Table V_T527X (Org. units)

lsmw 36.JPG
Table T528B (Positions)
lsmw 38.JPG
Table T513 (Jobs)
lsmw 37.JPG

For relationship LSMW:

Objects Relationships and Report RHINTE10

No comments:

Post a Comment