What Is LSMW In SAP?

Are you curious to know what is LSMW in sap? You have come to the right place as I am going to tell you everything about LSMW in sap in a very simple explanation. Without further discussion let’s begin to know what is LSMW in sap?

In the vast landscape of SAP (Systems, Applications, and Products in Data Processing), LSMW stands as a crucial tool for data migration and conversion. LSMW, short for Legacy System Migration Workbench, is a powerful utility that facilitates the transfer of data from legacy systems to SAP systems. This article aims to provide a detailed insight into what LSMW is, its functionalities, and how it is used across various modules within SAP.

What Is LSMW In SAP?

LSMW, or Legacy System Migration Workbench, is a tool provided by SAP for data migration from legacy systems into SAP. It serves as a framework for transferring data in a structured, efficient, and automated manner. LSMW simplifies the complex process of data migration, enabling organizations to streamline their transition to SAP systems.

Key Features Of LSMW

  • Structured Data Migration: LSMW provides a structured approach to data migration, allowing users to define data mapping, conversion rules, and field assignments.
  • Data Validation: It includes built-in functionalities for data validation and error handling, ensuring data accuracy and integrity during migration.
  • Support for Various Data Formats: LSMW supports multiple data formats such as Excel, TXT, and CSV, making it versatile for different legacy system configurations.
  • Reusability: Once configured, LSMW projects can be reused for similar data migration tasks, saving time and effort for future migrations.
  • Step-by-Step Wizard: The tool offers a user-friendly wizard interface, guiding users through each step of the migration process.

LSMW 14 Steps In SAP

The LSMW process consists of 14 distinct steps, each serving a specific purpose in the data migration journey. These steps can be summarized as follows:

  • Maintain Object Attributes: Define the object type and attributes for data migration.
  • Maintain Source Structures: Specify the structure of the source data file.
  • Maintain Source Fields: Map the source fields to SAP fields.
  • Maintain Structure Relations: Establish relationships between source and target structures.
  • Maintain Field Mapping and Conversion Rules: Define field mapping and conversion rules for data transformation.
  • Maintain Fixed Values, Translations, User-Defined Routines: Configure fixed values, translations, and routines for data manipulation.
  • Specify Files: Specify the source data file and format.
  • Assign Files: Assign the source data file to the LSMW project.
  • Read Data: Read the data from the source file into LSMW.
  • Display Read Data: Display the read data for review and validation.
  • Convert Data: Convert the source data into SAP-compatible format.
  • Display Converted Data: Review the converted data and address any conversion errors.
  • Create Batch Input Session: Generate a batch input session for data upload.
  • Run Batch Input Session: Execute the batch input session to upload data into SAP.

LSMW In SAP Modules

LSMW finds application across various SAP modules, including Materials Management (MM) and Sales and Distribution (SD). In MM, LSMW is utilized for tasks such as material master data migration, vendor master data migration, and purchase order data migration. Similarly, in SD, LSMW is employed for customer master data migration, pricing data migration, and sales order data migration.


In SAP, LSMW can be accessed using the transaction code LSMW. This transaction code provides direct access to the Legacy System Migration Workbench, allowing users to create, maintain, and execute LSMW projects seamlessly.


In conclusion, LSMW plays a pivotal role in data migration and conversion within SAP environments. Its robust features, user-friendly interface, and versatility make it an indispensable tool for organizations transitioning to SAP systems. By understanding the intricacies of LSMW and its application across different SAP modules, businesses can streamline their data migration processes and accelerate their journey towards digital transformation.


What Are The 4 Methods Of LSMW?

LSMW tool provides 4 different methods for upload: Direct input method, Batch input recording, BAPI, IDOC. In the first step of LSMW of maintaining object attributes we need to mention which of the above method we want to use.

What Are The 14 Steps In LSMW?

  • Step 1: Maintain Object Attributes. …
  • Maintain Source Structures. …
  • Maintain Source Fields. …
  • Step 4: Maintain Structure Relations. …
  • Step 5: Maintain fields mapping and conversion rules. …
  • Step 6: Maintain fixed values, translations, and User-defined routines for LSMW. …
  • Step 7: Specify the local files. …
  • Step 8: Assign files.

How Do You Write LSMW In SAP?

Steps to follow:

  • Enter the TCode LSMW.
  • Enter a Project, Subproject and Object name. …
  • Click on the Create icon next to Execute button and enter a breif description of your LSMW.
  • Now click on execute as highlighted.
  • An LSMW has 13 steps as you can see in the screenshot below:

What Is The Difference Between LSMW And Bapi?

LSMW is the tool provided by SAP to upload the data into SAP. There are many methods again used in LSMW to upload data. BAPI is one of the method in LSMW that is used to upload data. LSMW differs from BDC, such that even a functional consultant can upload data using LSMW without writing the code.

I Have Covered All The Following Queries And Topics In The Above Article

What Is LSMW In SAP Pdf

LSMW In SAP Step By Step

SAP LSMW Step By Step Pdf

LSMW 14 Steps In SAP


LSMW Is Used For?