Fast Data Conversion, Migration, and Updates for Functional Analysts with LSMW

  • by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software
  • July 15, 2003
SAPepxerts/Financials
Data conversion is no longer a one-time activity. Gone are the days when it was required only during an initial SAP implementation project. Here are some day-to-day business scenarios when you may be called upon to convert data.

Data conversion is no longer a one-time activity. Gone are the days when it was required only during an initial SAP implementation project. Here are some day-to-day business scenarios when you may be called upon to convert data:

  • Mass updating cost centers to better reflect a new organizational structure
  • Uploading initial account balances for a newly merged company
  • Uploading open invoices for customers or vendors
  • Updating customer or vendor records for specific fields

Let’s take the last example, the common business requirement of updating a few fields of the customer master records. You could use Mass Maintenance to do mass updates, or as an alternative, you could use Computer Aided Test Tool (CATT). Both would work for some simple scenarios, but they may not be as useful for other situations. For example, Mass Maintenance cannot be used for transaction-based recordings, and CATT is more suitable for testing transactions.

For any complex data-massaging requirement, you probably call on your technical team to develop a customized ABAP program. The problem is that ABAP development is a time-consuming process. For complex programming, that is fine. However, when you want to perform a simple update or conversion, ABAP development is overkill, especially if this is a one-time requirement. I know of many sites with numerous ABAP programs that they are not using anymore.

As a functional analyst, you may have wished that you could quickly update customer master records from an Excel sheet, or that you could quickly convert a customer’s open invoices. If so, I suggest you consider LSMW (Legacy System Migration Workbench). You can download it free-of-charge from the SAP service marketplace (http://service.sap.com/LSMW).

Mitresh Kundalia

Mitresh Kundalia heads the SAP practice at Quality Systems & Software (www.QSandS.com), 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


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.