Skip to Content

Loading more than one record into Idoc error ?

Hi

Data loading from excel file to ERP System using Idoc in SAP Data services.

Dataflow as shown below,

Customer master Source data as shown below,

IDOC_Mapping query mappings,

Mapping customer data fields as shown below,

Idoc properties,

1. When I execute with single record execute successfully in SAP Data services, but check Idoc status it shows Status 51 warning

2. When I execute with more than 1 record it shows the following error,

Please share valuable inputs,

Thanks

sekhar

We are loading more than 1 record it shows the following error

source-data.jpg (35.9 kB)
df.jpg (22.4 kB)
edi-map1.jpg (64.1 kB)
edi-map2.jpg (48.3 kB)
map-eka1.jpg (35.8 kB)
idoc.jpg (27.9 kB)
er.jpg (99.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 08, 2017 at 12:27 AM

    I think you're not populating the NRDM structures in the proper way. check the "from" tab in query for E1KNA1- Idoc Mapping.

    Make sure query from - KNA1

    and KNA1 and EDI_DC40 should be like this---

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 07:27 PM

    Hi Chandra -

    your E1KNA1M segment should point to Row Generation transform, because it allows only one repetition.

    Inside E1KNA1M segment you have other segment called E1KNA1H - that you should point to your Excel source ( because it will also multiple iterations..)

    pls try this and let me know...

    Add comment
    10|10000 characters needed characters exceeded