静态SQL
静态SQL可以使用 ABAP 7.4 新语法 Static SQL can be suitable for ABAP 7.4
静态SQL示例
DATA:
lt_mara TYPE STANDARD TABLE OF mara.
SELECT
matnr
FROM
mara
WHERE
matnr EQ '0000001'
INTO TABLE @lt_mara.
动态SQL
动态SQL目前不支持 ABAP 7.4 新语法 Active SQL isn't suitable for the ABAP 7.4
INTO TABLE 不能放在最后 INTO TABLE can't be the end
括号是必须的 Brackets required
动态SQL示例
DATA:
lv_field(20) TYPE c,
lv_table(10) TYPE c,
lv_where(40) TYPE c,
lt_mara TYPE STANDARD TABLE OF mara.
lv_field = 'matnr'.
lv_table = 'mara'.
lv_where = 'matnr EQ 000001'.
" Example 1
SELECT
(lv_field)
FROM
(lv_table)
INTO TABLE lt_mara
WHERE
(lv_where).
" Example 2
SELECT
(lv_field)
INTO TABLE lt_mara
FROM
(lv_table)
WHERE
(lv_where).
注意 Focus
WHERE 条件语句里应为内部值 Value Internal,如果有前导零需要加上前导零 Preamble Zero
未完待续...
To be continued