Skip to Content
0

Loading more than one record into Idoc error ?

Jan 06, 2017 at 09:41 AM

74

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi krishna,

Thanks for suggestion.

I tried above process getting same error,.

Query map,

EDI_Mapping,

E1KNA1M,

Thanks

sekhar

edi-map.jpg (58.1 kB)
query-mapping.jpg (40.2 kB)
e1kna1m.jpg (58.0 kB)
0
avatar image
Former Member Jan 09, 2017 at 07:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded