Cannot Use REFRESH FROM

The REFRESH FROM statement for reading data from database tables is not allowed in ABAP Objects.

Error message in ABAP Objects for:

t100 = space.
t100-sprsl = 'D'.
t100-arbgb = 'BC'.
t100-msgnr = '1'.

REFRESH itab FROM TABLE t100.

Correct syntax:

DATA wa TYPE t100.

SELECT * FROM t100 INTO TABLE itab WHERE sprsl = 'D'  AND
                                         arbgb = 'BC' AND
                                         msgnr LIKE '1%'.

Reason:

The statement is replaced with the Open SQL statement SELECT. It only works with database tables whose name satisfies the naming conventions for R/2-ATAB tables (maximum five places and a T in the first position) and with table work areas declared with TABLES that are not allowed in ABAP objects. Generic key values are used for the accesses that are taken from the left-justified reserved part of the table work area. Instead, the key should be defined explicitly in the WHERE clause of the SELECT statement.

Overview:

Replacement for Obsolete Statements ABAP Objects