Skip to Content
0
Former Member
Apr 22, 2008 at 09:59 AM

ABAP dump(SAPSQL_ARRAY_INSERT_DUPREC) while creating a delivery

2639 Views

Hello Friends,

I am getting the dump while creating the delivery .The error details are as follows.

The ABAP/4 Open SQL array insert results in duplicate database record

What happened?

The current ABAP/4 program "SAPLV05I " had to be terminated because

one of the statements could not be executed.

How to correct the error

Use an ABAP/4 Open SQL array insert only if you are sure that none of

the records passed already exists in the database.

If the error occurred in a non-modified SAP program, you may be

able to find a solution in the SAP note system.

If you have access to the note system yourself, use the following

search criteria:

"SAPSQL_ARRAY_INSERT_DUPREC"

"SAPLV05I " or "LV05IU15 "

"SD_PARTNER_UPDATE"

Source code extract

004500 POSNR = I_XVBPA-POSNR

004510 PARVW = I_XVBPA-PARVW.

004520 IF I_YVBPA-STCD1 <> I_XVBPA-STCD1 OR

004530 I_YVBPA-STCD2 <> I_XVBPA-STCD2 OR

004540 I_YVBPA-STCD3 <> I_XVBPA-STCD3 OR

004550 I_YVBPA-STCD4 <> I_XVBPA-STCD4 OR

004560 I_YVBPA-STCDT <> I_XVBPA-STCDT OR

004570 I_YVBPA-STKZN <> I_XVBPA-STKZN OR

004580 I_YVBPA-J_1KFREPRE <> I_XVBPA-J_1KFREPRE OR

004590 I_YVBPA-J_1KFTBUS <> I_XVBPA-J_1KFTBUS OR

004600 I_YVBPA-J_1KFTIND <> I_XVBPA-J_1KFTIND.

004610 MOVE-CORRESPONDING I_XVBPA TO WA_XVBPA3I.

004620 APPEND WA_XVBPA3I TO DA_XVBPA3I.

004630 ENDIF.

004640 ENDIF.

004650 ENDIF.

004660 WHEN UPDKZ_OLD.

004670 IF DA_VBPA-ADRDA CA GCF_ADDR_IND_COMB_MAN_OLD OR

004680 DA_VBPA-ADRDA CA GCF_ADDR_IND_COMB_MAN_ADRC.

004690 YADR-ADRNR = DA_VBPA-ADRNR. COLLECT YADR.

004700 ENDIF.

004710 IF DA_VBPA-ADRDA CA GCF_ADDR_IND_COMB_MAN_OLD OR

004720 DA_VBPA-ADRDA CA GCF_ADDR_IND_COMB_MAN_ADRC.

004730 XADR-ADRNR = DA_VBPA-ADRNR. COLLECT XADR.

004740 ENDIF.

004750 ENDCASE.

004760 ENDLOOP.

004770 UPDATE (OBJECT) FROM TABLE DA_XVBPAU.

004780 UPDATE VBPA3 FROM TABLE DA_XVBPA3U.

004790

> INSERT (OBJECT) FROM TABLE DA_XVBPAI.

004810 INSERT VBPA3 FROM TABLE DA_XVBPA3I.

004820

004830 IF SY-SUBRC > 0.

Could you please suggest me ,what could be the reason for dump and how to avoid dump?

<REMOVED BY MODERATOR>

Thank you in advance,

Arvind.

Edited by: Alvaro Tejada Galindo on Apr 22, 2008 5:16 PM

Edited by: Alvaro Tejada Galindo on Apr 22, 2008 5:16 PM