SAPSQL_ARRAY_INSERT_DUPREC - VBPA3 duplicate record

[Former Member]

Hi ,

when i modify sales order header RE partner, i receive following error:

SAPSQL_ARRAY_INSERT_DUPREC

The problem is that in table VBPA3 there is a record with sales order number as key. And when i modify RE partner , SAP tries to insert another record in VBPA3 with same key.

What should i do? is there any user exit where i can delete VBPA3 record?

Many thanks.

[Sandeep_Panghal]

The error is justified.

If RE partner is not part of key then you can try using UPDATE only for RE partner.

[Former Member]

how? where?

[Sandeep_Panghal]

ah .. i thought you are doing it programatically.. my bad.... .

Check this link if this helps :