SELECT
MATNR,
KUNNR ,
ZDATE ,
SUM(KWMENG) AS KWMENG ,
GROUPING_ID(MATNR,KUNNR,ZDATE) AS ID
FROM "SAPBWPRD"."ZTL_HHWFH"
GROUP BY GROUPING SETS (
(MATNR,KUNNR,ZDATE), --0
(MATNR,KUNNR), --1
(MATNR,ZDATE), -- 2
(KUNNR,ZDATE),--3
(MATNR), --4
(KUNNR), --5
(ZDATE) --6
)
HANA SQL FUNCTION - GROUPING_ID(汇总)
最新推荐文章于 2024-07-23 14:05:29 发布