Migrating Customer data along with relationships (CRM) using LSMW

By Srinivas, Infosys

1   Introduction

This document provides a simple and user-friendly step-by-step approach for working with LSMW. The document mostly covers the practical usage of LSMW with respect to Batch input Recording Method.

This document may be used to gain an insight of LSMW process in SAP CRM environment and may be used as a guide to help the consultants during the initial loading of master data into SAP database tables.

2         LSMW

The Legacy System Migration Workbench (LSMW) is a tool that supports data migration from legacy systems (non-SAP systems) to SAP systems. It is a cross-platform component of the SAP system. The tool has interfaces with the Data Transfer Center and with batch input and direct input processing as well as standard interfaces BAPI and IDoc.

The tool migrates user-defined datasets (known as objects), which are combined according to business criteria instead of individual tables or field contents. In addition to using standard import techniques, the user-specific objects can be generated.

The LSMW supports a one-time transfer of data (initial data load) and also offers a restricted support of permanent interfaces. Thus, a periodic transfer of data is possible. The LSMW, however, does not include any functions for monitoring of permanent interfaces. The tool does not support any data export interfaces (outbound interfaces).

Fig : LSMW-Process flow diagram 

3        Creation of Project Hierarchy

Use the Transaction Code LSMW to go to the initial screen. Create a project, corresponding subproject and object using Edit -> Create entry on menu bar. This is a hierarchy maintained in LSMW for all the data transfer done.  

Fig-01: LSMW - create project hierarchy 

Create a project, subproject and an object and click on continue. The following screen is displayed with the Project hierarchy details: 

Fig-02: LSMW- Initial screen

Once the project Hierarchy is being created, an enumeration of steps for data migration is displayed as shown in Fig-03 below.  

This can be changed depending on the requirement of the user. For this “User Menu” tab in the tool bar needs to be clicked and all the necessary steps required for data transfer need to be selected. 

Continued...