topic Define hashed table using database table in Application Development and Automation Discussions

Define hashed table using database table

Former Member — Sat, 17 Jun 2006 00:40:53 GMT

Hi,

I have a database table and would want to define a hashed table using this table structure, how would I do that?

Thanks

Re: Define hashed table using database table

suresh_datti — Sat, 17 Jun 2006 00:42:51 GMT

DATA itab TYPE HASHED TABLE OF spfli

WITH UNIQUE KEY carrid connid.

~Suresh

Re: Define hashed table using database table

Former Member — Sat, 17 Jun 2006 02:10:31 GMT

Hi Rob,

The syntax is as follows,

DATA ITAB TYPE HASHED TABLE OF SPFLI

WITH UNIQUE KEY CARRID CONNID.

The table object ITAB has the type hashed table, a line type corresponding to the flat structure SPFLI from the ABAP Dictionary, and a unique key with the key fields CARRID and CONNID. The internal table ITAB can be regarded as an internal template for the database table SPFLI. It is therefore particularly suitable for working with data from this database table as long as you only access it using the key.