SAP® Documentation

Single view

ABENTABLE_EXPRESSIONS - TABLE EXPRESSIONS

PERFORM Short Reference   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

table_exp - Table Expressions

Syntax

... itab[ itab_line ] $[-comp$|[ ... ]$|->comp$] ...

Effect

A table expression consists of an internal table itab, followed directly by a row (itab_line) specified in square brackets [ ]. A chaining -comp$|[ ... ]$|->comp can be appended to this row. The expression searches for the specified row in the internal table.

  • If no chaining is specified, the whole row is returned as the result of the corresponding row type.
  • If a chaining is specified, the following is possible:
  • The structure component selector - can be used to access the component comp in the read row.

  • Square brackets [ ... ] can be used to chain multiple table expressions.

  • The object component selector -> can be used to access a component comp of the object referenced by the preceding expression.

The result of a table expression can be used as follows:

  • Reading positions

  • Writing positions

The internal table itab must be specified directly using its name, a field symbol, or a dereferenced data reference as described under Reading Positions. In a table with header line, the table body is addressed and not the header line.

If the specified row is not found, a handleable expression of the class CX_SY_ITAB_LINE_NOT_FOUND is raised in all operand positions, except when

  • a table expression is used in the statement ASSIGN, where sy-subrc is set to the value 4,
  • when used in the predicate function line_exists, where the truth value "false" is returned,
  • when used in the table function line_index, where the value 0 is returned.

Notes

  • In table expressions, the empty square brackets [] cannot be specified behind itab. In other operand positions, these empty brackets distinguish the table body from header lines.
  • Functions and constructor expressions cannot currently be specified for itab, but the table expressions shown under Chainings are possible.
  • A table expression cannot be followed directly by a specified offset/length+off(len), but this is possible after a chaining whose final place is a suitable structure component after a structure component selector.
  • Duplicate selections (multiple reads performed on the same row of an internal table in different expressions) must be avoided. In these cases, a selection should be made before the statement and the result referenced by a field symbol or reference variable.
  • The exception class CX_SY_ITAB_LINE_NOT_FOUND contains attributes for displaying the row number in the index or key used when a row cannot be accessed. If only index accesses are used in statements with multiple table expressions, it is not possible to distinguish which expression was unsuccessful.
  • Each table expression can be view as a short form for a variant of the statement READ TABLE that enables reads to be performed on rows of internal tables in operand positions.
  • In writing positions, the same restrictions with respect to modifying key fields apply to table expressions whose result is a field symbol or temporary reference variable as to other field symbols or data reference variables that point to rows of internal tables. More specifically, table expressions that return a row of a sorted table or hashed table to writing positions (like the left side of an assignment) or as actual parameters for output parameters always raise an exception.
  • Unlike READ TABLE, a table expression does not modify the value of the system field sy-tabix (except when used in the statement ASSIGN).
  • Like the statement READ TABLE, a table expression is a single row read. If multiple rows of an internal table are to be read, the statement LOOP or a FOR expression generally displays better performance than using table expressions in a loop.
  • Mesh path expressions are a special form of table expression that can be used in exactly the same way as table expressions.

Example

The content of the component carrid of the row of the internal table carrier_tab is passed to the method get_spfli. In this table, the component carrname of the secondary keyname has a specific value.

DATA carrier_tab TYPE HASHED TABLE OF scarr
                 WITH UNIQUE KEY carrid
                 WITH NON-UNIQUE SORTED KEY name COMPONENTS carrname.

SELECT * FROM scarr INTO TABLE @carrier_tab.

TRY.
    DATA(flight_tab) = cl_demo_spfli=>get_spfli(
      carrier_tab[ KEY name
                   COMPONENTS carrname = 'United Airlines' ]-carrid ).
    cl_demo_output=>display( flight_tab ).
  CATCH cx_sy_itab_line_not_found.
    cl_demo_output=>display( `Nothing found` ).
ENDTRY.

Example

Here, the first calculation with table rows is a bad example of how to use table expressions. The same selection is made three times in the same statement. The second calculation shows how this can be avoided by using an assignment to a field symbol.

DATA itab TYPE TABLE OF i.
itab = VALUE #( ( 3 ) ( 5 ) ).

"Bad example
itab[ table_line = 3 ] =
  itab[ table_line = 3 ] * itab[ table_line = 3 ].

"Good example
ASSIGN itab[ table_line = 5 ] TO FIELD-SYMBOL(<fs>).
<fs> = <fs> * <fs>.

Examples

The program DEMO_TABLE_EXPRESSIONS shows further examples of how to use table expressions.

Exceptions

Catchable Exceptions

CX_SY_ITAB_LINE_NOT_FOUND

  • Cause: The specified table row was not found.
    Runtime Error:ITAB_LINE_NOT_FOUND





RFUMSV00 - Advance Return for Tax on Sales/Purchases   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 12931 Date: 20200126 Time: 032736     sap01-206 ( 34 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.