ABAP EXEC LITERAL Statement syntax, information and example SAP source code

EXEC SQL - Literals
Appropriate literals can be specified in ABAP syntax at suitable reader positions in embedded Native SQL statements.
The literal operator cannot be used in static Native SQL .
Example ABAP Coding Reads a row from the database table SPFLI using static Native SQL
. The required row is specified using literals. The target range is specified as a host variable . If a row was found, sy-subrc is set to 0; if not, it is set to 4.
DATA: BEGIN OF wa,
cityfrom TYPE spfli-cityfrom,
cityto TYPE spfli-cityto,
END OF wa.

EXEC SQL.
SELECT cityfrom, cityto
INTO :wa
FROM spfli
WHERE mandt = '100' AND
carrid = 'LH' AND connid = '0400'
ENDEXEC.