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: Dogor Mezikasa
Country: Equatorial Guinea
Language: English (Spanish)
Genre: Business
Published (Last): 11 August 2010
Pages: 393
PDF File Size: 20.45 Mb
ePub File Size: 1.20 Mb
ISBN: 655-6-55301-976-7
Downloads: 33800
Price: Free* [*Free Regsitration Required]
Uploader: Vudokinos

This can be a one-time transfer as well as a periodic one. LSMW also ssteps conversion of data of the legacy system in a numerous way.

Furthermore, the LSM Fici provides a recording function that allows generating a “data migration object” to enable migration from any required transaction. LSMW workbench shows the swp information- Project: 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 a further structuring attribute. An ID with a maximum of 10 characters to name the business object.

There are four Modes of Data Transfer: Standard upload Programs Batch Input Recording: Any Inbound IDOC function modules can be used to process the data Based on the requirement we try to find a suitable method to be processed. If it is a standard Master we can find it in the first method. If the requirement is a very custom one we use a recording to process the data. Suppose a file contains header rows and item rows, we can specify the first field as the indicator say ‘H’ for a header and ‘I’ for Item.

Lsmw Steps for Uploading Gl Master Data in Sap | Tapas Banerjee –

Thus when the file is being read, it checks the first field, if it is ‘H’ then it is read into the Header source structure else it is written to the item source structure. The Source fields can be easily maintained in the form of a table maintenance.


Step 4 – Maintain Structure Relationships The Structures which are needed for the processing of the data need to be assigned here.

The Object may contain many structures and many source structures. The Mapping steeps the source and the target structures should be done after careful checking. Step 5- Maintain Field Mapping and Conversion Rules In sgeps step, you assign source fields to target fields and define how the field contents will be converted.

All fields of all target structures, which you selected in the previous step, will be displayed.

For each target field the following information is displayed: Field description Assigned source fields if any Rule type fixed value, translation etc. Some fields are preset by the system.


These fields are called “technical fields” are marked with “Default setting”. The coding for these fields is not displayed when first entering the field mapping; it can be displayed via the display variant. Changing the default setting may seriously affect the flow of the data conversion. Fixed values are values which are fixed across the project eg: We can assign a fixed value to BUKRS and this fixed value can be used in all the objects in this project.

So if the value changes we can only change at one place i. Here you can maintain the fixed translation for any legacy field and the translation can be assigned to the filed, in Field Mapping and Ldmw Rules.

ficco Translation can be 1: These are user defined subroutines that are used in the object for processing the data. All the Three functions mentioned above are reusable Rules which are valid for all objects in one Project.

Step7- Specify Files Here we define the Files that we use to upload the data.


The File can be ni the Front end or in the application server. Step 9- Read Data Reading the data from the file gives us an option to read only a few records and not the entire chunk in order to enable Testing of first few records.

This also provides the user defined selection parameter which can be used to restrict the read data based on the condition specified.

Step Display Read Data In this step, you can display all or a part of the read data in table stepw. Clicking on a line displays all information for this line in a clear way.

The same happens when you click on Field contents. Change display allows selecting either a one-line or multi-line view. Display color palette displays the colors for the individual hierarchy levels. Step Convert Data Converting the data is the transfer of data from source to target structures based on the conversion routines written in maintain Field Mapping and conversion routines. Step Import Ifco The steps displayed ficoo the program depend on the selected object type: Standard batch input or recording: Generate batch input session Run batch input session Standard direct input: SAP FI is a module used ls,w reporting both externally and internally.

The objective is to record Analytic Privileges restrict the user to view data for which they authorize. Long term planning Simulative MRP is used to simulate the future demand and supply situation in Accounting Business Analyst Cloud Computing.

What is SAP LSMW? Steps to Migrate Data using LSMW

Ethical Hacking Informatica Jenkins. Source Filed is used to identify whether a certain record should go to the specified structure.

What is Calculation View?