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 select_list ...
Effect
The information in result consists of data for the rows
lines and for the columns select_list.
-
If specified,
linesdefines whether the results set consists of multiple rows (table-like structure) or a single row (flat structure). Identical rows in the results set can be excluded, and individual rows can be protected from parallel changes by another program. -
It
SELECTlistselect_listspecifies the columns to be read and defines their names in the results set. Note that column names from the database table can be changed. For single columns, aggregate expressions can be used to specify aggregates. SQL expressions enable table fields to be evaluated in the database system.