on 01-28-2014 9:52 AM
Hi All,
We are trying to CIF material from APO to ECC gives below error:
"The ABAP/4 Open SQL array insert results in duplicate database records."
Error only comes if we use RIMODINI to CIF material that too for only specific materiel.
Using CFM2 it doesn't give any error.
Read in SDN table "Additionally material entry needs to be removed from /SAPAPO/MATEXEC" - but no idea how can I find this materiel in this table as on contains id as section and I cant get the APO id of this materiel.
Thanks
Regards,
Amlan C
Hello Amlan,
First of all, RIMODINI will CIF the products from ECC to APO, but not from APO to ECC. So, your statements are slightly contradicting with each other in the question that you have posted.
Assuming that the problem is in APO, ( Inbound queues in APO ) the SYSFAIL error is occuring with an error saying "Duplicate records". Did you try to search for any OSS notes that handles this issue ?
Coming to the other question about MATEXEC DB table, the GUID for the material can be found from another table /SAPAPO/MATKEY. Try to check this and see if it helps.
Hope I have been of some help to you in giving some direction
Babu Kilari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Babu,
Thanks for the reply, yes my mistake material transfer from E.C.C to APO.
The materiel is still not in APO; using table /SAPAPO/MATKEY in APO says the product doesn't exit thus i cant get the GUI id to be further used in table /SAPAPO/MATEXEC.
Could find SAP oss msg "1052014 - Product: Inconsistent entries in /SAPAPO/MATEXEC" but this is not applicable to APO 7.0 only till 5.0
Thanks
Regards,
Amlan C
Hi Amlan,
I am sorry, without looking at the system it is difficult. But, my approach in this case would be
1) Check if there is any user exit in APO Inbound which is creating some duplicate records
2) See the ST22 details in APO and read the short dump information to see if it can give any clue.
3) Try to correct all the inconsistencies using the transaction code /SAPAPO/OM17.
4) Raise an OSS message, seek SAP's help to analyse this.
Hope this helps.
Babu Kilari
Hi Amlan,
If you are using material variant Cross-plant variant may this error occurred, Short dump occurs due to multiple entries in IBINOWN table (in R/3 system) with the same OBJKEY. i.e There exists multiple entries in IBINOWN table for the same material variant (in same plant)
Please refer the OSS notes,
887114 - Transfer of material fails with error ITAB_DUPLICATE_KEY.
1507098 - ITAB_DUPLICATE_KEY when integrating material variants
Regards,
R.Brahmankar
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.