Skip to content

ABAP Keyword Documentation →  ABAP - Quick Reference 

sql_cond - Quick reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax


... { {operand1 {=|EQ|<>|NE|>|GT|<|LT|>=|GE|<=|LE} 
                  { operand2
                  | {[ALL|ANY|SOME] ( SELECT subquery [UNION ...] )} }}
    | {operand [NOT] BETWEEN operand1 AND operand2}
    | {operand1 [NOT] LIKE operand2 [ESCAPE esc]}
    | {operand IS [NOT] NULL}
    | {operand IS [NOT] INITIAL}
    | {EXISTS ( SELECT subquery [UNION ...] )}
    | {operand [NOT] IN (operand1, operand2 ...)}
    | {operand [NOT] IN ( SELECT subquery [UNION ...] )}
    | {( operand1, operand2, ... ) IN ( ( operand11, operand21 ... ),
                                        ( operand12, operand22 ... ), ... )}
    | {operand [NOT] IN @range_tab}
    | {(cond_syntax)} } ...

Effect

Condition for the content of columns after the additions WHERE, ON, or HAVING in ABAP SQL statements. The left-hand side can be specified as an SQL expression. Conditions can be put in parentheses explicitly, joined using AND and OR, and negated using NOT.

Additions