topic Hashed tables in Application Development and Automation Discussions

Hashed tables

Former Member — Thu, 21 Feb 2008 09:32:49 GMT

Hi experts,

I have a hashed table, which has a unique key called vbeln. The program selects vbeln into the hashed table from lips. It gives me an error ITAB_DUPLICATE_KEY. My question is how can I avoid to select duplicate entries into this table. The program is sorting the hashed table and deletes the adjacent duplicates, but I think it's not a good solution, because before the sorting and deleting it selects duplicates into this hashed table which results a short dump. What would be the best solution to handle this problem. I thought about to change the type of the hashed table, but it can contain a hugh amount of data and if I change the type of it, then it could be very slow to read data from the internal table.

I hope somebody can help.

Thanks in advance!

Re: Hashed tables

Former Member — Thu, 21 Feb 2008 09:39:27 GMT

I not sure if i understood correctly but i would write a more specific select perhaps

SELECT DISTINCT FIELDA FIELDB INTO ...

Hope this helps

Re: Hashed tables

Former Member — Thu, 21 Feb 2008 09:56:35 GMT

Hi,

how about SELECT SINGLE...?

it selects the first row only if we have multiple entries.

<REMOVED BY MODERATOR>

teja.

Edited by: Alvaro Tejada Galindo on Feb 21, 2008 5:09 PM