LSMW

Former Member — Wed, 18 Jul 2007 11:14:38 GMT

Hi all,

Can we use LSMW for all transactions? if not please give me an example and explain?.And exactly when we can and cannot use LSMW? please explain ?

Regards

Re: LSMW

Former Member — Wed, 18 Jul 2007 11:16:33 GMT

SAP Data Migration with LSMW

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.

This is one of the very powerful tools available in SAP to upload large amount of data to the system. This tools is comparable to ecatt or scatt. But the advantage LSMW has over them is the amount of data processed in single session. Moreover LSMW is easer to learn and execute.

Through LSMW one can create Master data, create transactional data, modify existing master data etc. This tool is very useful when some mass changes are to be carried out and no standard SAP transactions are available for that. There are few standard objects available in LSMW e.g. material master, vendor master, customer master, purchasing info record, purchase requisitions, purchase orders etc. Using these standard objects one can do mass data upload and mass transactions. Apart from this LSMW provides another functionality of recording the transaction and then carrying that out many times with large data. eg for that can be mass deletion of purchase requisitions, mass deletion of planned orders etc.

For creating simple projects user can go to tcode LSMW and get started. All the steps are listed very nicely and system will not allow user to skip the steps enlisted. User will need to create Project, Subproject and Object.

Input to LSMW can be simple excel sheet or text tab delimited file(text file like note pad).

Example of a LSMW project in step wise manner is presented below:

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.

LSMW data migration for sales order VA01 / XD01 customer

LSMW using session method for data migration as follows

E.g. for XD01 (create customer)

initially there will be 20 steps but after processing 1 step it will reduced to 14 for session method.

1. T-Code: LSMW.

2. ENTER PROJECT NAME

Sub project name

Object name.

Execute.

3. MAINTAIN OBJECT ATTRIBUTES.

Execute

Select Batch Input recording

go to->recording overview

create

Recording name.

Enter transaction code.

Start recording

do recording as per your Requirement.

Save à Back.

Enter recording name in LSMW screen.

Save à Back

Now there will be 14 steps.

2. MAINTAIN SOURCE STRUCTURES.

Enter the name of internal table.

Display change

Create

Save à Back

3. MAINTAIN SOURCE FIELDS.

Display change

Select structure

Source_fieldsàCopy fields. (a dialogue window will pop out )

Select à From data file

Apply source fields

a. Enter No. of field's

b. Length of fields

c. Attach file

Save à Back.

4. MAINTAIN STRUCTURE RELATIONS

Display change

Save à Back.

5. MAINTAN FIELD MAPPING & CONVERSION RULE

Display change

Click on source field, select exact field from structure and Enter

***repeat these steps for all fields.

Save à Back.

6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED

Execute

Save à Back.

7. SPECIFY FILES.

Display change

Click on legacy data

Attach flat file

Give description

Select tabulators

Enter

Save à Back.

8. ASSIGN FILE

Execute

Display change

Save à Back.

9. IMPORT DATA.

Execute

Display change

Save à Back.

10. DISPLAY IMPORTED DATA

Enter ok ***it will show records only.

Back

11. CONVERT DATA

Execute

Display change

Save à Back.

12. DISPLAY CONVERTED DATA

Execute

Display change

Save à Back.

13. CREATE BATCH INPUT SESSION

Tick keep batch input folder

Back

14. RUN BATCH INPUT SESSION.

SM35 will come

Object name will be shown here

Select object & process

rewards point for helpful answer....

regards...

Abhay Singh.

Re: LSMW

Former Member — Wed, 18 Jul 2007 11:28:02 GMT

1.lsmw is basically for standard sap application.

BDC is basically for customized applications.

2. In lsmw mapping is take care by sap.

In bdc we have to give mapping concept explicitly.

3. LSMW offers different techniques for migrating data say : Direct input , Batch input recording , BAPI , IDOC.

BDC basically uses recording. There are two methods to implement BDC : (a) Call Trasaction Method

(b) Session Metohd.

4. LSMW is basically designed for Functional consultants who do no coding .

BDC is used by technical consultants , who do coding.

5.In LSMW , Coding cannot be done flexibily as BDC.

On the other hand in BDC ,Coding can be done flexibly to customize applications.

Check this thread out

https://www.sdn.sap.com/sdn/collaboration.sdn?contenttype=url&content=https%3A//forums.sdn.sap.com/thread.jspa%3FforumID%3D50%26threadID%3D49072%26messageID%3D501217%23501217

<b>Reward points</b>

Regards

Re: LSMW

Former Member — Wed, 18 Jul 2007 11:30:56 GMT

HI,

U CAN USE ALL THE TRANSACTIONS FOR LSMW AS THERE ARE 4 DIFFERENT METHODS USING WHICH ALL TRANSACTIONS ARE POSSIBLE TO BE USED.

THIS IS UPTO MY KNOWLEDGE.

REGARDS,

AMEET

Re: LSMW

Former Member — Wed, 18 Jul 2007 12:18:28 GMT

Please take a look at this link.

http://www.sapgenie.com/saptech/lsmw.htm

Hope this will help.

Regards,

topic Re: LSMW in Application Development and Automation Discussions

LSMW

Re: LSMW

Re: LSMW

Re: LSMW

Re: LSMW