*" SAP 표준 쿼리.... RM07DOCS
SELECT mkpf~budat AS budat
       mkpf~cpudt AS cpudt
       mseg~mjahr AS mjahr
       mseg~mblnr AS mblnr
       mseg~zeile AS zeile
  INTO CORRESPONDING FIELDS OF TABLE itab
  FROM mkpf
  JOIN mseg
    ON mkpf~mandt = mseg~mandt
   AND mkpf~mblnr = mseg~mblnr
   AND mkpf~mjahr = mseg~mjahr
 WHERE mkpf~budat IN budat
   AND mseg~bwart IN bwart
   AND mseg~werks IN werks
 %_HINTS ORACLE '&SUBSTITUTE VALUES&'.

  SELECT DISTINCT
         mseg~bwart AS bwart  " 이동유형
         mseg~werks AS werks  " 출고 플랜트  
         SUM( mseg~menge ) AS menge " 입고수량
         SUM( mseg~dmbtr ) AS dmbtr " 입고금액
   APPENDING CORRESPONDING FIELDS OF TABLE itab
    FROM mkpf
   INNER JOIN mseg
      ON mkpf~mandt = mseg~mandt
     AND mkpf~mjahr = mseg~mjahr
     AND mkpf~mblnr = mseg~mblnr
   WHERE mkpf~budat BETWEEN fr_budat AND to_budat
     AND mseg~xauto = ''
     AND mseg~bwart IN s_bwart
     AND mseg~werks IN s_werks
   GROUP BY mseg~bwart
            mseg~werks
*  %_HINTS ORACLE 'ORDERED USE_NL (T_00 T_01)'.
*  %_HINTS ORACLE 'RULE'.

* HINTS 를 이렇게 쓰는 이유가 뭔지 궁금하구요,,,,

* 왜 이런 구문으로 써야 하는지도 궁금하네요... 좀 알려주세요~~~

* 그냥 쓰라고 해서 쓰긴 했는데,,,, 이유도 모르고 쓰는 거라.. 헹~