Skip to content

ABAP Keyword Documentation →  ABAP - Quick Reference 

subquery - Quick reference

Other versions: 7.31 | 7.40 | 7.54

Syntax


... ( SELECT { ... 
               FROM ... } 

           | { FROM ... 

               FIELDS ... } 

             [WHERE sql_cond] 

             [GROUP BY ...] [HAVING
sql_cond] ) ...

Effect

Parenthesized SELECT statement that can be used in conditions sql_cond of ABAP SQL statements, in common table expressions of the statement WITH, or as a data source of an INSERT statement for a subquery.

Additions

  • As in the statement SELECT.
  • The additions SINGLE, ORDER BY, and INTO cannot be used.
  • Further additions may also be excluded, depending on how they are used.