'SAPSQL_ARRAY_INSERT_DUPREC' error while cancellation of credit memo.

[Former Member]

Hi,

I'am cancelling a credit memo created through 'Sales Return'.When I save the document it gives the message that billing document is created, but just after sometime it shows 'Error info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC. I've checked SAP notes:208627,154638 and 6080 regarding the mentioned error.

System behaves normally when I cancel an ordinary billing document(cancellation type S1) but when I cancel credit memo (Billing Cancellation type S2) it shows error.Part of the short dump is:

The termination occurred in the ABAP program "SAPLV60U" in "KONV_BEARBEITEN".

The main program was "RSM13000 ".

The termination occurred in line 28 of the source code of the (Include)

program "LV60UF0K"

of the source code of program "LV60UF0K" (when calling the editor 280).

The program "SAPLV60U" was started in the update system.

Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in

the

procedure "KONV_BEARBEITEN" "(FORM)" but was not handled locally, not declared

in the

RAISING clause of the procedure.

The procedure is in the program "SAPLV60U ". Its source code starts in line 11

of the (Include) program "LV60UF0K ".

Source code extract

000010 ***********************************************************************

000020 * Unterroutinen RV-Fakturierung *

000030 * *

000040 * KONV_BEARBEITEN *

000050 ***********************************************************************

000060

000070

000080 * *

000090 * FORM KONV_BEARBEITEN *

000100 * *

000110 FORM KONV_BEARBEITEN.

000120

000130 CHECK: OHNE_KONV = SPACE.

000140 XVBRK_TABIX = 0.

000150 LOOP AT XVBRK WHERE UPDKZ NE UPDKZ_NEW.

000160 DELETE FROM KONV WHERE KNUMV = XVBRK-KNUMV.

000170 ENDLOOP.

000180

000190 LOOP AT XKOMV.

000200 KONV = XKOMV.

000210 BELEG = XKOMV-KNUMV.

000220 IF BELEG-ID = '$'.

000230 PERFORM VBRK_BELEGNUMMER_ERMITTELN.

000240 XKOMV-KNUMV = XVBRK-KNUMV.

000250 ENDIF.

000260 MODIFY XKOMV.

000270 ENDLOOP.

> INSERT KONV FROM TABLE XKOMV.

000290 IF SY-SUBRC NE 0.

000300 MESSAGE A100 WITH 'KONV' SY-SUBRC XKOMV-knumv.

000310 ENDIF.

000320

000330 ENDFORM.

000340 *eject

Please help.

Thanks with Regards.

Manoj

[Former Member]

Hi,

I got the solution.

Hence the thread is closed.

Regards.

Manoj.

[Lakshmipathi]

It could have been better had you updated the forum as to how your issues is solved.

[former_member906139]

Hello Manoj,

Could you please let us know how the issue has been resolved?

Regards,

Abhay

[Former Member]

HI,

We have the same problem , can you please give me an update relating the way you solve it ?

Thanks in advance

Regards

[Former Member]

Hi Lakshmi,

I'm very sorry for such late response.

The error was due to the code written in user exit.

Regards.

Manoj