ABAP Keyword Documentation → ABAP - Dictionary → ABAP CDS in ABAP Dictionary → ABAP CDS - Data Definitions → ABAP CDS - DDL for Data Definitions → ABAP CDS - DEFINE VIEW → ABAP CDS - SELECT → ABAP CDS - SELECT, Operands and Expressions → ABAP CDS - cond_expr
ABAP CDS - cond_expr, INITIAL
.... lhs IS [NOT] INITIAL ...
Determines the initial value. This expression is true if the value of lhs is (is not) the initial value of its built-in dictionary type. The same context-dependent rules apply to the operands lhs as to comparisons and only operands of the comparable types can be specified. The operand also cannot have the type RAW.
- The expression IS [NOT] INITIAL is suitable for checking the type-dependent initial value (regardless of its actual data type), instead of comparing it with a type-friendly operand that contains the initial value.
The expression IS [NOT] INITIAL must not be confused with the expression IS [NOT] NULL.
The following CDS view reads all rows from the database table DEMO_DDIC_TYPES in which the column INT8 does not contain its initial value 0.
define view Demo_Cds_Is_Initial
as select from
int8 is not initial