Creating Project/ Subproject and Object:

Go to LSMW

Give the name of the Project, Subproject and Object as desired



Recording:

In menu bar, Goto----/Recordings



Now, Select ‘Recordings’ and create ----/Give recording name and description





Go to Transaction ‘PA30’



In Master data maintain screen, give Personnel No, infotype and subtype (if any), and click on create



Select The fields in whioch you want to input the data.



Save the Entry . The following screen will appear.





Now, click on Default All and save and press back

We are clicking ‘Default all’ button, so that all the fields which we touched during recording are included







Save and back to main Screen.

Processing basic steps in LSMW:

LSMW need to be configured 14 basic steps. Below you will find detailed step-by step procedure.

Click On execute



Step 1: Maintain Object Attributes

Select this radio button and click on execute



Now, click on Display/ Change icon 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 (Recording Name)



Save and Back.

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.

Select source structure and create



First click on Change button and then click on create button.



Save and Back.

Step 3: Maintain Source Fields

Here we assign all the fields which need to upload to source structure.

Click on Object Overview----/select table



Click on Object Overview----/select table

Click on change and then select the source field and then Table.



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.







Save and 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.





Save and Back.

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



After Execute go to Extra and then Auto Field Mapping.





Now accept proposal for all the fields which need to upload

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

No need to maintain this step, unless and until if there exist any user defined routines, which helpful for reusable.

Step 7: Specify Files

In this step, you specify the location of the legacy file.

Note: Generally we receive legacy file in excel format, so save this file as Text

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

свернуть