SAP CDS COND EXPR HAVING V1

Warning: file_get_contents(/customers/9/5/e/s4hd.com/httpd.www/global/php/adxcode.txt): Failed to open stream: No such file or directory in /customers/9/5/e/s4hd.com/httpd.www/global/php/helpers.php on line 89

Get Example source ABAP code based on a different SAP table

Warning: Undefined variable $prev in /customers/9/5/e/s4hd.com/httpd.www/sap/help/index.php on line 55

ABAP_CDS_DDL - DDIC-Based View, cds_cond, HAVING
Rules for conditions cds_cond in a HAVING condition of a ABAP_CDS_V1_VIEW :

The relational operator BETWEEN is not allowed. All other relational operators are 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 non-SQL CDS entity as association targets and the expression is unique:

The cardinality of the contained CDS associations is to-one.

The path expression only contains

filter conditions with addition 1:. element can be used to specify an element of the association target of the last CDS association of the path.

Other expressions and function calls are not allowed.