SAP QUERY 中附加代码的语法示例


QUERY 中附加代码的语法示例,如果SELECT取的结果要写到多个变量中,格式为:into (@XX1,@XX2)

引用连接表的某个字段,前面要加@和表名;

DATA zsfhm(10) TYPE c.
CLEAR :zsf,zsfhm,zcs.
SELECT  SINGLE regio,ort01 INTO (@zsfhm,@zcs) FROM kna1
  WHERE kunnr = @vbak-kunnr .
**zsf = zsfhm.
SELECT SINGLE bezei INTO @zsf FROM t005u
  WHERE land1 = 'CN'
  AND spras = '1' and  bland = @ZsfHM .
SAP