SELECT *
FROM EKKO
INTO TABLE @DATA(LT_EKKO)
UP TO 100 ROWS.
SORT LT_EKKO BY LIFNR ERNAM.
LOOP AT LT_EKKO INTO DATA(LS_EKKO) GROUP BY LS_EKKO-LIFNR.
"多个分组条件
"LOOP AT LT_EKKO INTO DATA(LS_EKKO) GROUP BY ( LIFNR = LS_EKKO-LIFNR ERNAM = LS_EKKO-ERNAM ).
LOOP AT GROUP LS_EKKO INTO DATA(MEMBER).
ENDLOOP.
ENDLOOP.
按LIFNR分组,LS_EKKO为每一组的第一行
LOOP AT LT_EKKO INTO DATA(LS_EKKO) GROUP BY LS_EKKO-LIFNR.
LOOP AT GROUP访问组成员
LOOP AT GROUP LS_EKKO INTO DATA(MEMBER).
SELECT *
FROM EKKO
INTO TABLE @DATA(LT_EKKO)
UP TO 100 ROWS.
SORT LT_EKKO BY LIFNR ERNAM.
LOOP AT LT_EKKO INTO DATA(LS_EKKO) GROUP BY ( KEY1 = LS_EKKO-LIFNR KEY2 = LS_EKKO-ERNAM ) INTO DATA(KEY).
LOOP AT GROUP KEY INTO DATA(MEMBER).
ENDLOOP.
ENDLOOP.
网友评论