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)

OK

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:

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:

Execute

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

Change<>display

Accept proposal for every field…..save…back

Skip this 6^th 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