Skip to Content
Author's profile photo Former Member

Plant Maintenance Master Data Create/ Upload using LSMW (Method: Batch Input Recording)

Applies to

SAP Plant Maintenance Module for Master Data upload.


Manufacturing Industries run on complex business processes and so require huge amount of Master Data like Machines and spare parts from tiny Bearings to giant Rollers. This article describes Creation/ Upload of Master Data in system using LSMW at one-go.

Author:        Ankur Saraf           

Company:    NTT Data Americas

Created on:  5 October 2012

Author Bio

Ankur Saraf is currently working in NTT Data Americas as SAP PM Consultant. He has knowledge in Maintenance Planning, Maintenance Order and Notifications Management, Serial Number Management and PMIS Reporting.

Table of Contents

LSMW: An Introduction

LSMW- Legacy System Migration Workbench is an SAP tool used for master data upload/ Create into the system. You can use this tool while uploading data from legacy system into R/3 environment or to create and upload master data of huge amount. This tool follows a step-by-step procedure of 14 steps to create the master data into the system.


Considerations: Before you proceed

There are following considerations which must be taken into account before you proceed with this tool:

  • SAP customization is already performed.
  • Transaction to be carried out is identified.
  • Examine carefully which fields in legacy file are mandatory and which can be left as optional from the SAP system point of view.
  • Comparison of functions between the legacy system and the SAP system must have been completed. As a result of comparison, the data to be migrated is determined.

Project preparation: Creating Project, Subproject and Object

Project: The project serves as an organizational unit used to combine mapping and field assignments.

Subproject: It is subordinated to the Project. For example, if project comprises of complete migration data for an organization which comprises of severalplant, then subproject comprises the data in the individual plants.

Object: A business object, which is used to transfer the data of a project to the SAP system.

  • Enter Transaction code – ‘LSMW’.


  • Enter the Project, Subproject, Object and description respectively by placing the cursor in the respective fields. 


     Enter Project, Subproject, Object and Description


Recording Creation:

  • In the Menu Bar, Goto- ‘Recordings’.


  • Create a new recording and give the description. System will automatically populate the ‘owner’ field.


  • Now enter the Transaction code: IE01 (Create Equipment)


  • Do not enter any Equipment name if you are willing to get it created referencing internal number range you have assigned while customizing.


  • In the ‘General’ tab provide your required details. Here Object type’, ‘Manufacturer’ and ‘Model number’ details are entered.


  • Enter ‘Location’ related data in the tab in respective fields.


  • Enter ‘Account assignment’ and ‘Responsibilities’ relevant data as per your business requirements.


  • Now Install Equipment in appropriate Function Location.


  • When ‘Saving’ the master data, system internally will be creating Recording so as to provide reusabiliy and reference for mass data upload.


  • The Recording created in the system looks like below:


  • Now click on ‘Default All’ to populate the fields of which details are accommodated in master data.


  • The completed recording overview contains the transaction code:


LSM Workbench: Process Steps

Master data upload through this tool comprises of following 14 steps procedure:

Step 1: Maintain Object Attributes

  • Start the data upload process by selecting the first step radio button–> Execute


By default, Object Attributes will be in ‘Display’ mode.

There are four Modes of Data Transfer :

  1. Standard/ Batch Input : Standard upload Programs
  2. Batch Input Recording : Here you can create a recording of your own and use it to upload / change data
  3. BAPIs : Standard BAPIs are used to upload Data
  4. IDOCs : Any Inbound IDOC function modules can be used to process the data

  Here, we are using ‘Batch Input Recording’ method to upload master data. 


  • Select ‘Display <-> Change’ button and get it in change mode.


  • Enter the Recording which was created through beginning steps, i.e.‘REC_EQUIP’ and click on ‘Save’.


When the first step is completed, the system takes you to previous screen and populates the field against it.


Step 2: Maintain Source Structures

Source structures can be used to design the hierarchy of the files to be uploaded. However, here highest hierarchy level is sufficient. Structures are prerequisites for Maintaining Source Fields.

  • Select the next step radio button and Execute. System then takes you to ‘Display’ mode of Source Structure.


  • In ‘Change’ mode give the ‘Source Structure’ and ‘Description’.


  • System shows the Source Structure created. ‘Save’ and go back.


Step 3: Maintain Source Fields

Source Fields are maintained in Source Structures.

  • Click button ‘Object Overview’ and select Table View.


  • From Table view, select ‘TABNAME’, ‘Type’ and ‘Length’ and maintain the excel sheet.



By default system takes to the ‘Display’ mode of Source Fields.


  • Go to Change mode, place the cursor on structure and click ‘Table Maintenance’ button.


  • Now, maintain the excel sheet values in Source Fields for Source Structure.


System takes internal table reference and populates the Field description with reference to Field name.


  • Save and go back.

System maintains the source fields as per hierarchy level


Step 4: Maintain Structure Relations

Here, the establishment of the structure relation is checked between Legacy and R/3 system.


  • Bring the screen into change mode, Save and then Back. No extra maintenance is required.


Step 5: Maintain Field Mapping and Conversion Rules

Here we assign source fields to target fields, which is the relationship establishment between legacy and R/3 environment.


  • All fields of all target structures, which were selected in the previous step, will be displayed.


  • Bring the screen into Change mode and then In menu bar, go to ExtrasàAuto Field Mapping



  • Now accept proposal for all the fields which need to upload.


At the end of proposal acceptance for all the entries system displays the below message:


  • After auto field mapping complete, save and back.


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

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


