topic Re: Problem with internal table with unique key... in Application Development and Automation Discussions

Problem with internal table with unique key...

Former Member — Sat, 21 Jun 2008 07:44:30 GMT

Hi guys,

I have an internal table with unique key...

But Im getting a dump when using it... If the key has 2 same values, it gives a dump... is it normal? what should be done to curb this?

thanks a lot!

Former Member — Sat, 21 Jun 2008 07:47:51 GMT

Hi,

Are you using a sorted table with unique key or hashed key with unique key ?

If yes, then it will give a dump.

SO to avoid this, first do a

read table itab with key x = f1.

if sy-subrc = 0.

delete itab where x = f1.

insert wa into itab.

endif.

Note: for sorted, hashed tables you have to use INSERT and not APPEND.

Does this help?

Regards,

Subramanian

Former Member — Sat, 21 Jun 2008 07:51:16 GMT

yes it is completely normal behavior.

If you pass duplicate values for the key, it defies the definition of the KEY field and hence the dump.

Regards,

ravi

Former Member — Sat, 21 Jun 2008 07:52:19 GMT

Hi,

Unique key define the column uniqully throughout the table. If you try to append the duplicate value in the column, it will raise the error.

Krishan