ABAP - Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP Database Accesses →  Open SQL →  Open SQL - Operands → 

Open SQL - SQL Functions

The following predefined SQL functions can either be specified as standalone functions in Open SQL or as operands of SQL expressions, in all places where SQL expressions are possible.

Function Meaning
ABS, CEIL, FLOOR, DIV, MOD, ROUND Numeric functions
CONCAT, LPAD, LENGTH, LTRIM, REPLACE, RTRIM, RIGHT, SUBSTRING String functions
COALESCE Coalesce function



Continue
sql_exp - sql_num_func
sql_exp - sql_string_func
sql_exp - sql_coalesce