Open SQL - Host Expressions - ABAP Keyword Documentation

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

Open SQL - Host Expressions

Syntax

... @( expr ) ...

Effect

Host expressions are ABAP expressions expr that can be specified in operand positions in Open SQL. expr is a general expression position. Any expressions or calls possible here, plus individual data objects, can be specified.

The operand positions for host expressions are the following reading positions:

Arguments of SQL expressions and hence all operand positions in which these are possible.
Operand n after UP TO.
Operand n after PACKAGE SIZE.
Right sides of WHERE, ON, or HAVING conditions, except for LIKE and IN.
Actual parameters for input parameters of CDS views or CDS table functions.
Work areas wa and the internal tablesitab of the statements INSERT, UPDATE, MODIFY and DELETE.
Right side of a SET expression in UPDATE.

The host expressions of an Open SQL statement are evaluated from left to right and the results are passed to the database, like the content of host variables. The following restrictions apply:

Host expressions cannot be used in dynamic tokens.

In a host expression of a SELECT list, it is not possible to derive a data type from the operand position for the character # for a constructor expression.

Notes

In the operand positions where host expressions can be specified, it is also always possible to specify host variables. The reverse does not apply.

Host expressions can be specified as a part of SQL expressions or as elementary SQL expressions and wherever these SQL expressions are possible.

When host expressions are specified, the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.

Examples

See

Host Expressions in the WHERE Condition

SQL Expressions in the WHERE Condition

Continue
Host Expressions, Use in the WHERE Condition