REFRESH - Delete an internal table

Variants

1. REFRESH itab.
2. REFRESH itab FROM TABLE dbtab.
3. REFRESH itab FROM SELECT-OPTIONS.

Variant 1

REFRESH itab.

Effect

The internal table itab is reset to its initial state, i.e. all table entries are deleted.

The return code value SY-SUBRC is undefined.

Notes

The header entry of a table with a header line remains unchanged. It can be reset to its initial value using CLEAR .

FREE itab can be used to free up the memory allocated to the table.

Variant 2

REFRESH itab FROM TABLE dbtab.

Note

This variant is no longer maintained and should no longer be used (see also obsolete language constructs ). Please use the SELECT ... INTO TABLE statement instead.

Effect

The internal table itab is deleted and it is then filled with the contents of the database table dbtab .
A generic argument can be used to specify a restriction to a particular part of the database table when filling (LOOP AT dbtab , READ TABLE dbtab ).
The table dbtab must be declared in the program using TABLES .

The return code value SY-SUBRC is undefined.

Example

Deleting an internal table MESSAGES , followed by filling the table with all messages from the table T100 with language key 'D' and ID 'RF' .


TABLES T100.
DATA BEGIN OF MESSAGES OCCURS 200.
       INCLUDE STRUCTURE T100.
DATA END   OF MESSAGES.
MESSAGES-TEXT = 'Delete me'.
APPEND MESSAGES.
T100-SPRSL = 'D'.
T100-ARBGB = 'RF'.
REFRESH MESSAGES FROM TABLE T100.

Variant 3

REFRESH itab FROM SELECT-OPTIONS.

Note

This variant is no longer supported (see also obsolete language constructs ). The equivalent functionality is now available in the function module RS_REFRESH_FROM_SELECTOPTIONS .

Effect

Deletes the internal table itab and then transfers the database selections and the selection parameters together with the values entered by the user.

Notes

Performance
The runtime for the execution of the REFRESH statement is around 5 ms (standard microseconds).

Index
© SAP AG 1996