LSMW Overview

Legacy System Migration Workbench (LSMW) is a graphical tool provided by SAP R/3 for migrating data from a Legacy System into SAP. This tool is available through an SAP standard transaction code ‘LSMW’.

-The actual data upload takes place from a specific transaction depending upon the requirement such as MM01 (Create Material Master).
-The data to be uploaded is entered in a Flat File (such as a text file). This text file is uploaded into a Batch Input Structure through the interface of LSMW.
-After populating the data into the Batch Input ructure, the LSMW transaction generates a Batch Input Session with a name. The session is then executed through transaction SM35 (Batch Input: Session Overview).

Read more

SAP Legacy System Migration Workbench(LSMW)

LSMW an abbreviation for Legacy System Migration Workbench is a tool in SAP that is used to migrate Legacy data into SAP.
It is a very important tool and easy to learn and master it. LSMW has a recording tool which can record the transaction and the fields to be uploaded. Thus upload of master data and transaction data is made very simple in this tool.You can use this tools in almost all modules for upload of master data and too some extent transaction data also. Thus in FI you can upload the following master data through this:Vendors, Customers, General Ledger, Asset master, Bank Master. You can upload Transaction balance through this i.e. an FI document.

In CO you can upload the following master data:Cost element, Cost center, Profit center, Activity types, Internal orders, Statisticalkey figures In other modules likewise you can upload other sets of master data. In this book creation of a Vendor master data with accounting view will be covered.


Create a project, sub project and object
Create Recordings
Maintain object attributes
Maintain Source Structure
Maintain source fields
Maintain Structure relations
Maintain field mapping and conversion rules
Specify file for upload and create a file for upload
Assign files
Read data
Display Read data
Convert data
Display converted data
Create Batch input session
Run Batch input session

Read more

Differences Between LSMW and BDC

The differences between LSMW and BDC are as follows:

LSMW is generally for normal SAP applications, while BDC is mainly for any customized applications.

LSMW is a Non-SAP to SAP communication TOOL, whereas BDC is a SAP to SAP communication UTILITY.

Read more

Checklist for LSMW

Pre-Check LSMW: To-Do-List Before Using the Tool

The LSM Workbench is a tool that supports the transfer of data from non-SAP systems to R/3. Basic functionality of the LSM Workbench:

1.      Import old data from spreadsheet tables or sequential files.

2.      Convert the data from source format into target format.

3.      Import the data into R/3.

Read more

Step by Step Guide to Upload New Customer Master Record

Step by Step Guide to Upload New Customer Master Record With LSMW

From the material;
The LSM Workbench is an R/3-based tool that supports you when transferring data from non-SAP systems (“Legacy Systems”) to R/3 once or periodically.
The tool supports conversion of data of the legacy system in a convenient way. The data can then be imported into the R/3 system via Batch input, Direct input, BAPIs or IDocs. LSM Workbench provides a recording function that allows to generate a “data migration object” in an entry or change transaction. Through LSMW, we can upload Master Data and Transaction Data.

Read more

Step-by-Step Guide for Using LSMW

Step-by-Step Guide for Using LSMW to Update Customer Master Records

This document contains Step-by-step instructions to use LSMW to update Customer Master Records. It has two demonstration examples – one using Batch Recording and another using standard SAP Object.

Read more