Mass Changes with LSMW: An Easier Method for Complex Requirements

  • by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software
  • July 1, 2004
SAP’s Legacy System Migration Workbench (LSMW) is a free tool that is often more useful than other options for performing mass changes within R/3. Using two examples from R/3 SD, the author shows a method that allows LSMW to directly access R/3 data so you can handle more complex requirements.
In the May 2004 issue of SCM Expert, I showed you how to use the Legacy System Migration Workbench (LSMW) for your day- to-day logistics data conversion activities.1 Numerous requests for more information about using LSMW have inspired me to follow up that article with an advanced trick for using LSMW to meet your more complex mass change business requirements in an SAP R/3 system. For those of you who have not read the earlier article, LSMW is a free, fully supported tool from SAP that can help you to, for example, quickly update customer master records from an Excel sheet or change pricing dates for specific sales orders. It is standard starting with Web Application Server 6.2. For earlier releases, you can download it from SAP Service Marketplace ( Table 1 compares LSMW with other means of performing mass changes within R/3.

Mitresh Kundalia

Mitresh Kundalia heads the SAP practice at Quality Systems & Software (, a consulting firm specializing in SAP S/4HANA, SAP General Ledger, and complex System Landscape Optimization (SLO)-type reorganizations. Mitresh is widely acknowledged as a leading SAP expert, with multiple publications and an SAP-PRESS book to his credit. He has published more than 50 peer-reviewed articles and white papers, and he has given presentations at various SAP conferences and events. Mitresh is the chief solutions architect of General Ledger Migration Optimizer (GLMO), a leading product to accelerate and jump-start the SAP S/4HANA and SAP General Ledger initiatives; SAP Data Reorganization Optimizer (SDRO), an SLO-type product for managing complex system landscape reorganizations; and Group Currency Activation and Conversion (GCAC), a product suite to manage introduction of parallel currencies and conversion of data in a live SAP system.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.