Documentation View

We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

ABAPHAVING_CLAUSE - HAVING CLAUSE

ABAPHAVING_CLAUSE - HAVING CLAUSE

General Data in Customer Master   CPI1466 during Backup  
This documentation is copyright by SAP AG.
SAP E-Book

SELECT, HAVING

Short Reference



... HAVING sql_cond ...

Effect

The addition HAVING limits the number of rows in groups in the result set of a query by using the logical expression sql_cond on these rows. The logical expression evaluates the content of row groups. Those rows are placed in the result set for which the logical expression is true.

The following applies to the operands of the relational expressions of the logical expression sql_cond:

  • Non-aggregated columns used as operands in the data sources specified after FROM do not have to be listed as such in the SELECT list and are listed after the addition GROUP BY instead. For each group, the value used for the grouping is evaluated.
  • If SQL expressions are used on the left side, either the same expression must be specified or all non-aggregated columns of the expression must be specified individually after GROUP BY.
  • In a HAVING condition, aggregate expressions sql_agg can be used directly or as operands of SQL expressions on both sides of comparisons. Columns that are specified as the argument of an aggregate expression directly or via an SQL expression do not need to be listed after GROUP BY. This kind of aggregate expression is evaluated for each row group defined in GROUP BY and its result is used as an operand in the comparison. The aggregate functions of the SELECT list and the HAVING clause and the SQL expressions specified as arguments here do not need to be the same.

If a HAVING clause is specified, all columns in the SELECT list that are not arguments of aggregate expressions here must be specified after GROUP BY. If the SELECT list is specified as *, HAVING clauses without GROUP BY clauses cannot be used.

Implicit client handling applies to the HAVING clause. The client column of a client-dependent data source cannot be used as an operand in the HAVING condition.

Notes

  • Aggregate expressions on the left side of a logical expression after HAVING are SQL expressions. Thus, all SQL expressions except for window expressions can be specified there. Aggregate expressions on the right side of a logical expression are an exception to the rule that no SQL expressions can be specified here.
  • Columns that are specified as arguments of aggregate expressions after HAVING can also be specified after GROUP BY.
  • If a column is specified using a path expression, both the parameter passing and any attributes specified are respected by comparisons between the SELECT list and the HAVING clause.
  • If the addition GROUP BY is not specified or the data object column_syntax in the dynamic column specification after GROUP BY is initial, the addition HAVING can only be specified if the entire result set is grouped into a row, that is, if there are only aggregate expressions specified after SELECT. In this case, only those aggregate expressions can be specified as operands in sql_cond that are evaluated for all rows in the result set.
  • When an SQL expression is specified on the left side of the HAVING condition or a host expression occurs on the right side, the syntax check is performed in strict mode from Release , which handles the statement more strictly than the regular syntax check.

Example

Reading of the number of bookings in each class and for each flight date of a connection.

SQL Expressions, Use in Aggregate Expressions






CL_GUI_FRONTEND_SERVICES - Frontend Services   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 6049 Date: 20230323 Time: 114258     sap01-206 ( 106 ms )