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

LSMW

1. what about the LSMW

2. Where we can how many Posting periods

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Apr 13, 2008 at 09:00 AM

    Hello,

    LSMW is tool which is used to upload large amount of data or legacy into sap in the specified way.

    Through LSMW within short period we can upload the entire data.

    i am not understand ur problem related to posting periods.

    Regards,

    Sankar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 14, 2008 at 09:27 AM

    hi

    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

    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.

    You can have a look at the example of an upload data format for the Condition Pricing for Sales Order.

    LSMW Steps For Data Migration

    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

    nagesh

    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.