SAP OO OBS REFR DBTAB 1 documentation, setup help and example usage

INCLUDE
ARTICLE

Do Not 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.

Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved