SAP SQL OPERAND POSITIONS OVIEW



Get Example source ABAP code based on a different SAP table
  



AB_SQL - SQL Operand Positions
The following table provides a general overview of important operand positions in AB_SQL and which operands can be used. Operand PositionOperandsArguments of SQL Expressions
Column specification col_spec in a SELECT listSQL expressionsSQL expressions
Left side of a relational expression rel_exp in WHERE clauses and ON conditionsSQL expressions except aggregate expressions and window expressionsSQL expressions except aggregate expressions and window expressions
Right side of a relational expression rel_exp in WHERE clauses and ON conditionsElementary SQL operands, no SQL expressions-
Left side of a relational expression rel_exp in HAVING clauses SQL expressions except window expressionsSQL expressions except window expressions
Right side of a relational expression rel_exp in HAVING clausesElementary SQL operands and aggregate expressions, no other SQL expressions -
Left side of a relational expression rel_exp for expressionsSQL expressions except aggregate expressions and window expressionsSQL expressions except aggregate expressions and window expressions
Right side of a relational expression rel_exp for expressionsSQL expressions except aggregate expressions and window expressionsSQL 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.