LSMW

[Former Member]

Hi friends,

can any one give me the LSMW theoritical concept... just like definations.. and brief explination.. and whre exactly we are using this LSMW method..

regrads

babu

[Former Member]

For LSMW

http://help.sap.com/saphelp_nw04s/helpdata/en/87/f3ae74e68111d1b3ff006094b944c8/content.htm

http://www.sap-img.com/sap-data-migration.htm

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

http://allsaplinks.com/lsmw.html

http://myweb.dal.ca/hchinni/sap/lsmw_home.htm

regards,

srinivas

[Former Member]

Check the link........

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

It's very very useful and check all the tutorials in that..........

Regards,

Pavan

[Former Member]

Hi,

see this link

http://www.sap-img.com/sap-data-migration.htm

<b>reward if helpful</b>

rgds,

bharat.

[former_member189629]

check LSMW article in out http://allaboutsap.blogspot.com

[Former Member]

hi,

LSMW:

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 legacy system in a convenient way. .

Furthermore, the LSM Workbench provides a recording function that allows to generate a "data migration 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

• Charge-free for SAP customers and SAP partners

hope it helps .

rgds

[Former Member]

hi

<b>

What is Data migration?</b>

In an SAP R/3 implementation the data from legacy system (non SAP R/3) needs to be transferred to the SAP system

Periodic data transfer between R/3 and other system (interfacing) is also required

Both of the above form a part of data migration

<b>Significance of data migration</b>

Data migration comes in the end of R/3 implementation To start with Data Migration first configuration should be fully completed

Data migration is about 20% to 40% of the total implementation expenses

<b>Data migration tools</b>

The tools for data migration are:-

BDC (Batch Data Communication)

LSMW (Legacy System Migration Workbench)

<b>Difference between BDC & LSMW[/b

LSMW offers different technique for migrating data: Direct input, BAPI, Idoc, Batch input recording. While BDC basically uses batch input sessions and CALL TRANSACTION method.

Limit on number of records which can be uploaded in one session of BDC (999 records). No such limit in LSMW.

LSMW is more to do with configuration while BDC involves programming.

<b>What is LSMW?</b>

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

The data can be imported into the R/3 system via

- Batch Input

- Direct Input

- BAPI’s

- IDocs.

<b>

LSMW</b>

The LSM Workbench is a tool that supports data transfer from non-SAP systems to R/3. The main functions of the LSM Workbench are:

- Import data (legacy data in spreadsheet tables and/or sequential files)

- Convert data (from source format to target format)

- Import data (into the database of the R/3 application)

The LSM Workbench is a tool that supports data transfer from non-SAP systems to R/3. The main functions of the LSM Workbench are:

- Import data (legacy data in spreadsheet tables and/or sequential files)

- Convert data (from source format to target format)

- Import data (into the database of the R/3 application)

<b>Principles of LSM Workbench</b>

Basic Principles of LSM workbench:-

Most of the functions should reside in R/3. No collection of individual programs on different platforms.

The quality and consistence of the data imported into R/3 should be more important than speed and performance of data migration.

Existing knowledge and coding should be used.

The developed ”mapping" and rules should be reusable and thus be used repeatedly in projects.

<b>Features of LSMW</b>

Features:-

Integrated in R/3 and thus independent of individual platforms

The import technique to be used in an individual case, depends on the business object as well as on the availability of standard input programs

Data consistency due to standard import techniques:

Batch input

Direct input

BAPIs (Business Application Programming Interfaces)

IDocs (Intermediate Documents)

Structured way of working, because you have to finish every step before starting the next step

<b>Pre-requisites for LSMW</b>

Make sure that SAP customizing is finished.

Run the relevant transaction in the SAP system manually with test data from the legacy system and see which fields must be filled. There may be required fields that do not correspond to data fields in the legacy system. In such a case, one should better assign a fixed value or establish an optional field for data transfer.

Map the fields in advance in written form: Assign the source fields to the target fields.

Determine the form in which non-SAP data will be transferred into the SAP system (e.g. via "Move" or according to a rule).

<b>Import methods…</b>

Preferred methods of input are described in order of preference:

1)IDOC’s

Advantages: Fast to load, easy processing, low programming for standard IDOC’s

Disadvantages: Good knowledge of IDOC processing required, time consuming if changes have to be made to a created IDOC

2. BAPI’s

Advantages: Fast to load, easy processing, logical interface for functional/end user based on the business processes involved.

Disadvantages: Not always complete with all input fields of a transaction

3)Standard/Direct Input

Advantages: Well tested method, Fast to load, easy processing.

Disadvantages: No enjoy transactions, not always complete with all input fields of a transaction.

4. Batch Input

Advantages: Easy modifiable, all fields are available, easy re-processing.

Disadvantages: Comparatively slow, to use new screens or tabs a new recording has to be created, not easily usable for enjoy transactions, dependant on user settings, difference in foreground and background processing may occur.

<b>Getting Started</b>

Here is an example showing the way to use the conversion tool LSMW in SAP. It starts in the start-up screen of LSMW transaction and ends with a screen on which the results of the conversion are displayed

If you want to create or change objects, make sure that you are working in change mode. To activate this mode, click Change in the corresponding processing step. Only this mode provides all functions required for changing objects

Step 1 - Enter transaction LSMW

Enter the transaction code (LSMW) or add this transaction to your favourites (right-click with your mouse on the Favourites map in the start menu and choose Insert transaction, type lsmw and press enter), since LSMW is an additional transaction, it is not available in the standard SAP menu.

Step 2 – project, subproject, objects

At the initial screen, you can create a new project, corresponding subprojects and objects via Edit -> Create new entry. Alternatively you can select from an existing project

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.g. for every legacy system

Subproject: An ID with a maximum of 10 characters that is used as further structuring attribute

Object: An ID with a maximum of 10 characters to name the business object

- At the initial screen, ‘All Objects’ provides a list of all projects created already.

- ‘My Objects’ displays a list of all objects you created personally

- ‘All Project Objects’ displays all objects of the selected project as tree structure.

- ‘Project Documentation’ displays any documentation written for the individual pop-ups and processing steps. You can print the project documentation out, send it and save it in various file formats.

- Select ‘Documentation’ to enter your notes. After clicking, a popup is displayed in which you can write down your personal documentation.

<b>Initial Screen</b>

By clicking the button execute or pressing the F8 key on your keyboard you go to the object, you selected.

By clicking the button create a new object for the selected project and subproject with the name entered in the object field is created.

By positioning the cursor on an entry and clicking on the button documentation, you can add change or delete comments.

<b>Administration - list of existing projects</b>

In the initial screen, you can display the administration functions via the menu path Goto Administration. Here you can find a list of all existing projects.

It enables you to create, process, display, delete, copy or rename projects, subprojects, objects and reusable rules.

By double-clicking on an entry you can branch to the entry display.

Step 3 – Execute

Once the project and subproject along with the object are determined we execute to find the list of steps to be performed for data transfer

<b>Process steps</b>

The number of process steps is dynamic and shall depend on factors like input method

By clicking the ‘User menu’ button one can select – deselect the Process steps

To proceed through the processing steps one needs to start from the first one and execute each of them

A step can be skipped by selecting the next available processing steps’ radio button

<b>

Reward if useful</b>