深入解析：HANA CTE 查询案例

REPORT zdemo_005.

DATA: BEGIN OF gt_result OCCURS 1,
vbeln TYPE vbap-vbeln,
TotalSales TYPE vbap-netwr,
END OF gt_result.
DATA: lv_sql TYPE string.
DATA: lv_dat type sy-datum.

WITH +Sales_cte AS (
SELECT vbeln, SUM( netwr ) AS TotalSales
FROM vbak
WHERE erdat LE @sy-datum
GROUP BY vbeln
)
SELECT * FROM +Sales_cte
INTO TABLE @DATA(gt_table) .

lv_dat = sy-datum.

lv_sql = ` WITH Sales_cte