ABAP Keyword Documentation →  ABAP - Dictionary →  ABAP CDS in ABAP Dictionary →  ABAP CDS - Data Definitions →  ABAP CDS - DDL for Data Definitions →  ABAP CDS - DEFINE VIEW →  ABAP CDS - SELECT →  ABAP CDS - SELECT, Operands and Expressions →  ABAP CDS - cond_expr →  ABAP CDS - cond_expr, Operands 

ABAP CDS - cond_expr, HAVING

Rules for conditions cond_exp in a HAVING condition of a CDS-View:

• The relational operator BETWEEN is 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, an aggregate expression, a literal with an optional domain prefix, or a parameter can be specified for rhs (with the exception of the operator LIKE). If lhs is an aggregate expression, a literal must be specified.

• A field of a data source can be specified using a path expression path_expr.element, as long as the CDS associations of the expression do not have any abstract target data sources and the expression is not polyvalent:

• The cardinality of the contained CDS associations is "to 1".

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

element can be used to specify an element of the target data source of the last CDS association of the path.

• Other expressions and function calls are not allowed.

Other versions: 7.31 | 7.40 | 7.54