SAP WHERE LOGEXP NULL

Get Example source ABAP code based on a different SAP table

Short Reference
• IS NULL ABAP_OSQL_COND
• IS NOT NULL ABAP_OSQL_COND

ABAP_SQLCOND - IS NULL

ABAP_SYNTAX
... operand IS $[NOT$] NULL ...

What does it do?
This relational expression is true if the value of the operand operand is (is not) the null value .
The following applies to operand:

SQL expressions except for aggregate expressions and window expressions can be specified.

In a HAVING clause, aggregate expressions can also be used.

Unlike in other relational expressions, the data type can also be STRING, RAWSTRING, or GEOM_EWKB.

Latest notes:

The relational expression IS $[NOT$] NULL is the only expression for which the result is true or false when the operand contains the null value. The result is unknown for all other possible relational expressions in a condition sql_cond when one of the operands in question contains the null value. This concerns in particular also expressions specified as operands when their result is the null value. This is especially true for the null expression NULL that contains the null value by definition.

The expression IS $[NOT$] NULL must not be confused with the expression IS $[NOT$] INITIAL.

The relational expression with the predicate syntax IS $[NOT$] NULL must not be confused with the expression NULL .

Null values can also be evaluated using a null indicator.

IS $[NOT$] NULL can be used to check LOBs and geodata types. As in all other relational expressions, operands of the data types LCHR and LRAW are not possible.
NON_V5_HINTS
ABAP_HINT_END

ABAP_EXAMPLE_VX5
Comparison of the results of an inner and a left outer join. The row with null values produced by the left outer join is removed again by the WHERE condition with IS NOT NULL, so the results are the same.
ABEXA 01406
ABAP_EXAMPLE_END