LSMW for routing with standard batch input

[Former Member]

Hello All,

I am trying to prepare one LSMW for routing upload for PP module. Routing data contains header data, operation data and master inspection characteristics data.

I have created three source structures viz. material- task list header, task header data, operation and inspection.

Header has been assigned to target structure BIMPL- Batch Input Structure for Allocation of Mat. to Task Lists,

Task header data source structure has been assigned to BIPKO- Batch Input Structure for Task List Header,

Operation source structure has been assigned to target structure BIPPO- Batch input structure for task list operation,

and inspection source structure has been assigned to BIPMK- Inspection characteristics for batch input of task lists.

Every source structure has been identified with an identifier value of which have been set as H, I,J,K for all source structures resp.

The excel file has been prepared as follows,

H MATNR WERKS PLNNR PLNAL

H 100045 1000 50000043 1

H 100045 1000 50000043 2

I MATNR WERKS PLNNR PLNAL VALID_FROM USAGE STATUS

I 100045 1000 50000043 1 01012000 1 1

I 100045 1000 50000043 2 01012000 1 1

I have mentioned here the combination of first two structures only. But it contains data of other two source structures as well (for identifier J & K).

The data from the excel is copied to the flat file and same is specified in LSMW in the step 'Specify file'.

In 'Assign file' step the flat file is assigned to all the four source structure.

Now at the time of reading data system is throwing me an error as 'Ensure field sequence is correct for data for mutiple source structures' Message no. /SAPDMC/LSMW_OBJ_060026

How to overcome this?

<removed by moderator> answers will be greatly appreciated........

Mimiri

Edited by: Thomas Zloch on Jul 11, 2011 10:16 AM

[Former Member]

Hello ,

have you maintained this check box for the key fields"

LSMW>Maintain Source fields>double click on fieds : MATNR WERKS PLNNR PLNAL

Selection Parameter for "Import/Convert Data"-->Tick this check box

regards

[Former Member]

Hi Prabhu,

I don't have that option in the details of source field.

All the fields are characteristics only. I have come across several PPTs in which I could see an option of import/ convert data but in my case it's not there.

<signs of impatience removed by moderator>

Mimiri

Edited by: Thomas Zloch on Jul 11, 2011 10:17 AM

[Shwetha58shetty]

I have uploaded the same with 2 structures. Group them by header and Line items. create header structure first. when you create second structure (for item) choose lower level radio button. use 2 flat files for upload. assign the one relavant to header to the header structure and the file with item details to item structure.

This will work.

Regards,

Shwetha

[Former Member]

Shwetha,

Thanks for the info.

But how to specify two separate files for two structures. In 'specify files' step we have only one option to select the file.

Coyuld you please answer this?

I have also come across several threads wherein they have used only one file to upload. How to map this too.

Mimiri

[Former Member]

Hello All,

I am still awaiting your valuable answers.

Mimiri

[Former Member]

Hello All,

I amanged to solve this. In specify file step I unmarked the 'Field name in the beginning' . Now I am able to read and convert the data properly.

Mimiri