ABAP SQL

1. 插入到SQL查询中的CASE语句

示例1：

SELECT name, number,
CASE
WHEN num <= 10 AND score >= 75 THEN @lc_num1
WHEN num <= 25 AND score >= 50 THEN @lc_num2
ELSE @lc_num3
END AS lt_student
FROM ztsm_student
WHERE number = @number
INTO CORRESPONDING FIELDS OF TABLE @table_of_student.

备注：1.必须在变量或者常量前面加上@符号，以便让编译器知道讨论的不是数据库的字段。

           2.数据库检索字段之间添加逗号。

           3.结尾处添加INTO语句。

2. SQL语句 中的计算

示例2：

SELECT name , number ,
CAST(score AS FLTP) / CAST(num AS FLTP) 
AS ratio
FROM ztsm_student
WHERE number = @number
INTO CORRESPONDING FIELDS OF TABLE @table_of_student.

3. WHERE字句的改进

示例3：

SELECT a , b, c
FROM zt_table
WHERE e + f > 100
INTO TABLE @DATA(lt_table).

示例4：

SELECT a , b, c
FROM zt_table
WHERE  g = &