HASHED tables

former_member206396 — Mon, 11 Sep 2006 12:42:27 GMT

hi all,

how to use Hashed tables ?

syntax of hashed table creation?

syntax of read stmt of Hashed table?

if possible same things for SOrted table?

could any one help me out?

thanking you.,

ramu

Re: HASHED tables

Former Member — Mon, 11 Sep 2006 12:46:41 GMT

The table type determines how ABAP accesses individual table rows. Based on the table type, internal tables can be subdivided into the following three categories:

Sorted tables are always stored sorted by the key. Also for sorted tables, a logical index is set up internally. The data can be accessed using the table index or the key. If the data is accessed using the key, the response time depends logarithmically on the number of table entries since the data is accessed through a binary search. The key of sorted tables can be unique or non-unique. When you define the table, you must specify whether the key is UNIQUE or NON-UNIQUE.

Standard tables and sorted tables are also commonly referred to as index tables.

In hash tables, no logical index is set up internally. Hash tables can only be accessed by specifying the key. The response time in this case is constant irrespective of the number of table entries since the data is accessed through a hash algorithm. The key of hash tables must be unique. When you define the table, you must specify the key as UNIQUE.

The READ TABLE syntax is same as the standard but the response time differs depending on the type.

STANDARD TABLE:

The system searches from the start of the table. The response time is in linear relation to the number of table entries.

SORTED TABLE:

The response time is in logarithmic relation to the number of table entries.

HASHED TABLE:

The response time is constant.

Table Creation

DATA : INT_FINAL_PRD type HASHED table of TY_FINAL_PRD initial size 0

WITH UNIQUE KEY RECTYPE RECKEY kunnr TEMPB MATNR ARKTX CARQTY.

topic HASHED tables in Application Development and Automation Discussions

HASHED tables

Re: HASHED tables

Re: HASHED tables