Update temination error on coding user exit - EXIT_SAPLCOIH_009

[Former Member]

HI All,

I am working on approval of a work order in IW32 for which I am coding within a user exit EXIT_SAPLCOIH_009 which gets triggerred at the time of saving the work order. This will update the AUFK table and send a mail to a recipient. But when I save the work order after approving it, it gives me an error saying "Update Termination error". I checked within the SM13 transaction and ST22 for dump analysis, it says "The ABAP/4 Open SQL array insert results in duplicate database records.". Can anyone tell me what could have gone wrong and how I can rectify this. Your help is greatly appreciated.

Thanks in Advance

Edited by: Jeyakanthan A on Aug 4, 2011 11:53 AM

[Former Member]

HI All,

I am working on approval of a work order in IW32 for which I am coding within a user exit EXIT_SAPLCOIH_009 which gets triggerred at the time of saving the work order. This will update the AUFK table and send a mail to a recipient. But when I save the work order after approving it, it gives me an error saying "Update Termination error". I checked within the SM13 transaction and ST22 for dump analysis, it says "The ABAP/4 Open SQL array insert results in duplicate database records.". Can anyone tell me what could have gone wrong and how I can rectify this. Your help is greatly appreciated.

Thanks in Advance

Edited by: Jeyakanthan A on Aug 4, 2011 11:53 AM

[JL23]

do you manipulate key fields in the user exit?

[Former Member]

No I am not manipulating the key field (AUFNR). I have created a customised include within AUFK and I am only updating those fields.

[Former Member]

ABAP/4 Open SQL array insert results in duplicate database records.".

Error is due to inserting duplicate record in table which is already existing.Take help of abaper,debug,analyze

code which may be cause of error using ST22.If it is application error,apply appropriate sap note.

[Former Member]

In this exit, I am first updating a structure CAUFVD and then using this structure values, I am updating other similar structures and the table using PERFORM caufv_upd(saplcobh) USING caufvd_imp. I have not modified this perform. It already exists. Is this perform creating this error

[Former Member]

It is appropriate to move this thread from ERP MM to [Enhancements and Modifications |; for getting suitable responses.