Skip to Content
Author's profile photo Jazib Tariq

LSMW:Upload Master Data Using Batch Input Recording Part 1

Introduction

The Legacy System Migration Workbench (LSMW) is a instrument to transmit 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. This article explains clearly about each and every step.

Example, I am showing how to upload Personnel Data for an employee i.e. Infotype 0002 .

Creating Project/ Subproject and Object:

Go to LSMW

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

/wp-content/uploads/2013/11/1_322687.png

Recording:

In menu bar, Goto—->Recordings

/wp-content/uploads/2013/11/2_322715.png

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


/wp-content/uploads/2013/11/3_322716.png

Go to Transaction ‘PA30’

/wp-content/uploads/2013/11/4_322717.png

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

/wp-content/uploads/2013/11/5_322718.png

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

/wp-content/uploads/2013/11/6_322719.png

Save the Entry . The following screen will appear.

/wp-content/uploads/2013/11/7_322720.png


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

/wp-content/uploads/2013/11/8_322721.png


/wp-content/uploads/2013/11/9_322722.png

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

/wp-content/uploads/2013/11/10_322728.png

Step 1: Maintain Object Attributes

Select this radio button and click on execute

/wp-content/uploads/2013/11/11_322731.png

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)

/wp-content/uploads/2013/11/12_322732.png

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

/wp-content/uploads/2013/11/13_322743.png

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

/wp-content/uploads/2013/11/14_322744.png

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

/wp-content/uploads/2013/11/15_322748.png

Click on Object Overview—->select table

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

/wp-content/uploads/2013/11/16_322750.png

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.


/wp-content/uploads/2013/11/17_322754.png

/wp-content/uploads/2013/11/18_322755.png

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.

/wp-content/uploads/2013/11/19_322760.png

/wp-content/uploads/2013/11/20_322762.png

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

/wp-content/uploads/2013/11/21_322766.png

After Execute go to Extra and then Auto Field Mapping.

/wp-content/uploads/2013/11/22_322767.png

/wp-content/uploads/2013/11/23_322768.png

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)


/wp-content/uploads/2013/11/24_322769.png




Assigned Tags

      31 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Muhammad Umar
      Muhammad Umar

      Dear Jazib Tairq,

      Very helpful document. Thanks for sharing. Please continue sharing such a productive material.

      Regards

      Muhammad Umar

      Author's profile photo Former Member
      Former Member

      Very helpful document keep  sharing such material.

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks

      Author's profile photo Suhaib Bin Aziz
      Suhaib Bin Aziz

      good document and keep presenting your words and thoughts in such a good documents. well done.

      Best Regards,

      Suhaib Bin Aziz

      Author's profile photo antoine foucault
      antoine foucault

      Thank you for the review; Good stuff on LSMW!

      Best.

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks Antoine

      Author's profile photo Former Member
      Former Member

      Good Job Jazib. Keep it up.

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks Zeeshan

      Author's profile photo Sajida Ahsan Raza
      Sajida Ahsan Raza

      good work done bachaa

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks Miss

      Author's profile photo Former Member
      Former Member

      Dear Jazib Tariq,

      Nice and helpful document of LSMW.

      Santosh Shivane

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks Santosh 🙂

      Author's profile photo T G
      T G

      Dear Jazib Tariq,

      Appreciated your efforts for making this useful document.

      Did you observe that LSMW did not delimit infotypes while uploading mass data? 😕

      If so, is there a method to make LSMW to delimit infotypes while uploading data for infotype changes?

      Regards,

      TG

      Author's profile photo Former Member
      Former Member

      Nice one.... thanks

      Author's profile photo Former Member
      Former Member

      Dear Jazib,

      Nice Documents.

      Thanks and Regards,

      Arpit

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks TG, Venkatesh and Arpit 🙂

      Author's profile photo Former Member
      Former Member

      Hi Tariq,

      Your document is very good and useful.

      Could u please share the document for BDC

      Regards,

      Neha.

      Author's profile photo Former Member
      Former Member

      Dear Jazib Tariq,


      This manual is really helpful to me. Greatly appreciate your effort creating such a detailed documentation.


      Many thanks!


      Regards,

      Nguyen Anh Khoa

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks Khoa

      Author's profile photo Former Member
      Former Member

      nice document

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks Surya

      Author's profile photo Former Member
      Former Member

      Good walkthrough. Some of the screenshots are a bit blurry though. For those of you who want a crisper copy, follow this link : http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e04f8fc8-2ef3-2d10-dc8d-eb6fd0711157?QuickLink=index&overridelayout=true&49873160545562

      Author's profile photo Former Member
      Former Member

      Dear Triq, thanks for this details about LSMW.

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      My Pleasure Rajeev

      Author's profile photo Former Member
      Former Member

      Good Document. Can we upload the record for a change of position or organizational unit through T code pp01 or pp02 or pm01

      Iam can able to see the change but not able to see the change in the organizational assignment infotype

      😥  

      Author's profile photo Former Member
      Former Member

      Just want to comment and say this is great. Thanks for posting it!

      Author's profile photo Former Member
      Former Member

      nice

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Thanks Priya, Joseph, Andy

      Author's profile photo Former Member
      Former Member

      Hi Jazib Tariq,

      Thanks a lot for the document. Its very helpful. Please can you share the file format for this with sample data. It will really help me in my practise.

      Thanks again.

      Regards,

      Vandana

      Author's profile photo Jazib Tariq
      Jazib Tariq
      Blog Post Author

      Hi Vandana,

      You can use Excel as well as text file.
      File format depends on your fields selection.