Master programming syntax, solve interactive challenges & run live code in Syntaxis Explore Arena →
menu_book Course Curriculum (ABAP Complete Course) expand_more
Data Declarations
DATA CONSTANTS TYPES Inline DATA(...) FIELD-SYMBOLS REF TO Structures Internal tables Ranges tables Enumerated types
Expressions & Strings
VALUE operator CONV operator CAST operator COND expression SWITCH expression String templates CONCATENATE SPLIT REPLACE Regular expressions
Control Flow
IF ELSEIF ELSE CASE DO WHILE LOOP AT CHECK CONTINUE EXIT RETURN ASSERT
Internal Tables
STANDARD TABLE SORTED TABLE HASHED TABLE APPEND INSERT READ TABLE Table expressions FILTER operator REDUCE operator FOR iteration expression
Procedures & OO
FORM Function module call METHODS Class definition Constructor method Visibility sections Interfaces Inheritance Redefinition Class methods
Open SQL
SELECT SINGLE SELECT INTO TABLE WHERE JOIN GROUP BY HAVING ORDER BY INSERT database UPDATE database MODIFY database
Exceptions & Runtime
TRY CATCH CLEANUP RAISE EXCEPTION CX_ROOT MESSAGE sy-subrc AUTHORITY-CHECK COMMIT WORK ROLLBACK WORK Lock object call Application log
Modern ABAP
CORRESPONDING operator EXACT operator NEW operator REF operator LET expression BASE in VALUE Mesh-like nested access CDS view consumption AMDP method call ABAP Unit
ABAP Complete Course / Open SQL

HAVING

Learn HAVING in ABAP with a construct-specific explanation, a unique example, a practical boundary, and a mastery check.

12 min read • Intermediate

HAVING is an atomic ABAP topic inside Open SQL. The example below uses the actual construct named by the lesson rather than a generic placeholder.

Focus on what HAVING changes: the input, binding, control path, object state, collection, runtime effect, or language contract. Then alter one value and verify that the behavior changes for a reason specific to this feature.

Topic-specific example

abap-06-06-having.abap
abap Try It Live 
SELECT carrid, COUNT( * ) AS cnt FROM spfli GROUP BY carrid HAVING COUNT( * ) > 2 INTO TABLE @DATA(counts).
Edge case / engineering note

Change the key input in this ABAP example and predict the result first; the named construct should be the reason the behavior changes.

Content source & attribution
Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

HAVING Mastery Check →
← PREVIOUS
GROUP BY
NEXT →
ORDER BY