ABAP SQL - SQL Operand Positions - ABAP Keyword Documentation

ABAP - Keyword Documentation → ABAP - Programming Language → Processing External Data → ABAP Database Access → ABAP SQL → ABAP SQL - Operands and Expressions →

Mail Feedback

ABAP SQL - SQL Operand Positions

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

Operand Position	Operands	Arguments of SQL Expressions
Column specification col_spec in a SELECT list	SQL expressions	SQL expressions
Left side of a relational expression rel_exp in WHERE clauses and ON conditions	SQL expressions except aggregate expressions and window expressions	SQL expressions except aggregate expressions and window expressions
Right side of a relational expression rel_exp in WHERE clauses and ON conditions	Elementary SQL operands, no SQL expressions	-
Left side of a relational expression rel_exp in HAVING clauses	SQL expressions except window expressions	SQL expressions except window expressions
Right side of a relational expression rel_exp in HAVING clauses	Elementary SQL operands and aggregate expressions, no other SQL expressions	-
Left side of a relational expression rel_exp for expressions	SQL expressions except aggregate expressions and window expressions	SQL expressions except aggregate expressions and window expressions
Right side of a relational expression rel_exp for expressions	SQL expressions except aggregate expressions and window expressions	SQL expressions except aggregate expressions and window expressions
Grouping criterion after GROUP BY	SQL expressions except aggregate expressions and window expressions	SQL expressions except aggregate expressions and window expressions
Window criterion after PARTITION BY	SQL expressions except aggregate expressions and window expressions	SQL expressions except aggregate expressions and window expressions
Sort criterion after ORDER BY	Columns and alias names for SQL 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 of window expressions.

Certain operand positions are subject to further restrictions and these are documented where appropriate.