美文网首页
LOOP AT GROUP

LOOP AT GROUP

作者: 阿努比斯1117 | 来源:发表于2018-10-11 14:49 被阅读0次
      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.
    

    相关文章

      网友评论

          本文标题:LOOP AT GROUP

          本文链接:https://www.haomeiwen.com/subject/aisbaftx.html