ABAP Keyword Documentation → ABAP - Reference → Processing External Data → ABAP - Database Accesses → Open SQL → Open SQL - Read Accesses → SELECT
SELECT - result
Other versions: 7.31 | 7.40 | 7.54
Syntax
... lines columns ... .
Effect
The data in result
defines whether the resulting set consists of multiple rows (table-like structure) or a single row (
flat structure). It
specifies the columns to be read and defines their names in the resulting set. Note that column names from the database table can be changed. For single columns,
aggregate expressions can be used to specify
aggregates. Identical rows in the resulting set can be excluded, and individual rows can be protected from parallel changes by another program.
The data in result
consists of data for the rows
lines
and for the columns columns
.