DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

[Former Member]

Hi,

when I modify a certain sales order document I get a Dump with the error "SAPSQL_ARRAY_INSERT_DUPREC" in INSERT_POS_IN_DB

Any ideas?

Thanks in advance,

F

[Former Member]

any exits or enhancements on the VA01 transaction. I am thinking the error is from the custom implementation what you did, are you adding any entries to the item/header in the user exits (xvbak/xvbap internal tables). confirm this once.

[Former Member]

Hi, I am trying to modify VBAK-LIFSK, even though it has happened in other fields.

Any suggestion?

F

[Former Member]

instead of modify you may be using the APPEND check it once.

show the code what you are doing..?

[Former Member]

Hi,

I am modifying VBAK-LIFSK though VA02 and after saving the document I get the DUMP.

F

[Former Member]

there is no enhancements/exits implemented. check in MV45AFZZ , just keep a break point in SAVE_DOCUMENT_PREPARE and see the internal table contents XVBAK, XVBAP and let me know.

[Former Member]

Hi,

Thanks all!!!! This issue has been solved. It was due to a TO that we imported this morning.

Best regards,

F

[Former Member]

i guess...then internal table in which you are inserting a value is a sorted table.

try using:

insert wa into table itab.

or it you are inserting a duplicate record in DB

Edited by: Amit Gupta on Oct 7, 2008 3:56 PM