Kontakt

Ansicht
Dokumentation

ABENSQL_OPERAND_POSITIONS_OVIEW - SQL OPERAND POSITIONS OVIEW

ABENSQL_OPERAND_POSITIONS_OVIEW - SQL OPERAND POSITIONS OVIEW

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

- SQL Operand Positions

The following table provides a general overview of important operand positions in 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 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 -

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






Fill RESBD Structure from EBP Component Structure   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 7728 Date: 20240426 Time: 075700     sap01-206 ( 73 ms )