What is SAP LSMW? Steps to Migrate Data using LSMW

Details
What is SAP LSMW?

LSMW is a  tool that supports the transfer of data from non-SAP systems ("Legacy Systems") to SAP  R/3 systems. This can be a one-time transfer as well as a periodic one.

LSMW also supports conversion of data of the legacy system in a numerous way. The data can then be imported into the SAP R/3 system via batch input, direct input, BAPIs or IDocs.

Furthermore, the LSM Workbench provides a recording function that allows generating a "data migration object" to enable migration from any required transaction.

 

  1. Import data (legacy data in spreadsheet tables and/or sequential files)
  2. Convert data (from source format to target format)
  3. Import data (into the database of the R/3 application)
To start the LSMW workbench use transaction LSMW
 
What is SAP LSMW? Steps to Migrate Data using LSMW

 

Also, check out next tutorial on executing LSMW Step by Step

Enter Transaction LSMW in SAP, to start the workbench.

 

What is SAP LSMW? Steps to Migrate Data using LSMW LSMW workbench shows the following information-

Enter Project ID, Subproject ID, Object ID.  Click Execute The next screen gives the STEPS in your LSMW data Migration

 

What is SAP LSMW? Steps to Migrate Data using LSMW You can select the desired step and click execute. Let's look into each step in details

Step 1- Maintain Object Attributes.

  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

Based on the requirement we try to find a suitable method to be processed. If it is a standard Master we can find it in the first method. Otherwise, we try to use BAPIs or Idocs. If the requirement is a very custom one we use a recording to process the data.

Step 2 - Maintain  Source Structures

In this screen, the Fields which will be uploaded from the text file can be maintained here. The fields with identical names are taken as the Key

 

What is SAP LSMW? Steps to Migrate Data using LSMW

The Source fields can be easily maintained in the form of a table maintenance.

Step 4 - Maintain Structure Relationships

The Structures which are needed for the processing of the data need to be assigned here. The Object may contain many structures and many source structures. The Mapping between the source and the target structures should be done after careful checking.

 

What is SAP LSMW? Steps to Migrate Data using LSMW In this step, you assign source fields to target fields and define how the field contents will be converted.

 

What is SAP LSMW? Steps to Migrate Data using LSMW All the Three functions mentioned above are reusable Rules which are valid for all objects in one Project.

  Here we define the Files that we use to upload the data. The File can be on the Front end or in the application server.

  Here we define which file we are going to use for current upload i.e. whether the file is on Presentation server or application server.

    Accounts Receivable is a submodule of SAP FI used to manage and record Accounting data for all the...