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	-

• The arguments of aggregate expressions can be SQL expressions with the exception of aggregate expressions and window expressions.

• The arguments of window expressions can be SQL expressions with the exception ofwindow expressions.

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

Other versions: 7.31 | 7.40 | 7.54