topic Re: LSMW Multiple Files in Application Development and Automation Discussions

LSMW Multiple Files

Former Member — Thu, 18 Aug 2005 13:01:45 GMT

Hi All,

I have the records in the following pattern.

Key Record

REC_KEY1 CLASS1 CHAR1 CHAR_VALUE1

CHAR2 CHAR_VALUE2

CLASS2 CHAR3 CHAR_VALUE1

CHAR4 CHAR_VALUE4

REC_KEY2 CLASS3 CHAR1 CHAR_VALUE1

CLASS4 CHAR1 CHAR_VALUE1

REC_KEY3 SPACE SPACE

All these records are in a Single file. I have LSMW Structure as

KEY

--- CLASS

___ CHAR

is there any way i can split the Above file and keep KEY VAlUE in Both the files and populate the LSMW Recorrs ? I know the way to use record identifier. Trying to use the way with Multiple fiels, One for Header with Key Value and 2nd with CLASS and CAHR Values. Please Help !!

Thanks In Advace

Kalso

Re: LSMW Multiple Files

Vinod_Chandran — Thu, 18 Aug 2005 13:09:50 GMT

Hello,

If I understood your requirement correctly this is the solution.

Follow these steps for processing multiple records in lsmw.

I presume that you have one header line and multiple line items in the file and has a unique identifier. Let us say you have two nodes in lsmw called VBAK and VBAP.

Normally lsmw process one line of the file at a time. When lsmw reads the header line, process the VBAK node and use the 'transfer_record' command (this must be already there). When the second record is processed and if the unique identifier is same as the header then write a command called 'skip_record' in the '__BEGIN_OF_RECORD__' session of VBAK. If you do like this we will have one header and multiple line items.

Thanks

Vinod

Re: LSMW Multiple Files

Former Member — Thu, 18 Aug 2005 13:26:39 GMT

Thanks for Quick reply Vinod.

I have header record in One file and Item records in another file, with Key same ( Sales Order #) .

Do i have to still use identifier ? Do i have to write any code for this kind too ?

Re: LSMW Multiple Files

Vinod_Chandran — Thu, 18 Aug 2005 13:42:43 GMT

As far as I know you cannot have two source files at the same time. I think you need to merge both the files items after header, then use my logic.

Kindly assign points if the answers were helpful.

Re: LSMW Multiple Files

christian_wohlfahrt — Thu, 18 Aug 2005 14:50:45 GMT

Hi!

You can define two files in 'specify files'. In next step 'assign files' you can assign file1 to header structure and file2 to positions structure(s).

With your common key a 'loop where' should work.

Regards,

Christian

Re: LSMW Multiple Files

Former Member — Thu, 18 Aug 2005 15:47:16 GMT

Thanks Christian, You are right, the loop works automatically. I Figured out a way for the file structure. thanks for the help.

The first file is in the following format

KEY1 XXXX XXXXXXXXXX

KEY2 XXXX XXXXXXXXXXX

Second file

KEY1 CLASS1 CHAR1 CHAR_VALUE1

KEY1 CLASS2 CHAR2 CHAR_VALUE2

KEY2 CLASS3 CHAR1 CHAR_VALUE1

KEY2 CLASS2 CHAR2 CHAR_VALUE2

KEY3 CLASS3 CHAR1 CHAR_VALUE1

KEY4 CLASS2 CHAR2 CHAR_VALUE2

LSMW Looped Internally

Re: LSMW Multiple Files

Former Member — Mon, 04 Dec 2006 20:12:02 GMT

What version of SAP you have used ? Its not allowing me to use multiple files in ECC 6.0. If there is any other setting to be done, please do let me know.

Thanks

Ramgopal