Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP - Database Accesses →  Open SQL →  Open SQL - Read Accesses →  SELECT 

SELECT - result

Short Reference

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.

Continue

SELECT - lines

SELECT - columns

SELECT - aggregate