Skip to content

ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  ABAP SQL →  ABAP SQL - Operands and Expressions 

ABAP SQL - SQL Operand Positions

The following table provides a general overview of significant operand positions in ABAP SQL and which operands can be used.

Operand Position Operands Arguments of SQL Expressions
Specified column col_spec in a SELECT list SQL expressions SQL expressions
Left side of a relational expression rel_expin WHERE clauses and ON conditions SQL expressions exceptaggregate expressions and window expressions SQL expressions exceptaggregate expressions and window expressions
Right side of a relational expression rel_expin WHERE clauses and ON conditions Elementary SQL operands, no SQL expressions -
Left side of a relational expression rel_expin HAVING clauses SQL expressions except window expressions SQL expressions except window expressions
Right side of a relational expression rel_expin HAVING clauses Elementary SQL operands andaggregate expressions, no other SQL expressions -
Left side of a relational expression rel_exp for expressions SQL expressions exceptaggregate expressions and window expressions SQL expressions exceptaggregate expressions and window expressions
Right side of a relational expression rel_exp for expressions SQL expressions exceptaggregate expressions and window expressions SQL expressions exceptaggregate expressions and window expressions
Grouping criterion after GROUP BY SQL expressions exceptaggregate expressions and window expressions SQL expressions exceptaggregate expressions and window expressions
Window criterion after PARTITION SQL expressions exceptaggregate expressions and window expressions SQL expressions exceptaggregate expressions and window expressions
Sort criterion after ORDER BY Columns and alias names forSQL expressions defined using AS -

Some operand positions are subject to certain other restrictions and these are documented where appropriate.

Other versions: 7.31 | 7.40 | 7.54