lsmw documentss

[Former Member]

hi experts,

can anyone send lsmw documents to my id mausam8@gmail.com

please no links

[Former Member]

Hi,

I have four excellent documents available at my website:

[http://kkrumi.googlepages.com/sap-abap]

Please make the effort to download them.

Also, award points if u feel it helped u.

Regards,

Khalid

[Former Member]

Hi,

Please refer to the link below :

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

Thanksm

Sriram Ponna.

[Former Member]

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

Different methods in LSMW

Mainly 4 methods in LSMW :

Standard Batch / Direct Input

Batch Input recording

BAPI

IDOC

Generally for most of the Master data, Standard Programs are available in SAP like for Material Master - RMDATIND, So, if such standard programs are available then in that case we are normally using Standard Batch / Direct input method. And if it's not available means if any custmized transaction if you are using then in that case we prefer Recording method....

Check this link for LSMW Steps For Data Migration

http://www.sap-img.com/general/lsmw-steps-for-data-migration.htm

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 link for Tutorials on LSMW

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

ALso check these links.

http://www.erpgenie.com/sapgenie/docs/IBIP_test_script.doc

http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

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

http://www.erpgenie.com/sap/saptech/lsmw.htm

[Former Member]

see this and do accordingly

http://esnips.com/doc/1cd73c19-4263-42a4-9d6f-ac5487b0ebcb/LSMW-with-Idocs.ppt

Go through the steps

Hi please go through the following steps for IDOC method

Step 1. Run the transaction ( /nlsmw ) you will reach to the screen

Here you have to specify

Project : 060_BUS_TRANS

Subproject : SERVICE_TICKET

Object : SRV_TICKET_ZSVT

click on the execute button .you will reach the screen :

The screen shows the 15 steps to Run the lsmw

Step 2) select the first step ( Maintain object attributes) and click the execute button.After clicking on the execute button you will reach at. the screen

Here you have to specify ( MEssage type and basic type)

click on the BACK button

Step 3) select the 2nd step ( Maintain source structures) and click the execute button

Here you have to specify the source structures.

Step 4) Select the 3rd step ( Maintain source fields) and click on the execute button :

Here you have to specify the fields present in the source structure

Step 5) select the 4th step ( Maintain structure relationship ) and click on the execute button :

Here you have to specify relationship between source and target structures

Step 6) select the 5th step ( Maintain field mapping ) and click on the exécute button :

Here you have to map the fields between source and target structure. Also you have to apply conversion rules here if any

STEP 7) select the 6th step and click on the exécute button

Here you can define any fixed value or user define routines

Step 😎 select the 7th step ( Specify files) and click on the exécute button :

At This screen we have to specify the files for This we should be in change mode .So please click on the button shown in the above screen. After clicking on This button you will be in change mode and will be able to specify the files :

Step 9) select the 8th step ( Assign files) and click on the exécute button

For assigning files yoy should be in change mode do the same thing click on the button as shown in the above screen :

Then assign the files to different structures.

Step 10 ) select the 9th step ( Read Data) and click on the exécute button :

After clicking on the exécute button you will reach to the screen

Again click on the exécute button . After clicking on the exécute button you will reach to the next screen

Here you will see data is read.

Step 11) select the 10th step ( Display read data) and click on the exécute button :

Here you can see your test data present in test files assign to source sturcture

Step 12 ) select the 11th step ( Convert data) and click on the exécute button :

After clicking on the exécute button you will reach to the screen

Click on the exécute button as shown on the : After click on the exécute button you will reach to the next screen

Data is converted

Step 12th ( Display converted data is same as Display read data )

Step 13 ) select the 13th step ( Start idoc generation) and click on the exécute

button :

At this step Idoc is generated using converted data

Step 14) select the 14th step ( Start idoc processing ) and click on the exécute button :

After clicking on the exécute button you will reach to the screen :

And then click on the exécute button : After clicking on the exécute button you will reach to the final processive screen

If data is processed correctly you will see ( 53 Status message with green sign)

Check the following link:

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

http://www.sapbrain.com/TOOLS/LSMW/SAP_LSMW_steps_introduction.html

http://esnips.com/doc/8e732760-5548-44cc-a0bb-5982c9424f17/lsmw_sp.ppt

http://esnips.com/doc/f55fef40-fb82-4e89-9000-88316699c323/Data-Transfer-Using-LSMW.zip

http://esnips.com/doc/1cd73c19-4263-42a4-9d6f-ac5487b0ebcb/LSMW-with-Idocs.ppt

