Ansicht
Dokumentation

ABENWHERE_LOGEXP_NULL - WHERE LOGEXP NULL

General Data in Customer Master   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Short Reference

- IS NULL

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

Effect

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.

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. More specifically, this is relevant for expressions specified as operands when their result is the null value.

• 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.

Example

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.

BAL_S_LOG - Application Log: Log header data   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 3029 Date: 20240425 Time: 130020     sap01-206 ( 38 ms )