Skip to content

ABAP Keyword Documentation →  ABAP - Dictionary →  Built-In Functions in ABAP Dictionary →  SQL Functions 

SQL Functions for Null Values

The following table shows the SQL functions for null values that are supported by ABAP CDS and ABAP SQL. The columns ABAP CDS and SQL indicate where a function can be used. The Table Buffer column indicates whether the function can be executed in the table buffer.

SQL Function Result ABAP CDS ABAP SQL Table Buffer
COALESCE( arg1, arg2, ... ) Value of the first argument that does not have a null value. x x x

Descriptions of the potential operands and data types can be found in the corresponding documentation for ABAP CDS and ABAP SQL.

Other versions: 7.31 | 7.40 | 7.54