http://esnips.com/doc/ef04c89f-f3a2-473c-beee-6db5bb3dbb0e/LSMW-with-BAPI.ppt

http://esnips.com/doc/7582d072-6663-4388-803b-4b2b94d7f85e/LSMW.pdf

for Long texts Upload

Please take a look at this..

http://help.sap.com/saphelp_erp2005/helpdata/en/e1/c6d30210e6cf4eac7b054a73f8fb1d/frameset.htm

LSMW with TABLE CONTROL

Refer the links -

just refer to the link below

http://www.sapmaterial.com/?gclid=CN322K28t4sCFQ-WbgodSGbK2g

Reward points if useful.

[Former Member]

Step-by-Step Guide for using BAPI in LSMW

Note! The screen prints in this article are from ECC 5.0. They may differ slightly in other versions.

Introduction:

This document details the usage of BAPI in LSMW. We have used the example of migration of the purchase order data into SAP.

Pre-requisites:

It is assumed that the reader of this article has the minimum knowledge required on the Business Object, BAPI, Message Types and IDoc Types.

Step-by-Step Procedure:

Details of the BAPI used in this scenario:

Business Object: BUS2012

Method: CreateFromData

Details of Message Type and Basic IDoc Type:

Message Type: PORDCR

Basic IDoc Type: PORDCR02

Let’s have a look at the BAPI first, before proceeding to the LSMW:

1. Go to Transaction BAPI

2. Click on Search Button

3. Enter the value “BUS2012” and select “Obj.type(Technical Object Name”

4. Press ENTER

5. Following screen appears:

6. On the left side of the screen, Expand the “PurchaseOrder”.

7. Select “PurchaseOrder” and double-click on the same for details.

Building LSMW using BAPI:

1. Go to Transaction LSMW.

2. Enter the Project, Subproject and Object information and click on CREATE.

3. Enter the descriptions for Project, Subproject and Object.

4. Now select Settings à IDoc Inbound Processing

5. “IDoc Inbound Processing” screen appears. Enter the required details as shown below:

6. Click on “Activate IDoc Inbound Processing”.

7. Click on “Yes” when prompted for “Activate IDoc Inbound?”

8. Hit on “Back” to return to the main screen.

9. Click on Continue (F8). Following Screen appears:

10. Select the Step 1 “Maintain Object Attributes” and select “Execute”.

11. Select the radio button “Business Object Method” and enter the following details:

Business Object: BUS2012

Method: CreateFromData

Hit ENTER

12. Save and click on BACK button. Following information message is displayed.

13. Now select step 2 “Maintain Source Structures” and click “Execute”.

14. In this step, we need to maintain the source structure. In our example, lets consider the example of a file with 2 structures Head and Item data as shown below:

Click on Create and name the source structure as HEADERDATA. Now select HEADERDATA and click on “Create” again to create the child structure. Following popup appears:

Select “Lower Level” and click on Continue. Enter the Item data structure name.

Click Save and hit BACK button to go to the main screen.

15. Select step 3 “Maintain Source Fields” and hit execute.

16. Enter the fields as shown below:

17. Click SAVE and return to main screen.

18. Select step 4 “Maintain Structure Relations” and click Execute.

Select E1PORDCR and click on CREATE RelationShip. Following screen appears:

Select HEADERDATA and hit ENTER

Similarly do the same for the structure E1BPEKKOA, E1BPEKPOC and E1BPPEKET.

Click Save and return to main screen.

19. Select the step “Maintain Field Mapping and Conversion Rules” and click on execute. Maintain the Field Mapping as seen below:

20. Select step 7 “Maintain Source Files” and provide the link for the test file created. (Create a test file with the same structure as defined earlier).

Save and return to main screen.

21. Select the step “Assign Files” and click on Execute.

Assign the file provided to the source structure. Here the same file is provided for both the structures.

Save and return to the main screen.

22. Select the step “Read Data” and click on Execute.

Click on Execute.

Return to the main screen.

23. Select the step “Display read data” and click on execute.

Click on the structure name to get the field level values.

24. Return to main screen and now select “Convert Data”.

25. Return to the main screen and select “Display Converted data”.

26. Return to main screen and select “Start IDoc generation”.

27. Now select the step “Start IDoc Processing” on the main screen.

28. Return to main screen and click on “Create IDoc overview”. Here the data record and status records of the IDoc could be viewed

It is given in screen shot.

http://www.saptechnical.com

Reward Points if useful