Checklist for LSMW

Pre-Check LSMW: To-Do-List Before Using the Tool

The LSM Workbench is a tool that supports the transfer of data from non-SAP systems to R/3. Basic functionality of the LSM Workbench:

1.      Import old data from spreadsheet tables or sequential files.

2.      Convert the data from source format into target format.

3.      Import the data into R/3.

Before using the LSM Workbench, you need a concept for data migration. In particular, note the following items:

·       Make sure that R/3 customizing is complete.

·       Analyze the data existing in the legacy system to determine which data will be needed in the future (also from a business-operational point of view).

·       Consider whether usage of the tool makes sense with regard to the data volumes to be transferred. In case of very small data quantities, it may be easier to carry out the transfer manually. With very large data volumes, however, batch input technology may lead to excessively long runtimes. Rough estimate for the required time: 10000 records per hour; this value, however, may vary strongly depending on the hardware.

·       Identify the transaction(s) in R/3 you want to use for bringing the data into the SAP System. Here, it may also be relevant whether the data is required for statistical (evaluation) purposes or for further processing in the system.

·       Test the relevant transaction in R/3 manually with test data from the old system and make sure that all required fields are filled. There may be required fields that do not correspond to any data window in the legacy system. In such a case, assigning a fixed value or defining the field as optional for data transfer may be appropriate.

·       Check the interfaces provided by the application. Is there a batch input program and an IDoc (for example)? Which method should be used in your project?

·        Develop a mapping plan in written form: Assign the legacy system fields to the R/3 fields.

·       Determine the form (e.g. via „MOVE“ or assigned according to a rule) in which the legacy system data shall be transferred to the SAP System.

·       If applicable, define the allocation rules (LSM-internal name: „translation rules“).

·       Define the way for extracting the data from the legacy system. (Note: LSMW does not extract data.)

·       Describe the form in which the old data are available: Will the host or the spreadsheet interface of the LSMW have to be used?

·       If only a part of your legacy system will be replaced by R/3, define the functionalities to be provided by the SAP System and those to be provided by the legacy system. If required, create a concept of the data flows and interface architecture.


These questions can only be answered individually for every customer; as a matter of course, this should be done before the tool is used!

Leave a Comment