topic Re: LSMW & Internal Table in Application Development and Automation Discussions

LSMW & Internal Table

Former Member — Tue, 07 Jun 2011 08:35:06 GMT

All,

I using LSMW (RMDATIND) to load material masters. IM using GUI upload to read the data into an internal table. The data reads in fine. Prioblem I have is when i map the internal table to the fields within each of the segments i only get the first record. Im using 3 segments in the materia load,

the structure is as follows:

BMM00 Mat1

BMMH1 UOM1

BMMH7 TEXT 1

I''m not sure where i should put the loop or how to force it to the next record

thanks for any help

Re: LSMW & Internal Table

JL23 — Tue, 07 Jun 2011 09:16:20 GMT

 IM using GUI upload to read the data into an internal table

this does not really sound like you are using LSMW, as this step is not necessary at all as it is included in LSMW step 9 Read data.


Prioblem I have is when i map the internal table to the fields within each of the segments i only get the first record.

Mapping of fields is done in step 5. you first describe your internal table structure in step 2 and 3.

then you assign the structure to the target structure in step 4

and map field of internal structure to target structure in step 5.

Please describe your structure from step 2 and your mapping in step 4.

Re: LSMW & Internal Table

Former Member — Tue, 07 Jun 2011 09:26:52 GMT

hi jurgen

In this case im using the Function GUI upload to read the file into an interna table, The souce data file is selected when the convert data step is ran (via a parameter). I have mapped the structures to a dummy file that contains only 1 field. All of the data i need is in the Internal table now and my intention was to map directly from that internal table. As i mentioned this works but i am only getiing the first record. Alternatively i could create the source fields and map them to the fields but i still need to take the source data into an internal table to remove duplicates.

hope this makes sense?

thanks for your reply

Re: LSMW & Internal Table

JL23 — Tue, 07 Jun 2011 14:45:11 GMT

Even after this long explanation it still is a step that is not needed .

Please answer my questions, otherwise I cannot help you

Re: LSMW & Internal Table

JL23 — Tue, 07 Jun 2011 14:50:11 GMT

I have mapped the structures to a dummy file that contains only 1 field.

How many records are in the dummy file?

The souce data file is selected when the convert data step is ran (via a parameter).

The convert step is after the read step. how many records have you read in step READ DATA? and how many records do you see in DISPLAY READ DATA.

SAP runs the convert data step once for each record per structure level in the .READ file.

Re: LSMW & Internal Table

Former Member — Tue, 07 Jun 2011 17:51:21 GMT

Jürgen L. is correct the file does not need to be uploaded through GUI_UPLOAD as this is the primary function of the Read Data step.

You said you have 2 files one with records and the other with only 1 (to load the read), why would you not just read the main file with records and process the data within the LSMW? You can also have the LSMW read from multiple files in the Specify Files and Assign Files steps.

Re: LSMW & Internal Table

Former Member — Wed, 08 Jun 2011 09:29:38 GMT

gents

thank you for your responses,

FYI

I have managed to find a resolution to this by using the 'transfer_this_record' stamement. So at the end of the first segement I pass data that would ordinarly be mapped and transfered at the end of each segment. Using a Loop statement this then reads each record one by one.

cheers

Re: LSMW & Internal Table

former_member201275 — Thu, 09 Jun 2011 14:00:37 GMT

There are macros in LSMW you can use, I think you need 'skip_record'.