topic Re: sorted and hashed tables in Application Development and Automation Discussions

sorted and hashed tables

Former Member — Fri, 18 Apr 2008 10:53:58 GMT

what happens when duplicate entries are present in sorted and hashed tables?

Re: sorted and hashed tables

Former Member — Fri, 18 Apr 2008 10:57:28 GMT

Hi,

Sorted internal tables can be of two types:

unique or non unique.

If u enter duplicate records in Sorted tables with unique it will show error.

If u enter duplicate records in Sorted tables with non-unique key it will not show error.

Hashed tables are with only unique key

so no way to enter the duplicate records.

for more information see the following link

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb35de358411d1829f0000e829fbfe/content.htm

Reward if helpful.

Jagadish

Re: sorted and hashed tables

prasanth_kasturi — Fri, 18 Apr 2008 10:58:20 GMT

hi,

sorteed tables can have a duplicate record when it has a non unique key.

if it has unique key it cannot contain duplicates.

same is the case with hashed table it cannot have duplicates as it can have only unique key.

if you try to insert duplicate records in sorted or hashed tables with unique key the lead to dump

regards

prasanth

Re: sorted and hashed tables

Former Member — Fri, 18 Apr 2008 10:58:50 GMT

Hi Rittik,

In sorted or hashed tables the dupicates are easier to find. So depending on your requirment u can either eliminate them or work with it.

As a simple reference from Wiki check this :

http://en.wikipedia.org/wiki/Hash_function

Reward if helpful,

Regards,

Esha Raj

Re: sorted and hashed tables

Former Member — Fri, 18 Apr 2008 11:03:12 GMT

hi,

SORTED TABLE: in sorted we can specify both UNIQUE and

NON-UNIQUE keys . if u specify sorted table with unique key then it will not allow duplicate records.

if u specify sorted table with non-unique key then it will allow duplicate records.

HASHED TABLE: hashed table allows only unique keys. so it won't display duplicate records.

thanks

raji

reward if helpful.

Re: sorted and hashed tables

Former Member — Fri, 18 Apr 2008 11:24:24 GMT

Hi Rittik,

For hashed table, it will Return SY-SUBRC as 4.

For sorted table, if you define WITH UNIQUE KEY, SY-SUBRC will be 4 when trying to insert duplicate, but if you define WITH NON-UNIQUE key record will get inserted.

Regards,

Mohaiyuddin