Loading more than one record into Idoc error ?

[chandrasekhar6]

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

[former_member254877]

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...

[Former Member]

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---

[chandrasekhar6]

Hi krishna,

Thanks for suggestion.

I tried above process getting same error,.

Query map,

EDI_Mapping,

E1KNA1M,

Thanks

sekhar