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