Ansicht
Dokumentation
ABAPREFRESH_OBSOLETE - REFRESH OBSOLETE
BAL Application Log Documentation SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
REFRESH itab FROM
REFRESH itab FROM TABLE ${ dbtab $| *dbtab$}.
Effect
The variant of the statement REFRESH, which is forbidden in classes, initializes the internal table itab, reads multiple rows from a database table or DDIC table view dbtab, and appends their content to the internal table itab. The row content is cast to the line type of the internal table. If the line type of the internal table is too short, it is truncated on the right.
dbtab expects a database table or a DDIC table view that starts with "T" and has a maximum length of five characters. For the database table or view dbtab, a table work area or an additional table work area must be declared using the statement TABLES. The internal table itab must be an index table. All components of the table work area that match the primary key fields of the database table or view dbtab must be character-like.
The rows to be read are determined by the content of the components of the table work area, which correspond with the primary key fields of the database table or view dbtab. The content of these components is taken left-aligned as a search key, and the system makes a generic search for suitable entries in the database table or view. The search key handles blanks as if they match all values.
If the database table or view does not match the specified naming conventions, the behavior of the statement is undefined.
System Fields
This statement always sets sy-subrc to 0.
Notes
- This form of the REFRESH statement must be replaced by the SELECT statement.
-
The obsolete access statements do not support automatic
client handling. The
client identifier
of a database table must be specified explicitly. The application programs are only to work with data for the current client. In systems with
multitenancy, this is checked by the ABAP runtime environment.
Example
Reads multiple rows from the database table T100 into an internal table itab.
TABLES t100.
DATA itab TYPE STANDARD TABLE OF t100.
t100-sprsl = 'E'.
t100-arbgb = 'BC'.
REFRESH itab FROM TABLE t100.
The syntax to be used instead reads:
Exceptions
Non-Catchable Exceptions
- Cause: No memory available to execute the statement.
Runtime Error: REFRESH_NO_SHORT_MEMORY
PERFORM Short Reference General Material Data
This documentation is copyright by SAP AG.
Length: 4001 Date: 20240425 Time: 184639 sap01-206 ( 55 ms )