Skip to Content
avatar image
Former Member

LSMW Data Migration

Hello Gurus

Can anyone tell me if it's possible to perfectly migrate the complete document flow from sales to accounting for documents that have already been billed?

That is, we want to load a new system with existing data from an older SAP version. Can we load old sales orders, along with the old billing and accounting documents, and keep all of the dates as they are {in the past}? How would you replicate a sales order that contains a reference to a billing document, if the billing document doesn't yet exist?

Can anyone provide any insight as to how I might do this? The SLO group is not an option {too expensive}.

I've been experimenting with the LSMW, which will work well for master data. I'm struggling with how to proceed with transaction data.

Any insight appreciated,

Lee

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 18, 2006 at 05:42 AM

    Hi lee,

    i think serialization of message types will help you in this regard.place the message types in the sequence in the manner you want to create sales order then delivery then billing and so on. i think this will help you.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2006 at 04:33 PM

    Hi Lee,

    This would be my approach.

    All important documents like orders, deliveries, invoices etc. are linked to SAP standard idoc types(intermediate documents) and message types. SAP also provides inbound and outbound programs to import and export the same for every version of SAP.

    Versions of idoc types are compatible and it is possible to work with older versions of idoc types in newer systems.

    So the steps that would be help is

    1: Export all documents in current version into idocs.

    2: Import these into newer version via idocs.

    Not much coding is required in this approach as programs on both the inbound and outbound are provided by SAP.

    Regards,

    Anand.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2006 at 05:47 AM

    Hai Lee

    I will send you How to Upload Material Data through LSMW Direct Input Method

    You Just Follow the steps as given Bellow

    Using Tcode MM01 -- Maintain the source fields are

    1) mara-amtnr char(18)

    2) mara-mbrsh char(1)

    3) mara-mtart char(4)

    4) makt-maktx char(40)

    5) mara-meins char(3)

    the flate file format is like this as follows

    MAT991,C,COUP,Srinivas material01,Kg

    MAT992,C,COUP,Srinivas material02,Kg

    AMT993,C,COUP,Srinivas material03,Kg

    MAT994,C,COUP,Srinivas material04,Kg

    MAT995,C,COUP,Srinivas material05,Kg

    goto Tcode LSMW

    give Project Name

    Subproject Name

    object Name

    Press Enter -


    Press Execute Button

    It gives 13 radio-Button Options

    do the following 13 steps as follows

    1) select radio-Button 1 and execute

    Maintain Object Attributes

    select Standard Batch/Direct Input

    give Object -- 0020

    Method -- 0000

    save & Come Back

    2) select radio-Button 2 and execute

    Maintain Source Structures

    select the source structure and got to click on create button

    give source structure name & Description

    save & Come Back

    3) select radio-Button 3 and execute

    Maintain Source Fields

    select the source structure and click on create button

    give

    first field

    field name matnr

    Field Label material Number

    Field Length 18

    Field Type C

    Second field

    field name mbrsh

    Field Label Industrial Sector

    Field Length 1

    Field Type C

    Third field

    field name mtart

    Field Label material type

    Field Length 4

    Field Type C

    fourth field

    field name maktx

    Field Label material description

    Field Length 40

    Field Type C

    fifth field

    field name meins

    Field Label base unit of measurement

    Field Length 3

    Field Type C

    save & come back

    4) select radio-Button 4 and execute

    Maintain Structure Relations

    go to blue lines

    select first blue line and click on create relationship button

    select Second blue line and click on create relationship button

    select Third blue line and click on create relationship button

    save & come back

    5) select radio-Button 5 and execute

    Maintain Field Mapping and Conversion Rules

    Select the Tcode and click on Rule button there you will select constant

    and press continue button

    give Transaction Code : MM01 and press Enter

    after that

    1) select MATNR field click on Source filed(this is the field mapping) select MATNR and press Enter

    2) select MBRSH field click on Source filed(this is the field mapping) select MBRSH and press Enter

    3) select MTART field click on Source filed(this is the field mapping) select MTART and press Enter

    4) select MAKTX field click on Source filed(this is the field mapping) select MAKTX and press Enter

    5) select MEINS field click on Source filed(this is the field mapping) select MEINS and press Enter

    finally

    save & come back

    6) select radio-Button 6 and execute

    Maintain Fixed Values, Translations, User-Defined Routines

    Create FIXED VALUE Name & Description as MM01

    Create Translations Name & Description as MM01

    Create User-Defined Routines Name & Description as MM01

    after that delete all the above three just created in the 6th step

    FIXED VALUE --MM01

    Translations --MM01

    User-Defined Routines --MM01

    come back

    7) select radio-Button 7 and execute

    Specify Files

    select On the PC (Frontend) -- and click on Create button(f5)

    give the path of the file like "c:\material_data.txt"

    description : -


    separators as select comma radiao- button

    and press enter save & come back

    8) select radio-Button 8 and execute

    Assign Files

    Save & come back

    9) select radio-Button 9 and execute

    Read Files

    Execute

    come back

    come back

    10) select radio-Button 10 and execute

    Display Imported Data

    Execute and press enter

    come back

    Come back

    11) select radio-Button 11 and execute

    Convert Data

    Execute

    come back

    Come back

    12) select radio-Button 12 and execute

    Display Converted Data

    Execute & come back

    13) select radio-Button 13 and execute

    Start Direct Input Program

    select the Program

    select continue button

    go with via physical file

    give the lock mode as 'E'

    and execute

    Thanks & regards

    Sreenivasulu P

    Add comment
    10|10000 characters needed characters exceeded