Skip to Content
avatar image
Former Member

LSMW for routing with standard batch input

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 11, 2011 at 07:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Jul 11, 2011 at 02:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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