Skip to Content

LSMW Issue for migration of balances

Hi All

During LSMW process, while recording I have used around 25 fields with 'default all' option. They are all visible. However during third step 'Maintain Source Fields'---object overview--table I can see only 20 fields.

Pls advice why other fields are not visible in third step.

Regards

Pankaj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 02 at 07:55 PM

    In step one where you do the recording you actually define the target fields.

    In step three you define the source fields, how they are in your Excel template.

    There is nothing in step 3 which appears by itself, it is you who has to take care that all source fields from the template are defined in this step.

    And if only 20 fields are listed then you may have to scroll down to see the other fields or to get empty lines to add further fields.

    Add comment
    10|10000 characters needed characters exceeded

    • When you do a recording then you actually record one transaction, everything else would be a rather bad solution for a data migration. If you would record 3 postings then you could only process a source file which has a multiple of 3 records otherwise the last record would fail.

      Each line in a Excel file (saved as txt or csv) actually represent a single transaction in LSMW, in case you have a flat source structure.

      if you have 2 source files then you usually have a file with header records and another file with items which is subordinate to the header file. In this case a line in the header file represent a single transaction.

  • avatar image
    Former Member
    May 04 at 04:44 AM

    Dear Pankaj,

    In step first you need to record the fields and after recording make sure all your target fields are not repeating.

    then in step 3 you can provide the fields in structure by clicking on table maintenance icon ( in blue ) Enter fieldname, type and length for each field as shown:

    Such as:

    field name type length

    MATNR C 18

    MTART C 1

    May it helps.

    Add comment
    10|10000 characters needed characters exceeded