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 (http://service.sap.com/LSMW). 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 (www.QSandS.com). QS&S is a leading business and technology consulting firm that specializes in delivering superior IT solutions using SAP products. Mitresh is widely acknowledged as a leading SAP expert and has worked on various SAP assignments, including strategic planning, fresh implementations, upgrades, and post-go-live support projects. With an MBA degree in finance, Mitresh manages SAP projects with a special focus on customer-focused solutions, management reporting, profitability analysis, SAP General Ledger, and business intelligence. He is a regular contributor at SAP events and publications and technical advisor to leading journals.

See more by this author


Comments

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.