ABAP Keyword Documentation →  ABAP - Reference →  Obsolete Language Elements →  Obsolete Processing of External Data →  Obsolete Database Access →  Obsolete Short Forms in Open SQL → 

SELECT - Short Form

Short Reference

Obsolete Syntax

SELECT result FROM { dbtab | *dbtab } ... .


This statements is a short form of the following Open SQL statements for accessing a single database table dbtab:

SELECT result FROM dbtab INTO { dbtab | *dbtab } ...

The explicit specification of a work area does not apply in the short form. A

table work area dbtab or *dbtab is used implicitly as a work area, and must be declared with TABLES. If the name *dbtab is used instead of the name of the database table dbtab, the table dbtab is still accessed, but the additional table work area is used.


The short form is not allowed in classes. An explicit work area should be used instead.