Warning: Undefined variable $saptab in /customers/b/9/9/trailsap.com/httpd.www/abap-statements/index.php on line 46
Get Example source ABAP code based on a different SAP table
Warning: Undefined variable $prev in /customers/b/9/9/trailsap.com/httpd.www/abap-statements/index.php on line 62
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.