Skip to Content

Import material short text with LSMW (RMDATIND)

Hi community,

I´m trying to import material data inclusive material short texts with LSMW (RMDATIND -> Direct Input). In the step "Read Data" the materials short text is not written.


Therefore I did following steps:
- The source structure has two steps. The second structure is subordinated to the first.
- All material master source fields are defined in the sequence of the excel template.
- BGR00, BMM00, BMMH1 are assigned to the first source structure. BMMH5 is assigned to the second source structure.
- The fieldmapping is created with the rule "Transfer (MOVE)". In BMMH5 I´ve defined constants for "SPRAS" -> D and "SPRAS_ISO" -> DE. MAKTX has the rule "Transfer (MOVE)".
- The data upload comes from the PC-Frontend. The configuration setting is: File contents -> Table, Separators -> Tablulator, File Structure -> both flags are marked, File Type -> Record End Marker (Text File), CodePage -> ASCII.
- Imprted Data: has the path with the ending "lsmw.read".
- Converted Data: has the path with the ending "LSMW.CONV".
- The two upload filepaths are assigned to both source structures.

As in the step "Read Data" the material text is not written, I´ve to change the configuration above. What setting is missing?

Regards
Christoph

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    Apr 26 at 06:45 AM

    LSMW "read data" step need identifier for know your data is first structure or second structure. Did you used "identifier" in "Maintain Source Fields" for determine first and second structure? Your data also must have identifier too.

    Add comment
    10|10000 characters needed characters exceeded

  • May 17 at 05:58 PM

    Hi all again,

    I solved the problem. With this blog article Blog long text transfer I managed to read the short and long text plus material master data. First of all I created a flat file with all data. Every line is marked with an identifier. This identifying field content has also to be defined in the source structure fields. In the step "Specify Files" the button "Data for Muliple Source Structures (Seq. File)" has to be marked. After that the steps "Read Data" and "Convert Data" was without difficulty possible.

    Regards

    Christoph

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26 at 03:12 PM

    Hello Andy,

    thank you to your answer. I don´t use an identifier in "Maintain Source Fields" and in my data. What data type is this identifier? One digit -> a character field ? Do I need an assignment in the field mapping? Because I need a link from the source to the predefined master data structure ?

    Thanks in advance and regards

    Christoph

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26 at 05:32 PM

    Hi,

    MAKTX is in structure BMMH1 (Transfer of Main Data), not BMMH5. You need to do the field mapping for this field and try again.

    Regards,

    Prasoon


    lsmw-mm01.jpg (110.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27 at 10:52 AM

    Hi,

    for the first material short text your answer is correct. I´ve all in all eight material short texts with different country codes for one material to migrate. So I need BMMH5. Does anyone have more informations with the identifier from the first answer?

    Regards

    Christoph

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27 at 12:18 PM

    Hi,

    In that case, please check the little coding explained in the doc: LSMW Long text load by Direct Input method, in section: '__END_OF_RECORD__ ' which provides the option on loading multiple texts at the same time.

    Regards,

    Prasoon

    Add comment
    10|10000 characters needed characters exceeded