FORM DATA_SELECT .

  SELECT
         A~MATNR
         A~LABST
         A~WERKS
*        B~LGORT
         C~MTART
         C~MATKL
         C~MEINS
         B~MAKTX
         C~GROES
*        G~WERKS
*         d~verpr
  

INTO CORRESPONDING FIELDS OF TABLE GT_LIST

   FROM MARD AS A
     INNER JOIN MAKT AS B
      ON A~MATNR = B~MATNR AND SPRAS = SY-LANGU
     INNER JOIN MARA AS C
      ON A~MATNR = C~MATNR
*    INNER JOIN mbew AS d
**      ON a~matnr = d~matnr
*     AND a~werks = d~bwkey "중복된 필드 하나로 조건

WHERE A~WERKS IN R_WERKS
     AND A~LGORT IN R_LGORT
     AND C~MTART IN R_MTART
     AND C~MATKL IN R_MATKL
     AND B~MAKTX IN R_MAKTX
     AND C~GROES IN R_GROES
     AND A~MATNR IN R_MATNR.

  LOOP AT GT_LIST.  "LABST VERPR

    SELECT SINGLE VERPR INTO GT_LIST-VERPR
    FROM MBEW WHERE MATNR = GT_LIST-MATNR
    AND BWKEY = GT_LIST-WERKS.

    MOVE 'KRW' TO GT_LIST-WAERS.
    P_COST = GT_LIST-LABST * GT_LIST-VERPR.
    GT_LIST-COST = P_COST.
    MODIFY GT_LIST.
  ENDLOOP.
 

CLEAR OK_CODE.

ENDFORM.                    " DATA_SELECT

위에서 보듯이 mara, makt, mard 세개의 테이블을 join했는데요

이걸 mara, makt를 하나로 join하고

mard를 분리해서 join하려고 합니다...

어떻게 해야 할까요!? 고수님들 의 답변 부탁드립니다...