Named/unnamed result table (SAP Library - Reference Manual 7.2 (BC))

Named/unnamed result table

The difference between a named result table and an unnamed result table (see result table name) is that the unnamed result table cannot be specified in a FROM clause or in CURRENT OF < result table name > of a subsequent SQL statement.

QUERY statement
DECLARE CURSOR statement	A named result table is generated. The column names of a result table defined by this QUERY statement do not have to be unique.
SELECT statement (select statement)	A unnamed result table is generated. The column names of a result table defined by this QUERY statement do not have to be unique.
SELECT statement (named select statement)	A named result table is generated. The column names of a result table generated by this QUERY statement must be unique.