Comments
ABAP READ TABLE OBSOLET Statement syntax, information and example SAP source code
READ TABLE- obsolete_key
Short Reference
ABAP Syntax(Obsolete) READ TABLE itab { { }
| { WITH KEY dobj }
ABAP_ALTERNATIVES:
1 ... { }
2 ... WITH KEY dobj
3 ... WITH KEY = dobj
ABAP_ADDITION:
... BINARY SEARCH
What does it do? As well as the additions listed in the statement READ TABLE for specifying the individual rows to be read, outside of classes the search key can also be specified in three obsolete forms.
ABAP_ALTERNATIVE_1 ... { }
What does it do? If the search key is not specified explicitly, the internal table itab must be a
standard table with a header line . The first row found in the internal table is read for which the values in the columns of the standard key match the values in the corresponding components of the header line. Key fields in the header line that only contain blank characters are handled as if they match all values. If all the key fields in the header line only contain blank characters, the first entry in the table is read.
Latest notes: In Unicode programs , the standard key of the internal table must not contain any byte-like components when the implicit search key is used.
The statement READ TABLE itab ... is not the same as the explicit declaration of the header line itab as a work area
wa in the statement READ TABLE itab FROM wa ... . In the latter, the table key and not the search key of the header field is used for the search.
The search key can be omitted regardless of the additional obsolete short form (where no explicit target area is specified).
Example ABAP Coding In the following READ statement (in contrast to the example for READ TABLE - table_key
) no entry is usually found, since the whole standard key is compared. In particular, the components deptime and arrtime
that belong to the standard key of the internal table are of type t and contain the value "000000" instead of blank characters as an initial value in the header line. Only table entries that contain exactly these values are read.
DATA: spfli_tab TYPE STANDARD TABLE OF spfli
WITH NON-UNIQUE KEY carrid connid
WITH HEADER LINE.
FIELD-SYMBOLS <(><<)>spfli> TYPE spfli.
SELECT *
FROM spfli
INTO TABLE spfli_tab
WHERE carrid = 'LH'.
spfli_tab-carrid = 'LH'.
spfli_tab-connid = '0400'.
READ TABLE spfli_tab ASSIGNING <(><<)>spfli>.
ABAP_ALTERNATIVE_2 ... WITH KEY dobj
What does it do? If a single data object is specified directly after the addition WITH KEY , the internal table itab must be a standard table . The first row found in the internal table is read whose left-aligned content matches the content of the data object dobj . The data object dobj expects only flat data types. In the search, the start of table rows that are longer than the data object dobj are handled as if they have the same data type dobj (
casting ).
Example ABAP Coding To use the addition WITH KEY dobj for evaluating specific key fields, a structure must be created that corresponds to the relevant starting part of the row type. In contrast to the example for READ TABLE - table_key , in the following program section, the client column mandt of the table spfli_tab must be respected by the search key.
DATA: spfli_tab TYPE STANDARD TABLE OF spfli
WITH NON-UNIQUE KEY carrid connid.
DATA: BEGIN OF key_struc,
mandt TYPE spfli-mandt VALUE '000',
carrid TYPE spfli-carrid VALUE 'LH',
connid TYPE spfli-connid VALUE '0400',
END OF key_struc.
FIELD-SYMBOLS <(><<)>spfli> TYPE spfli.
SELECT *
FROM spfli
INTO TABLE spfli_tab
WHERE carrid = 'LH'.
READ TABLE spfli_tab WITH KEY key_struc ASSIGNING <(><<)>spfli>.
ABAP_ALTERNATIVE_3 ... WITH KEY = dobj
What does it do? If the addition WITH KEY is followed by a single data object after an "equals" sign, the first row found in the internal table itab is read whose entire content corresponds to the content of the data object dobj . It must be possible to convert the data object dobj to the row type of the internal table. If the data type of dobj does not match the row type of the internal table, a conversion is performed for the comparison in accordance with the conversion rules .
Latest notes: This statement has the same function as specifying the pseudo component table_line as a free key , and is replaced by this component.
READ TABLE itab WITH KEY table_line = dobj ...
Example ABAP Coding Determines (obsoletely) whether a row in an internal table exists with an elementary row type. The comment lines show the generally valid syntax with the pseudo-component table_line .
DATA itab TYPE TABLE OF i.
DO 10 TIMES.
APPEND sy-index TO itab.
ENDDO.
READ TABLE itab WITH KEY = 4
TRANSPORTING NO FIELDS.
* READ TABLE itab WITH KEY table_line = 4
* TRANSPORTING NO FIELDS.
IF sy-subrc = 0.
...
ENDIF.
ABAP_ADDITION ... BINARY SEARCH
What does it do? The addition BINARY SEARCH produces a binary search of the table, not linear. The same prerequisites and restrictions apply as when using the addition with a free search key . Before the correct row can be found, the internal table must be sorted in ascending order as follows:
If the search key is not specified explicitly, by the components of the standard key .
If the search key is specified using WITH KEY dobj , by its left-aligned content in the length of the data object.
If the search key is specified using WITH dobj , by the full table row.
Latest notes: The fact that the addition BINARY SEARCH requires a different sorting in each of the obsolete variants can be confusing and produce unexpected behavior. For this reason, the addition should not be used in the case of the obsolete variants and the non-obsolete variants of READ TABLE used instead.
Runtime Exceptions
Non-catchable Exceptions
Reason for error: The key has stricter alignment requirements than the
individual table rows.
Runtime error: READ_BAD_KEY_ALIGN
Reason for error: The key is longer than a table row and cannot be
shortened.
Runtime error: READ_BAD_KEY_PARTIAL
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved
