Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Using LSMW to Import Legacy Data

Former Member
0 Kudos

Hi,

What are the steps required to move legacy data to SAP using LSMW?

Thanks,

Sreekar.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

LSMW is a tool used to tranfer data from legacy system to R/3 periodically or once.It supports conversion of data and Batch Input,BAPI,IDOC or Direct Input can be used as the method for transfer of data.Total of 26 processing steps are available in LSMW ,In case of data transfer using Batch Input only 14 steps are required.

Execute the transaction LSMW to start transfer of data,Before using the LSMW we should have good knowledge about the business object and the fields that will be transferred.

There are 14 steps that are normally used and these are :

1) Maintain Object Attributes.

2) Maintain Source Structures.

3) Maintain Source Fields.

4) Maintain Structure Relations

5) Maintain Field Mapping and conversion rules .

6) Maintain Fixed Values,translations ,user defined routines.

7) Specify Files .

😎 Assign Files .

9) Read DATA.

10) Display Read Data.

11) Convert Data.

12) Display Converted Data.

13) Create Batch Input Session.

14) Run Batch Input Sesion.

Check this Weblog.

/people/hema.rao/blog/2006/09/14/lsmw--step-by-step

Also check these links.

Regards,

Maha

3 REPLIES 3

Former Member
0 Kudos

Find below a Step by step Tutorial.

http://www.sapmaterial.com/lsmw.html

This shud give some idea for you

HTH

VB

Former Member
0 Kudos

LSMW is a tool used to tranfer data from legacy system to R/3 periodically or once.It supports conversion of data and Batch Input,BAPI,IDOC or Direct Input can be used as the method for transfer of data.Total of 26 processing steps are available in LSMW ,In case of data transfer using Batch Input only 14 steps are required.

Execute the transaction LSMW to start transfer of data,Before using the LSMW we should have good knowledge about the business object and the fields that will be transferred.

There are 14 steps that are normally used and these are :

1) Maintain Object Attributes.

2) Maintain Source Structures.

3) Maintain Source Fields.

4) Maintain Structure Relations

5) Maintain Field Mapping and conversion rules .

6) Maintain Fixed Values,translations ,user defined routines.

7) Specify Files .

😎 Assign Files .

9) Read DATA.

10) Display Read Data.

11) Convert Data.

12) Display Converted Data.

13) Create Batch Input Session.

14) Run Batch Input Sesion.

Check this Weblog.

/people/hema.rao/blog/2006/09/14/lsmw--step-by-step

Also check these links.

Regards,

Maha

Former Member
0 Kudos

Hi,

The LSM Workbench covers the following steps:

(1)Read the legacy data from one or several files (e.g. spreadsheet tables, sequential files)

(2)Convert the data from source format to target format

(3)Import the data using standard interfaces (Batch Input, Direct Input, BAPI, IDoc).

·Version 1.8.0 of the LSM Workbench (1.21mb) ("LSMW 1.8.0") is available

Attention : LSMW 1.8.0 requires an SAP R/3 system with SAP R/3 4.6.

Reward points if found helpfull..

Cheers,

Chandra Sekhar.