cancel
Showing results for 
Search instead for 
Did you mean: 

Error when Sending IDOC PORDCR103 with more than one record or multiple items in one purchase order

mohan_salla
Participant
0 Kudos
2,225

Hello experts,

I am trying to send idoc from DS to sap ecc.I am using standard idoc,i.e,,PORDCR103

My source data contained with purchase order details, some purchase order data is with multiple lines.

I can only send one record with one item successfully each time  but it's giving the following error when I send more than one record or one PO with multiple lines. please can anybody helps.

1580 10128 R3C-244005 18/04/2014 08:23:47 |Data flow DF_1305_PO_CREATE_IDOC_LATEST|Loader PORDCR103

1580 10128 R3C-244005 18/04/2014 08:23:47 IDoc target tried to generate IDoc <PORDCR103> from NRDM data: <

1580 10128 R3C-244005 18/04/2014 08:23:47 IDoc Error: Message:      Adding this segment exceeds maximum allowed number of repetition E1BPMEPOHEADER

1580 10128 R3C-244005 18/04/2014 08:23:47 IDoc Type:    PORDCR103

1580 10128 R3C-244005 18/04/2014 08:23:47 Release:      731

1580 10128 R3C-244005 18/04/2014 08:23:47 IDoc Number:

1580 10128 R3C-244005 18/04/2014 08:23:47 Segment Name: Not Applicable

1580 10128 R3C-244005 18/04/2014 08:23:47 Segment Type: E1BPMEPOHEADER

1580 10128 R3C-244005 18/04/2014 08:23:47 Field Name:   Not Applicable

1580 10128 R3C-244005 18/04/2014 08:23:47 >. Check your input data.


thank you.

regards

mohan

View Entire Topic
former_member200473
Contributor
0 Kudos

Hi Mohan,

After seeing this message from your error message:

"1580 10128 R3C-244005 18/04/2014 08:23:47 IDoc Error: Message:      Adding this segment exceeds maximum allowed number of repetition E1BPMEPOHEADER"

i feel that there is some issue either in data or in IDOC ( either the data has more no. of item records than the defined no. of segments or the IDOC has less no. of segment  than no. of item records.

If possible have a look in your data.

Regards,

Shiva Sahu

mohan_salla
Participant
0 Kudos

thank you shiva for your kind advise. But i can confirm that my input has only 4 records and I didn't delete any of that idoc segments. moreover I mentioned in my original post that I can send 1 record without any errors. Do we need to prepare input schema as same as idoc structure to aviod this errror.

please advise me.

Thank you

former_member200473
Contributor
0 Kudos

Hi Mohan,

answer for your question :"Do we need to prepare input schema as same as idoc structure to avoid this error."

Yes, you have to make same structure as IDOC, for example: if you have 4 segment and and each segment has 40 fields ( total = 4 *40) , you will be required to create structure and fields in same sequence.

Hope this clarifies you

Regards,

Shiva Sahu

mohan_salla
Participant
0 Kudos

thank you shiva. so I have to create a xml source file which is same as idoc structure and then map the source fields to target idoc in another dataflow ,right?

please advise me.

thank you

former_member200473
Contributor
0 Kudos

I am not sure ( why did you create xml source file).

As per my knowledge/information we do not need xml source to be created.

if you have table or file then also you can create structure.

For example:

Table -> Query Transform( to create Structure) -> Query Transform( to map the structure with IDOC fields ) -> IDOC .

Please let me know if i was clear to you.

But as you mentioned that you are able to load one record at a time ( one header with all the item records) i don't think that you have mapping issue.

Regards

Shiva Sahu

mohan_salla
Participant
0 Kudos

Hi Shiva,

Please find attached my DF screenshots and have a look whether I am doing correct mapping or not.

Thank you.

Mohan

former_member200473
Contributor
0 Kudos

Hi Mohan ,

After seeing screenshot no. 2 and 3 , i feel your structure is not correct ( and obviously mapping is also not correct) .

Example : as in screen shot you can see there are nested structure , you need to create same from BODS side , i mean to say that if there a structure "C" comes under "B" and "B" comes under "A" you will be required to create same structure ( name , data type and size must be same ) and what ever the fields are not required map them as "NULL".

Note : when i say same structure , it means same as IDOC structure , i know to create a structure is very tedious task  but no other go ( as per my knowledge).

Here in your idoc  Structure/segment E1BPMEPOHEADER comes under E1PORDCR1, it means same structure should be  on the input side/left side of query transform

Hope this clarifies you

mohan_salla
Participant
0 Kudos

I got you, thank you.Please have a look below. Is it correct now?

former_member200473
Contributor
0 Kudos

Hi Mohan,

It looks good/correct( as per the screenshot and mapping showed) to me and i expect this time it should load correctly and without any issues.

Kindly confirm if you got your data loaded and if not then please post error screenshot from The trace log and monitor log.

Regards,

Shiva Sahu

mohan_salla
Participant
0 Kudos

Hi Shiva,

I am still receiving same error message, please find attached screen shot and advise me. thanks

former_member200473
Contributor
0 Kudos

Hi Salla,

Last guess .

Have you done correcting mapping into "From" Clause of query transform and where clause( if there is any joining happening.

Regards,

Shiva Sahu

mohan_salla
Participant
0 Kudos

Thank you so much for your time.

Yes, I mapped correctly.see attached screen shots

former_member200473
Contributor
0 Kudos

I am finished with ideas .

Now i can say that either your data has some duplicate issue or at the ECC level there is some restriction . May be for your SAP , you need to consult with Admin and for data you need to verify by your own.

Shiva Sahu

mohan_salla
Participant
0 Kudos

Thank you so much for your efforts.

I will let you know if I resolve this issue.

regards

mohan

former_member200473
Contributor
0 Kudos

Hi Mohan,

I am not sure if you can export your atl and send that to me for my analysis.

I can try and put my efforts also parallel to your efforts.

Regards,

Shiva Sahu

mohan_salla
Participant
0 Kudos

Thank you shiva. please can you send me a blank email to mohsalla@gmail.com, so that  I will forward this job atl to you.

mohan_salla
Participant
0 Kudos

I have resolved this issue..

In Query FROM clause, I Swapped EDI_DC40 with TBL_13_5_PO_FINAL(sc2) and E1PORDCR1 with EDI_DC40(Row_Generation)-sc3

former_member200473
Contributor
0 Kudos

i am happy that you fixed the issue ,is it possible to send atl in my email id:

shv.sahu@yahoo.co.in

shiva sahu

former_member200473
Contributor
0 Kudos

Hi Mohan ,

May i request you to show me your row_generation transform screenshot, please ?

Regards,

Shiva Sahu

mohan_salla
Participant
0 Kudos

Sure,