RSZDELETE: Runtime error ITAB_DUPLICATE_KEY during unused query deletion

[former_member232825]

I have executed this transaction in background and it has returned a runtime error ITAB_DUPLICATE_KEY.

How can I solve this problem?

[FredericGirod]

Hi Lara,

it looks like a bug, maybe open a call with SAP

regards

Fred

[david_liu1]

Hello,

You can apply the SAP Note 1793119 and see if it helps.

Regards,

David

[arindam_m]

Hi,

Check the SAP Note 1164904. It is a new revision of the transaction so should help you to fix all issues with older versions.

Cheers,
Arindam

[Former Member]

Hi Lara,

This error occurs when you have duplicate entries in the internal table. Consider you have a internal table(name and userid) with a key field where userid is the key field.

Now if you try to insert the value in this empty internal table with userid = 'Lara' and name 'Lara David', then it fine there is no issue. Now you have one record in internal table.

Now if you try to insert the record with userid = 'Lara' and name 'David', here it gives you an error saying ITAB_DUPLICATE_KEY at runtime since userid field is the key field it cannot have duplicate entries.

This problem especially occurs when you have a internal table of type sorted table and with unique key declaration as:

DATA: itab TYPE SORTED TABLE OF ztab WITH UNIQUE KEY id.

Hope you understood the problem.

Regards,

Satish

[former_member232825]

The biggest problem to this issue was running the transaction in background. This should be executed in dialog.