집계( SUM + at new, at first, at end of)

최종 작성일: 2024-06-07

목표: 'COLLECT  행 INTO 테이블' 구문 보다 더 빠르게 집계하는 SUM 구문에 대해서 확인해보기 

 

[구문 구조]

 

LOOP AT 테이블 INTO 행.

AT END OF 집계하고자 하는 칼럼 명.

SUM.

APPEND 행 TO 인터널 테이블.

ENDAT.

ENDLOOP.

 

at end of loccuram

at new loccuram

at first

*&---------------------------------------------------------------------*
*& Report ZTEST_SUM
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT ZTEST_SUM.

TYPES : BEGIN OF t_sbook,
    carrid TYPE sbook-carrid,
     loccuram TYPE sbook-loccuram,
    loccurkey TYPE sbook-loccurkey,
    END OF t_sbook.

DATA : t_result type SORTED TABLE OF t_sbook WITH NON-UNIQUE KEY carrid,
      w_result TYPE t_sbook,
      i_result TYPE TABLE OF t_sbook.

SELECT * FROM SBOOK
 INTO table @data(w_sbook).

MOVE-CORRESPONDING w_sbook TO t_result.


LOOP AT t_result into w_result.
 "at first. "그냥 다 count 하는 것
"at new loccuram.
at END OF carrid.
   SUM.
 APPEND w_result TO i_result.
ENDAT.
endloop.

cl_demo_output=>display( i_result ).