" 计算行数 SELECT COUNT(*) INTO lv_count FROM sflight WHERE carrid = 'LH'.
" 多个聚合 SELECT carrid, COUNT(*) AS cnt, SUM(price) AS total, AVG(price) AS avg_price, MAX(price) AS highest INTO TABLE lt_summary FROM sflight GROUP BY carrid.
GROUP BY
将共享列值的行分组
SELECT 中每个非聚合列必须出现在 GROUP BY 中
在 SELECT 列表之前评估
1 2 3 4
SELECT carrid, connid, COUNT(*) AS cnt INTO TABLE lt_counts FROM sflight GROUP BY carrid, connid.
⚠️如果你选择了不在 GROUP BY 中且未聚合的列,结果未定义且取决于数据库。
HAVING
过滤组(不是单个行)
在 GROUP BY 之后、SELECT 之前应用
条件中可使用聚合函数
1 2 3 4 5
SELECT carrid, COUNT(*) AS cnt INTO TABLE lt_result FROM sflight GROUP BY carrid HAVING COUNT(*) > 10. " 仅行数 > 10 的组
子句
过滤对象
应用时机
WHERE
单个行
分组之前
HAVING
组
分组之后
ORDER BY
语法
行为
ORDER BY col1 col2
按指定列排序
ORDER BY 1 3
按列位置排序(从 1 开始)
ORDER BY col1 ASCENDING col2 DESCENDING
显式方向
1 2 3 4
SELECT carrid, price INTO TABLE lt_sorted FROM sflight ORDER BY carrid ASCENDING price DESCENDING.
💡ORDER BY 绕过 SAP 表缓冲。对于缓冲表的排序输出,改为在 ABAP 中对内表排序。
DISTINCT
从结果集中删除重复行
应用于整行,而非单个列
1 2 3 4
" 唯一城市对 SELECT DISTINCT cityfrom, cityto INTO TABLE lt_routes FROM spfli.
+----------------------------------+ | 主程序 | | INCLUDE zprog_top. | ← Top include(数据声明) | INCLUDE zprog_cls. | ← 类定义 | INCLUDE zprog_pbo. | <-- PBO 模块(对话程序) | INCLUDE zprog_pai. | <-- PAI 模块(对话程序) | INCLUDE zprog_f01. | <-- FORM 例程 | INCLUDE zprog_f02. | <-- FORM 例程(按功能分组) +----------------------------------+
Include
用途
Top include(_top)
全局数据声明、TYPES、CONSTANTS
类 include(_cls)
局部类定义和实现
Form include(_f01、_f02、…)
按功能分组的模块化 FORM 例程
💡Top include 模式集中了所有数据声明。这防止重复声明并提供程序数据的清晰概览。
模块化建议
建议
原因
优先使用方法而非 FORM
方法在类中:更好的封装、继承、接口
使用类(局部或全局)
面向对象设计更易维护
保持模块化单元简短
更容易测试和理解
每个单元单一职责
每个方法/FORM 应做一件事
避免过程中使用全局变量
显式传递参数
错误处理
级别
方法
数据库操作
立即检查 sy-subrc
基于类的异常
TRY ... CATCH ... ENDTRY 配合异常类
断言
ASSERT 用于开发者不变量
函数模块
通过 EXCEPTIONS 或基于类的异常处理
返回值
使用返回参数,而不仅是 sy-subrc
1 2 3 4 5 6 7 8 9 10 11 12
" 好:立即检查 sy-subrc SELECT SINGLE * FROM sflight INTO ls_flight WHERE carrid = 'LH'. IF sy-subrc <> 0. " 处理错误 ENDIF.
" 好:基于类的异常处理 TRY. lo_handler->process_order( ls_order ). CATCH cx_static_check INTO lx_error. MESSAGE lx_error->get_text( ) TYPE 'S' DISPLAY LIKE 'E'. ENDTRY.
" 不好:循环中单条记录访问 LOOP AT lt_keys INTO ls_key. SELECT SINGLE * FROM sflight INTO ls_flight WHERE carrid = ls_key-carrid AND connid = ls_key-connid. APPEND ls_flight TO lt_result. ENDLOOP.
" 好:数组读取 IF lt_keys IS NOT INITIAL. SELECT * FROM sflight INTO TABLE lt_result FOR ALL ENTRIES IN lt_keys WHERE carrid = lt_keys-carrid AND connid = lt_keys-connid. ENDIF.
" 最好:JOIN(如果可能) SELECT f~* INTO TABLE lt_result FROM sflight AS f INNER JOIN some_table AS s ON f~carrid = s~carrid.
方式
数据库往返
性能
循环中的 SELECT SINGLE
n(很差)
O(n) 次查询
FOR ALL ENTRIES
1(或少量)
良好
JOIN
1
最佳
FOR ALL ENTRIES 性能
考虑事项
详情
检查 IS NOT INITIAL
空表 = 全表扫描
精简驱动表
SORT + DELETE ADJACENT DUPLICATES
限制驱动表大小
大表分批处理
使用索引字段
WHERE 字段应匹配索引
嵌套 SELECT 反模式
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
" 反模式:嵌套 SELECT SELECT * FROM spfli INTO TABLE lt_routes. LOOP AT lt_routes INTO ls_route. SELECT * FROM sflight INTO TABLE lt_flights " 每条路线一次查询! WHERE carrid = ls_route-carrid AND connid = ls_route-connid. " 处理 ENDLOOP.
" 正确:单次 JOIN SELECT p~carrid, p~connid, p~cityfrom, f~fldate, f~price INTO TABLE lt_result FROM spfli AS p INNER JOIN sflight AS f ON p~carrid = f~carrid AND p~connid = f~connid.
⛔循环中的 SELECT 是最常见的性能杀手。始终用 JOIN、FOR ALL ENTRIES 或预缓冲替换。
跟踪显示: SELECT * FROM SFLIGHT WHERE CARRID='LH' 耗时:120ms 记录:5 SELECT * FROM SFLIGHT WHERE CARRID='BA' 耗时:95ms 记录:3 SELECT * FROM SFLIGHT WHERE CARRID='AF' 耗时:110ms 记录:4 SELECT * FROM SFLIGHT WHERE CARRID='DL' 耗时:88ms 记录:2