Note: To maintain the upload file with required field values, copy the details from ‘Target Fields’ by clicking the ‘Object Overview–> List’


Step 7: Specify Files

Here we define the Files that we use to upload the data.

Note: Generally we receive legacy file in excel format, so save this file as Text (Tab delimited).


  • Go to Change mode and specify the file to upload data.


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



  • Now Save and go back.

Step 8: Assign Files

Here, we make a check whether file is assigned to source structure or not.

  • Click on ‘Execute’ button.



  • Now Save and go back.

Step 9: Read Data

Here our data which is uploaded by the file would be read.

  • Click on ‘Execute’ and the data read status and number of records would be displayed on the screen.



Step 10: Display Read Data

Here, we can display the records which were read in previous step.


  • Check, whether data has been correctly fit into fields. We can also give the line selection based on need.


Step 11: Convert Data

Here,  the legacy data is converted into SAP standards. We can check the data converted later on.


  • Click on ‘Execute’ button and system displays the status for the data conversion.

Note: Check the number of records from Step 9. Both should be same.




Step 12: Display Converted Data

Executing this step displays the data converted in the previous step.


  • Click on any record to check the converted data.

  Note: Here the visual check can be performed to check the values lifted by the file against the fields of SAP to be correct and as per requirements. 


Step 13: Create Batch Input Session

In this step, we create batch input session.

Make sure to check box for ‘Keep batch input folder’.




Step 14: Run Batch Input Session

Here, we run the batch input session, which is created in the previous step.


  • Click on ‘Session’ and then on ‘Process’.


Note: Here, the options for the upload can be specified. It is advisable to process few records in ‘Foreground’ to capture the error while visual inspection.


Now, the Master data for the Equipment will get uploaded in the SAP System.

Related Content

Assigned Tags

      Comments are closed.
      Author's profile photo Jun Wu
      Jun Wu

      no image are visible...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Jun,

      Images are visible. Please use hi speed internet or try out with some latest version of browser and wait for some time to get images loaded.

      Author's profile photo Jun Wu
      Jun Wu

      if i put that url in browser, it gives error and seems to be authorization issue


      Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      You can access following link to see the document:

      Author's profile photo Jun Wu
      Jun Wu

      have you tried to access this doc anonymously?


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      while accessing the above link anonymously, I am not getting authorization issue, rather being redirected to login page and from there the whole document along with images is visible.

      Have you tried it by being logged in into the SCN? I hope it would work from there.

      Author's profile photo Jun Wu
      Jun Wu

      my god. so simple thing, why  you just don't understand.

      give you another example

      this pic is from another blog, if you access it directly , the pic will be shown, you don't have to login

      i have logged in, if not how can i post comment here.

      the pic in this blog are only visible to you..... not others.....


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      I think the problem is with you only as my friends from Europe and US location, even from India location are able to access it. Now I think you understood it.

      Author's profile photo Jun Wu
      Jun Wu

      can you access this doc anonymously?

      at least i can access following one anonymously.

      Author's profile photo Jun Wu
      Jun Wu

      no image visible

      Author's profile photo Former Member
      Former Member

      Hi Lucky,

      No Image visible..I'm from India


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Syed,

      I am aware of that. I have reported the issue to SCN Support and they have added the issue in their 'bug-list' along with other complex issues. Expecting the resolution from their side soon on the same.


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Dear All,

      Re uploaded all the images. Hopes its visible now to everyone.

      Author's profile photo Jun Wu
      Jun Wu

      perfect now

      Author's profile photo Former Member
      Former Member

      Why go to all the trouble of using the recording when you can use the objects and methods and SAP will create the structure for you? Much simpler and robust than a recording. Also able to enter long text where needed, measuring points, documents, etc, all in one upload.

      Author's profile photo Henryk Skrobol
      Henryk Skrobol

      Totally agree. In my projects, for initial data load I'm using SAP batch / direct input methods wherever possible as it's more safe, more universal and faster. Recording method is working fine for some data tuning / small adjustments which needs to be done after main load. Never the less - thank's for sharing !

      Author's profile photo Former Member
      Former Member

      It was still a great post and very helpful for the general community. A good reference is hard to find. Thanks for putting this together and posing.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      thanks Henryk and Michael. I agree that we can go for BAPI/function modules/other methods for complex/custom data uploads, however for small and mid-size businesses this approach still holds good and hence published so as to help out others 😉 . However, thanks for your look out and sharing views. 🙂

      Author's profile photo Former Member
      Former Member

      Wonderful posting..thanx a lot..

      Can you also give a sample test sheet for uploading..I tried to upload one..but somehow the mapping got all wrong..

      Author's profile photo swapnil rajane
      swapnil rajane

      Hi Lucky Soni,

      Very nice document. Thanks for sharing.

      Is it possible to you to share the Direct input method LSMW to create equipment task list and BOM.



      Author's profile photo Thirupathi Bheemanapalli
      Thirupathi Bheemanapalli

      Hi Lucky,

      This is nice document, if possible can u pls share strategy tasklist and maintenace plans as i was suffering a lot with uploading these things.



      Author's profile photo Former Member
      Former Member

      Thank you for this post. In our case equipment numbers are set to work with internal numbering. How do we handle a  map between old equipment number and new equipment number. Any thought ?

      Author's profile photo Former Member
      Former Member

      The Tech ID field or the sort field are the approporiate places for this data. You really should start a separate thread for this inquiry.



      Comments are closed.