<Use Correct Subject line>

[Former Member]

Dear Gurus,

I will be facing an interview in the next two days concerning a Roll out Project over 13 countries. The point is like i've never worked neither in a Rolle Out project nor with a migration Tool. I scare a little bit.

- Could anyone tell me how things are going on in such cases?

- Imagine they ask me how far is my know How concerning Data Migration?

-Where have u work for the 1st time in a migration Project what was ur Duty?

-What r the Migration tools used by SAP except LSMW ?

- In SD/CRM point of view how Migration can be processed or carried out?

Thanks in advance will be good rewarded.

[Lakshmipathi]

Hi Yves

Irrespective of problems, everybody in this forum will try to answer. Hence, my humble request is that dont type like the above henceforth.

Thanks

G. Lakshmipathi

[Former Member]

Laksmipathi, if you don't have anything useful to add, just don't answer. It's a moderators job to correct a post, not yours! Unless it's your forum and we didn't realise it.

[Former Member]

Hi,

Please <b>read the rules of engagement</b> before posting.

Step 2: Asking Your Question

Once you have verified that no resources are available for solving your problem, ask your question. Do the following:

- Use a Good Subject Line

The subject header is your golden opportunity to attract qualified experts' attention in around 50 characters or less. Don't waste it on babble like "Workflow question". We all have busy jobs, often we just skim through the list headings and read those that interest us. Also, DO NOT reply to an unrelated post to ask a different question. This confuses those reading the thread and may lose people that would be interested in your question. Always start a new topic with a new mail.

Bad subject: Urgent problem with workflow

Good subject: Error after transport: "Inconsistent workflow definition"

Do not use words in capital letters and any of the words: urgent, quickly, burning, etc in your message. Especially not in the title! This just irritates and does not help you get to your goal. From our side, we definitely do not answer faster when we see these words.

The same goes for such things as ??? or !!! in appends. In the English language one ? or ! is sufficient to terminate a sentence.

[Former Member]

Hi Michail,

Please understand that this is community forum.

If forum members can help make it better that is good.

It is not always possible for moderators to monitor the forums 24* 7.

Apart from helping with questions if members can enforce a sense of discipline in the forum that is good for the forum.

This can be done by all the members and is not restricted to moderators or forum owners.

Thank you.

[Former Member]

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.

How to develop a lsmw for data migration for va01 or xk01 transaction?

You can create lsmw for data migration as follows (using session method):

Example for xk01 (create vendor)

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

1. TCode : LSMW.

2. Enter Project name, sub project name and object name.

    Execute.

3. Maintain object attributes.

    Execute

    select Batch Input recording 

    goto->Recording overview

    create

    recording name.

    enter transaction code.

    start recording

    do recording as per ur choice.

    save + back.

    enter recording name in lsmw screen.

    save + back

Now there will be 14 steps.

2. MAINTAIN SOURCE STRUCTURES.

    Here you have  to 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 come .

    select -> from data file

    apply source fields

    enter No. of fields 

    length of fields

    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 structue 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

    attah flat file

    give description

    select tabulatore 

    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 willl 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 

      F8

      back

14. RUN BATCH INPUT SESSION.

      sm35 will come

      Object name will be shown here 

      select object & process     

Thank you,

Deepika