DATA : GS_SBOOK TYPE SBOOK,
GT_SBOOK LIKE TABLE OF GS_SBOOK.
SELECT *
FROM SBOOK
INTO CORRESPONDING FIELDS OF TABLE GT_SBOOK.
TYPES : BEGIN OF TS_DATA,
CARRID TYPE SBOOK-CARRID,
CNT TYPE I, " 필드명 CNT로 수정
END OF TS_DATA.
DATA : GT_DATA TYPE TABLE OF TS_DATA,
GS_DATA LIKE LINE OF GT_dATA.
START-OF-SELECTION.
SELECT CARRID COUNT( * ) AS CNT
FROM SBOOK
INTO TABLE GT_DATA
* WHERE CARRID = 'AA'
GROUP BY CARRID
HAVING CARRID = 'AA'.
데이터가 많은 관계로 CARRID가 AA인 경우만 필터링 할 것
새로운 컬럼을 추가한 스트럭쳐 변수 타입(GS_DATA)와 인터널 테이블 GT_DATA를 선언 하고 최종 출력 테이블 GT_DATA의 컬럼은 CARRID CONNID FLDATE ORDER_DATE DAYS_AHEAD가 와야한다
TYPES : BEGIN OF TS_DATA,
CARRID TYPE SBOOK-CARRID,
CONNID TYPE SBOOK-CONNID,
FLDATE TYPE SBOOK-FLDATE,
ORDER_DATE TYPE SBOOK-ORDER_DATE,
DAYS_AHEAD TYPE I,
END OF TS_DATA.
* GS_DATA TYPE GS_DATA,
DATA :GS_DATA TYPE TS_DATA,
GT_DATA LIKE TABLE OF GS_DATA.
SELECT CARRID CONNID FLDATE ORDER_DATE
FROM SBOOK
INTO CORRESPONDING FIELDS OF TABLE GT_DATA
WHERE CARRID = 'AA'.
LOOP AT GT_DATA INTO GS_DATA.
GS_DATA-DAYS_AHEAD = GS_DATA-FLDATE - GS_DATA-ORDER_DATE.
MODIFY GT_DATA FROM GS_DATA TRANSPORTING DAYS_AHEAD.
ENDLOOP.
DATA: GS_SCARR TYPE SCARR,
GT_SCARR LIKE TABLE OF GS_SCARR.
SELECT *
FROM SCARR
INTO CORRESPONDING FIELDS OF TABLE GT_SCARR
WHERE CARRID = 'LH'.
DATA: GS_BOOKING TYPE SBOOK,
GT_BOOKINGS LIKE TABLE OF GS_BOOKING.
SELECT *
FROM SBOOK
INTO CORRESPONDING FIELDS OF TABLE GT_BOOKINGS
WHERE CUSTOMID = '00000123'.
DATA: GV_AVG_SEATSOCC TYPE P DECIMALS 2.
SELECT AVG( SEATSOCC ) INTO GV_AVG_SEATSOCC
FROM SFLIGHT
WHERE CARRID = 'AA'.
WRITE: / 'AA 항공사의 평균 좌석 점유율: ', GV_AVG_SEATSOCC.