LSMW

Former Member · ‎2008 Apr 24

Hi SAP gurus,

I would like to know more about LSMW.

What is that component for . How to use it? Where i can more infomationon that .

Thank you.

Warmest regards,

Former Member · ‎2008 Apr 24

Hi,

In simple words its a data uploading tool. Very much simple to do the data migration with this tool.

Tool desings the most of the logic by itself.

Just create the target structure to upload the data. Create the source structure based on ur file format map those 2 thats it.

Former Member · ‎2008 Apr 24

hi asish,

SAP Data Migration with LSMW

No ABAP effort are required for the SAP data migration. However, effort are required to map the data into the structure according to the pre-determined format as specified by the pre-written ABAP upload program of the LSMW.

The Legacy System Migration Workbench (LSMW) is a tool recommended by SAP that you can use to transfer data once only or periodically from legacy systems into an R/3 System.

More and more medium-sized firms are implementing SAP solutions, and many of them have their legacy data in desktop programs. In this case, the data is exported in a format that can be read by PC spreadsheet systems. As a result, the data transfer is mere child's play: Simply enter the field names in the first line of the table, and the LSM Workbench's import routine automatically generates the input file for your conversion program.

The LSM Workbench lets you check the data for migration against the current settings of your customizing. The check is performed after the data migration, but before the update in your database.

So although it was designed for uploading of legacy data it is not restricted to this use.

We use it for mass changes, i.e. uploading new/replacement data and it is great, but there are limits on its functionality, depending on the complexity of the transaction you are trying to replicate.

The SAP transaction code is 'LSMW' for SAP version 4.6x.

For those with the older SAP version (4.7 and below), the data migration programs might not have been pre-loaded.

You can download the LSMW at no cost from SAPNet under Services, SAP Methodology and Tools, category Tools.

If you are an existing SAP customer with an OSS ID, you can access the SAP Service Marketplace to download the LSWM for your Basis teams to install to your SAP system: http://service.sap.com/lsmw

The LSM Workbench carries out the following tasks:

Reads the transfer data from one or more files (for example, spreadsheets, sequential files etc.)

Converts the data from the source format into the target format

Note that with background processing, the input file must not be located in the presentation server. Access to presentation server files is only possible when you are working online.

see the below links for more knowledge on it

http://www.sapbrainsonline.com/TUTORIALS/TECHNICAL/LSMW_tutorial.html

http://abapprogramming.blogspot.com/2008/03/abap-lsmw-direct-input-method.html

http://saptechnical.com/Tutorials/LSMW/LSMWMainPage.htm

thanks

karthik

reward me points if usefull

Former Member · ‎2008 Apr 24

Hi Ashish,

Ther are data transfer methods like direct input an d batch input bu tthis LSMW is a tool given by SAP to the customers free of cost.

This is very useful for the customer bcoz he can make use of it and upload the data.this reduces the developement cost for the customers which is very important point to remember.

This even have all transfer methods like

1.Direct input

2.Batch input

3.BAPI

4.IDocs

Almost all there will be seven steps in common for all the methods.later based on the data transfer methos steps will be varying.you can refer to following links to know more abt LSMW

1.http://www.saptechnical.com/Tutorials/LSMW/LSMWMainPage.htm

2.http://www.saptechnical.com/Tips/LSMW/LSMWMain.htm

Former Member · ‎2008 Apr 25

Hi Ashish singh,

The LSM Workbench is an R/3-based tool that supports you when transferring data from non-SAP systems („Legacy Systems“) to R/3 once or periodically.

The tool supports conversion of data of the old system in a convenient way. The data can then be imported into the R/3 system via batch input, direct input, BAPIs or IDocs.

Furthermore, the LSM Workbench provides a recording function that allows to generate a „data mi-gration object“ in an entry or change transaction.

The main advantages of the LSM Workbench:• Part of R/3 and thus independent of individual platforms

• A variety of technical possibilities of data conversion:

• Data consistency due to standard import techniques:

 Batch input

 Direct input

 BAPIs (Business Application Programming Interfaces)

 IDocs (Intermediate Documents)

The import technique to be used in an individual case depends on the business object.

• Generation of the conversion program on the basis of defined rules

• Clear interactive process guide

• Interface for data in spreadsheet format

• Creation of data migration objects on the basis of recorded transactions

STEPS to Follow

1. Maintain Attributes:

Here you have to choose the second option and you can do the recording how this should work. Then assign the same to the Batch Input Recording name.

2. Maintain Source structure:

Create a structure name

3. Maintain Source field:

In this you have to create a structure same as that of the input file

e.g.: name

Age

Sex

4. Maintain structure relations:

This will link the structure to the input file.

5. Maintain field mapping and conversion rules:

Here is the place where you can do coding, depending upon the code you have written or assignment you have done the values will get picked up from the file and get processed.

6. Maintain field mapping and conversion rules:

If you have any fixed values you can define here.

7. Specify files:

Specify the input file path and type.

8. Assign files:

This will assign ur file to the Input file

9. Read Data:

This will read ur data from the file.

10. Display Read Data:

You can see the uploaded data

11. Convert Data

This will convert the data to the corresponding format for processing