ABAP Keyword Documentation → ABAP − Reference → Processing External Data → ABAP Database Access → ABAP SQL → ABAP SQL - Operands and Expressions → ABAP SQL - SQL Expressions sql_exp
sql_exp - sql_func
Other versions:
7.31 | 7.40 | 7.54
Syntax
... sql_func( ... sql_exp ... ) ...
Effect
Calling a predefined function in ABAP SQL. The result is the return value of the function with the associated dictionary type. As a rule, the arguments of the built-in functions cover one or more SQL expressions.
Notes
- Specifying a predefined function always means specifying an SQL expression. Predefined functions can only be called for operand positions for which SQL expressions are possible.
- Certain built-in functions can be executed in the table buffer. If any other functions are used, table buffering is bypassed.
Example
Uses the built-in functions CONCAT,
CONCAT_WITH_SPACE, and
LOWER in a SELECT list.
SELECT FROM spfli
FIELDS CONCAT( CONCAT( LOWER( carrid ), '_' ),
LOWER( CAST( connid AS CHAR ) ) ) AS key,
CONCAT_WITH_SPACE( CONCAT( cityfrom,
',' ), cityto, 1 ) AS cities
WHERE carrid = '...'
INTO TABLE @DATA(result).