ABAP Keyword Documentation → ABAP Dictionary → ABAP CDS in ABAP Dictionary → ABAP CDS - Views → ABAP CDS - DDL Statements → ABAP CDS - DEFINE VIEW → ABAP CDS - SELECT → ABAP CDS - SELECT, Operands and Expressions
ABAP CDS - cond_expr
Other versions:
7.31 | 7.40 | 7.54
Syntax
... rel_expr
| [NOT] cond_expr [AND|OR cond_expr] ...
Effect
Formulates a condition in a CDS view in
ABAP CDS whose result is true or false. A condition is either a single relational expression,
rel_expr, or an expression constructed from the Boolean operators NOT,
AND, and OR in which parenthesized full conditions cond_expr using the parentheses ( ...
) are possible. The Boolean operators work as follows:
- NOT negates the result of the following condition.
- An AND join is true if both joined conditions are true.
- An OR join is true if at least one of the joined conditions is true.
The operator NOT is a stronger binding than AND,
which itself is a strong binding than OR. This produces implicit parenthesizing,
which can be overridden by explicit parenthesizing. The following table shows the relational expressions from which a condition cond_expr can be constructed:
| rel_expr | True if |
|---|---|
| lhs = rhs | Value of lhs is equal to the value of rhs |
| lhs <> rhs | Value of lhs is not equal to the value of rhs |
| lhs < rhs | Value of lhs is less than the value of rhs |
| lhs > rhs | Value of lhs is greater than the value of rhs |
| lhs <= rhs | Value of lhs is less than or equal to the value of rhs |
| lhs >= rhs | Value of lhs is greater than or equal to the value of rhs |
| lhs BETWEEN rhs1 AND rhs2 | Value of lhs is between the values of rhs1 and rhs2 |
| lhs LIKE rhs | Value of character-like lhs matches the pattern in rhs(wildcard character in rhs: % for any character string and _ for any character); only character-likeliterals are allowed for rhs |
| lhs IS [NOT] NULL | Value of lhs is (not) the null value |
The following rules apply when the operands lhs and rhs are specified:
- General Rules
- Character literals cannot be used in comparisons with numeric values.
- Numeric literals that represent a value outside the value range of INT4 must be specified as floating point literals with a decimal point.
- Rules for use in a WHERE condition
- Rules for use in a HAVING condition
- Rules for use in an ON condition of a join expression
- Rules for use in an ON condition of an association
- Rules for use in a filter condition of a path expression
- Rules for use in a complex case distinction.
Continue
ABAP CDS - cond_expr, ON, Join