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). 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.