LSMW Tools LSMW stands for legacy system migration workbench and it is a special form of data migration that is used in SAP, to transfer data from legacy. LSMW is a tool used to tranfer data from legacy system to R/3 periodically or supports conversion of data and Batch Input,BAPI,IDOC or. SAP Practice Manager, Quality Systems & Software () This document contains Step-by-step instructions to use LSMW to update Customer.

Author: Majora Dugal
Country: Madagascar
Language: English (Spanish)
Genre: Relationship
Published (Last): 23 January 2013
Pages: 129
PDF File Size: 2.91 Mb
ePub File Size: 3.32 Mb
ISBN: 382-4-28334-573-7
Downloads: 1355
Price: Free* [*Free Regsitration Required]
Uploader: Faegal

The tool supports conversion of data of the legacy system in a convenient way. Project, Subproject and Object: An ID with a maximum of 10 characters to name your data transfer project. If you want to transfer data from several legacy systems, you may create a project e. An ID with a maximum of 10 characters that is used as further structuring attribute.

An ID with a maximum ij 10 characters to name the business object. In the initial screen, All objects provides a list of all projects created already. My objects displays a list of all objects you created personally. All objects of the project displays all objects of the selected project as tree structure. Project documentation displays any documentation written for the individual popups and processing steps.

Maintain Object attributes In this example, you will be updating the Material master records with the stsps of recording a transaction MM Click on Done to actually start recording the transaction.

Enter the fields required for recoding a transaction successfully. Note that the fields are populated with default values. The values you entered when you recorded dico transaction are set by default. Repeat this step for all fields.

Similarly, double-click on all other fields with default values and make appropriate changes. Once you have made changes, the recording overview screen looks as shown below: Save the while going back to the main screen. After completing the recoding the system will automatically take ldmw to the second step as shown below: Give a name and a description to the source structure as shown below: Save the source structure and go to the main screen. Maintain Source Fields In this step, you need to list what fields are present in the source structure.


The easiest way is to click on ‘Table Maintenance’ icon to enter Fieldname, Type and Saap for each field as shown: Save while coming back to the main screen.

Since, there is only one Source and Target Structure, the relationship is defaulted automatically. Once all the fields are mapped, you should have an overview screen as shown Save while coming back to the main screen.

Maintain fixed values, translations, user-defined routines You can also maintain re-usable translations and user-defined routines, which can be used across conversion tasks.

What is SAP LSMW? Steps to Migrate Data using LSMW

In this case, that step is not required. Specify files In this step, we define how the layout of the input file is. The input file is a [Tab] delimited with the first row as field names. It is present on my PC local drive as C: Double Click on the legacy data.

Save while going to main screen. Create an Excel with your data and save it as a Tab-delimited text file on your local drive C and name it MM3. All the mandatory fields should be present in the flat file for the required transaction. Assign files Execute step ‘Assign Files’ and the system automatically defaults the filename to the source structure.

You have the option to read only selected rows and convert data values to internal format. Here 1 to 2 represents the number of rows to be read from the flat file. If you don’t specify any number the system will read all the rows from the flat file. We have 2 rows in the flat file hence from 1 to 2.


After we execute the data read from the flat file is as shown below.

What is SAP LSMW? Steps to Migrate Data using LSMW

Display read data This step is optional. If required, you can review the field contents for the rows of data read. This is the step that actually converts the source data in source format to a target format.

Based on the conversion stsps defined, source fields are mapped to target fields. Click BACK to come back to main screen. Display Converted data Again this is an optional step to view how the source data is converted to internal SAP format. Create batch input session Once asp source data is converted in an internal format, you can create a batch session to process updates.

Once you have successfully executed the batch input session, the Material master fixo are updated in the system. You can confirm this by viewing the Material master records MM You can Process the session in foreground or background or can only display errors. Appreciate your details for BDC recording process where you suggest to going back to the recording and removing all the default values.

A very important step that most other tutorials ignore to mention. WelcomeGuest Login Register.

SAP FICO Configuration Guide: LSMW step by step?

A t tachments 30 Page History. All the mandatory fields should be present in the flat file for the required transaction Step 8: Convert data This is the step that actually converts the source data in source format to a target format. Permalink Sep 02, Permalink Oct 07, Permalink Nov 23, Permalink Apr 09, Permalink Jun 01, Thanks very much for the tutorial.

Permalink May 29, Permalink Jun 12, Permalink Jun 22,