error KBPV_POST_IJ_VB v1 with FUNCTION 'KBPP_EXTERN_UPDATE_CO'

[Former Member]

Hi all,

i've created a program that update the budget data (ko22).

The problem is that when i execute the Function 'KBPP_EXTERN_UPDATE_CO' the system generates following error message:

SAPSQL_ARRAY_INSERT_DUPREC -->

an exception occurred that is explained in detail below.

he exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

rocedure "KBPV_POST_IJ_VB" "(FUNCTION)", nor was it propagated by a RAISING

clause.

ince the caller of the procedure could not have anticipated that the

xception would occur, the current program is terminated.

he reason for the exception is:

f you use an ABAP/4 Open SQL array insert to insert a record in

he database and that record already exists with the same key,

his results in a termination.

I've checked the sm13 and there is a following message: KBPV_POST_IJ_VB V1 Error (non retry) for the row INSERT BPIJ FROM TABLE BP_INS inside the FUNCTION KBPV_POST_IJ_VB.

Can you help me?

Thank you

[Former Member]

There are SAP Notes about this program...one is a bit old but may shed some light: 887864. Suggest you spend a little time researching SAP Notes with the search terms from the dump...