Get Example source ABAP code based on a different SAP table
Standard SAP Help for HAVING_CLAUSE
SELECT - HAVING
Short Reference • HAVING SELECT
ABAP Syntax ... HAVING sql_cond ... .
What does it do? The addition HAVING limits the number of rows in groups in the results set by using the logical expression sql_cond on these rows. The syntax of the logical expression sql_cond matches the syntax of the logical expression sql_cond of the WHERE condition. The comparisons of the logical expression evaluate the contents of row groups.
If rows are grouped using the addition GROUP BY, all the columns that are specified directly in the condition sql_cond using their name col are listed after GROUP BY. Specifying a different column directly raises the handleable exception CX_SY_OPEN_SQL_DB. For any columns in the database tables or views listed after FROM, any aggregate expressions can be specified in the listed database tables in the comparisons of sql_cond . 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. If, at the same time, a column of this type is also listed as an argument of an aggregate function after SELECT , the aggregate expressions after SELECT and after HAVING can be different.