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
Other versions:
7.31 | 7.40 | 7.54
Syntax
.... lhs IS [NOT] INITIAL ...
Effect
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.
Notes
- 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.
Example
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.
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Demo_Cds_Is_Initial
as select from
demo_ddic_types
{
*
}
where
int8 is not initial