LSMW (Legacy System Migration Workbench) is a standard SAP tool used to migrate data from non-SAP (legacy) systems into SAP. It is mainly used during data migration projects such as SAP implementation, system upgrades, or when large volumes of master data (customers, vendors, materials) or transactional data (purchase orders, sales orders) need to be transferred.
It is typically used:
- During initial SAP go-live to load historical data.
- For one-time or periodic data loads where manual entry is not feasible.
- When a business needs mass uploads/updates without custom ABAP programs.
The LSMW execution process follows 14 guided steps (though not all are mandatory):
- Maintain Object Attributes – Define project, subproject, and object.
- Maintain Source Structures – Define data hierarchy.
- Maintain Source Fields – List legacy fields.
- Maintain Structure Relations – Map source to SAP structures.
- Maintain Field Mapping and Conversion Rules – Map fields.
- Maintain Fixed Values, Translations, User Routines – Apply conversion logic.
- Specify Files – Upload legacy file (CSV/TXT).
- Assign Files – Link files to structures.
- Read Data – Load file into LSMW.
- Display Read Data – Verify uploaded values.
- Convert Data – Apply mapping rules.
- Display Converted Data – Check converted output.
- Create Batch Input Session – Generate posting session.
- Run Batch Input Session – Execute session and post data into SAP.
In short: Use LSMW when migrating or mass-loading data into SAP. Process = Define → Map → Upload → Read → Convert → Post.