Skip to content

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


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

@AbapCatalog.sqlViewName: 'DEMOCDSISINI'
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Demo_Cds_Is_Initial
  as select from
      int8 is not initial