【ABAP】Native SQL
查询
DATA: BEGIN OF wa,
connid TYPE spfli-connid,
cityfrom TYPE spfli-cityfrom,
cityto TYPE spfli-cityto,
END OF wa.
DATA c1 TYPE spfli-carrid VALUE 'LH'.
"Native SQL语句不能以句点号结尾；
"不能在EXEC SQL…ENDEXEC间有注释，即不能有星号与双引号的出现；
"参数占位符使用冒号，而不是问号；
EXEC SQL PERFORMING loop_output.
SELECT connid, cityfrom, cityto
INTO :wa
"或使用：INTO :wa-connid ,:wa-cityfrom ,:wa-cityto
FROM spfli
WHERE carrid = :c1
ENDEXEC.
FORM loop_output.
WRITE: / wa-connid, wa-cityfrom, wa-cityto.
ENDFORM.