ABAP Keyword Documentation →  ABAP Dictionary →  ABAP CDS in ABAP Dictionary →  ABAP CDS - Views →  ABAP CDS - DDL Statements →  ABAP CDS - DEFINE VIEW →  ABAP CDS - SELECT →  ABAP CDS - SELECT, Operands and Expressions →  ABAP CDS - cond_expr 

ABAP CDS - cond_expr, HAVING

Rules for conditions cond_exp in a HAVING condition of a CDS view in ABAP CDS:

• The relational operators BETWEEN and IS [NOT] NULL are not allowed.

• The boolean operator NOT is not allowed.

• A field of a data source data_source or an aggregate expression for this kind of field can be specified for lhs.

• An element of the SELECT list, a literal, or a parameter can be specified for rhs. If lhs is an aggregate expression, a literal must be specified.

• A field of a data source cannot be specified using an alternative element name of the current CDS defined using AS.

• A data source field can be specified using apath expression, if this expression is not a quantity value:

• The cardinality of the contained associations is "to 1" or

• The path expression only contains filter conditions with addition 1:.

• Other expressions and function calls are not allowed.

Other versions: 7.31 | 7.40 | 7.54