Skip to Content
author's profile photo Former Member
Former Member

LSMW

pls can any one explain about LSMW? and its process steps?

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2007 at 01:28 PM

    Hi Lokanadh,

    Tcode:LSMW

    1.Create Project Name,Sub project and Object.And Execute

    2. Click on User Menu for Select which fields you want.

    For Functional view:

    Maintain Object Attributes

    Maintain Source Structures

    Maintain Source Fields

    Maintain Structure Relations

    Maintain Field Mapping and Conversion Rules

    Specify Files

    Assign Files

    Read Data

    Display Read Data

    Read Data

    Display Read Data

    Create Batch Input Session

    Run Batch Input Session

    3.Select Maintain Object Attributes and execute

    select batch input method maintain recording click on recoding:overveiw icon

    click on new enteries.

    4.Follow the steps of feilds

    Reward points if its needful.

    Regards

    Vikram.M

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2007 at 01:08 PM

    Hi lokanadh

    The LSM Workbench is an SAP R/3 based tool that supports the one-time or periodic transfer of data from non-SAP systems ("legacy systems") to SAP systems.

    The LSM Workbench helps you to organize your data migration project and guides you through the process by using a clear sequence of steps.

    The most common conversion rules are predefined. Reusable conversion rules assure consistent data conversion for different data objects.

    <b>**Rewards points if helps**</b>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2007 at 01:13 PM

    Hi Lokanadh,

    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 .

    8) 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.

    <b>**PLEASE REWARD POINTS IF THIS HELPS**</b>

    Regards

    AK

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2007 at 01:14 PM

    Hi,

    There is a good blog on LSMW inputs ..

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

    Also for more info refer the below SAP HELP link where all abt LSMW is listed.

    http://help.sap.com/saphelp_nw2004s/helpdata/en/7a/5e3d38faba11d1b40f006094b944c8/frameset.htm

    With few other inputs,

    Direct Input --> This is used when we use the standard SAP programmes for Upload. It updates the related tables directly.

    Batch Input REcording --> By means of standard batch input programm...and its more eventful..and can be vouched for in case of any errors.

    some Adv :

    The LSMW supports a one-time transfer of data (initial data load) and also offers a restricted support of permanent interfaces. Thus, a periodic transfer of data is possible.

    Some negatives:

    The LSMW, however, does not include any functions for monitoring of permanent interfaces.The tool does not support any data export interfaces (outbound interfaces).

    Reward points if helpful

    Regards,

    Amrish Purohit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2007 at 01:21 PM

    Hi Loknadh,

    Pl. check this link :

    LSMWhttp://www.sap-img.com/sap-data-migration.htm">LSMW>

    Pl. reward if it helps.

    Thanks & Regards

    Sadhu Kishore

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2007 at 01:50 PM

    HI Lokanadh,

    Send me your mail ID.

    Regards

    Srini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2007 at 04:11 AM

    Hi,

    LSMW Steps for Data Migration

    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

    go to->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 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 tabulator

    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

    F8

    back

    14. RUN BATCH INPUT SESSION.

    SM35 will come

    Object name will be shown here

    select object & process

    With regards

    Rajesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 08:10 AM

    ok

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 29, 2011 at 08:24 AM

    This thread is displayed on top of the forum for the members like you.

    [Read This Before Closing your Threads |;

    Please go through that and as indicated therein, please avoid adding any text to your old threads due to which, those are coming on top of the forum which is unnecessary.

    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.