ABAP Keyword Documentation → ABAP − Reference → Processing External Data → ABAP Database Access → ABAP SQL → ABAP SQL - Operands and Expressions → ABAP SQL - SQL Conditions sql_cond → sql_cond - rel_exp for Statements
sql_cond - IN ( ... )
Other versions:
7.31 | 7.40 | 7.54
Syntax Forms
Single operand
1. ...
operand [NOT] IN { (operand1[, operand2[, ...]]) }
| { ( SELECT
subquery_clauses [UNION ...] ) } ...
Operand list
2. ... ( operand1, operand2[, ...] ) IN { ( ( operand11, operand21[, ...] )[,
( operand12, operand22[, ...] )] ) }
| { ( SELECT
subquery_clauses [UNION ...] ) } ...
Effect
This variant of the operator IN checks whether the operands on the left side match a value from a set of values specified in parentheses. A
single operand or an
operand list can be specified on the left side. The set of values on the right side is determined using either comma-separated lists or subqueries.