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

SELECT SINGLE

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

12 min read • Intermediate

SELECT SINGLE 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 SELECT SINGLE 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-01-select-single.abap
abap Try It Live 
SELECT SINGLE carrname FROM scarr INTO @DATA(name) WHERE carrid = 'LH'.
Edge case / engineering note

Check the input collection shape, whether the operation mutates or returns a new value, and what happens for an empty collection.

Content source & attribution
Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

SELECT SINGLE Mastery Check →
← PREVIOUS
Class methods
NEXT →
SELECT INTO TABLE