LSMW ( Legacy System Migration Workbench ) is a useful tool in SAP to transfer data from legacy systems into an R/3 System. LSMW supports a step-by-step process, if one step is executed and saved then next step automatically follows.

Apart from formation of project/ subproject/ object and recording, there are 14 basic steps included in LSMW. Below screen shots will clearly show the process.

Project, Subproject and Object:


On the initial screen, you can create a new project, corresponding subprojects and objects via Edit -> Create new entry.

In the initial screen, All objects provides a list of all projects created already. My objects displays a list of all objects you created personally.


01.PNG

Click on the execute button once the project, subproject and the object are created.



Step 1: Maintain Object attributes


02.PNG

Execute and click on change button


03.PNG

Click recording overview button

In this example, you will be updating the IT0002 master records with the help of recording a transaction (PA30)

04.PNG

OK

05.PNG

Enter tcode

06.PNG


Create…do the entries and save

07.PNG

Default All: Note that the fields are populated with default values. The values you entered when you recorded the transaction are set by default.

Repeat this step for all fields. Similarly, double-click on all other fields with default values and make appropriate changes. Once you have made changes, the recording overview screen looks as shown below:

08.PNG

Now double click on PERNR and clear the default value

Reset the values which we don’t want to give as input(But don’t clear their values)

Ex: X of TIMR6 2 choice


09.PNG

Save and back>back

Now choose the recording by F4…save…back


Step 2. Maintain Source Structures


010.PNG

Click object overview>Table

011.PNG

Copy Field name and Length(Pernr to Natio) in an excel sheet

Now come back and execute Maintain Source Structures


012.PNG

Click on display<>change and create source structure. Give a name and a description to the source structure as shown below:


013.PNG

OK>Save>back


Step 3. Maintain Source Fields

In this step, you need to list what fields are present in the source structure. The easiest way is to click on ‘Table Maintenance’ icon to enter Fieldname, Type and Length for each field as shown:


014.PNG

Execute

display<>change Put cursor on IT02(Source field)

Click on Table Maintaince(Ctrl_F9).


015.PNG

Now copy and paste field name Type and Length of fields from excel sheet

Save >back Save >back


Step 4. Maintain Structure relations


016.PNG

Execute save back

Step 5: Maintain field mapping and conversion rules


017.PNG

Change<>display


018.PNG


019.PNG

Accept proposal for every field…..save…back


020.PNG


Skip this 6th step….

Step 7: Specify files


In this step, we define how the layout of the input file is.

Now create the excel file …copy in txt. and execute from specify files. After that system will create a batch process, so run that process in background.


Thanks,

Gaurav Sharma

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply