Skip to Content
Author's profile photo Former Member

Step by Step process to transfer data via LSMW

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.


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

Step 1: Maintain Object attributes


Execute and click on change button


Click recording overview button

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




Enter tcode


Create…do the entries and save


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:


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


Save and back>back

Now choose the recording by F4…save…back

Step 2. Maintain Source Structures


Click object overview>Table


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

Now come back and execute Maintain Source Structures


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



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:



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

Click on Table Maintaince(Ctrl_F9).


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

Save >back Save >back

Step 4. Maintain Structure relations


Execute save back

Step 5: Maintain field mapping and conversion rules





Accept proposal for every field……back


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.


Gaurav Sharma

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ganappathi raja
      Ganappathi raja

      Hi Gaurav, Thanks for your brief document. Could You also help me to publish Training document to create LSMW template for creating material master data in SAP