LSMW Tutorial: Step by Step Guide to Update Customer Master Records

As a part of reorganization and to better serve the customer needs, you are regrouping many of the customers. In SAP terms, you are changing the Sales Office, Sales Group and Customer Groups for specific Customer Master Records. Typically, you would maintain customer records with transaction XD02 to update ‘Sales View’. You would enter Customer Key (Customer No, Sales Organization, Distribution Channel, and Division) and update relevant fields on Sales View screen.

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

Another Step by Step LSMW Tutorial

Recently I have come across another informative site for various SAP topics. Differing from other LSMW tutorials, this site gives very detailed steps with screenshots and notes. You will also find tips and tricks for some specific objects. You can see tutorial from HERE .
You will also find a lot topics under FICO, HCM, Reporting Tools, BW, Cross Systems. To visit site click HERE

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

LSMW Tutorial

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

Frequently Asked Questions Concerning LSMW

What is the LSM Workbench?

The LSM Workbench is an R/3-based tool that supports single or periodic data transfer from your non-SAP system to R/3

What are the core functions of the LSM Workbench?

Importing legacy data from PC spreadsheet tables or sequential files
Converting data from its original (legacy system) format to the target (R/3) format
Importing the data using the standard interfaces of R/3 (IDoc inbound processing, batch input, direct input) Read more