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)
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…..save…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.