ARTICLE
rel_exp - Comparisons of Calculation Expressions
Any calculation expression can
be specified as an operand of a
comparison expression .
The table below lists all combinations that are possible for calculation
expressions in comparison expressions:
One Page Relational Operator Other Page
Single operand with numeric data type
or arithmetical expression
= , EQ , ,
NE , , LT , , GT , = ,
LE , = , GE
Arithmetic expression
Single operand with any elementary
data type or string expression
= , EQ , , NE
, , LT , , GT , = ,
LE , = , GE , CO ,
CN , CA , NA , CS , NS , CP , NP
String expression
Single operand with byte-like data
type or bit expression
= , EQ , , NE
, , LT , , GT , = ,
LE , = , GE , BYTE-CO
BYTE-CN , BYTE-CA , BYTE-NA , BYTE-CS ,
BYTE-NS , O , Z , M
Bit expression
The comparison type is determined
differently depending on the type of calculation expression.
Comparisons of arithmetic expressions
Comparisons of string expressions
Comparisons of bit expressions
In the case of comparison expressions using the relational operators
BETWEEN and
IN that are switched internally
to joins of comparisons with the binary operators above, the rules of
the individual comparisons apply.
Notes
Relational expressions cannot
yet be compared. Instead, they can be combined using
Boolean operators , where the link
with the operator EQUIV corresponds to
the comparison of the resulting logical
values concerning equality.
A calculation expression
cannot be specified as the operand of a
predicate expression .
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved