EXEC SQL PERFORMING APPEND_Z4SRMM7132_OUT.
    Select p.PKDAY,
              (Select MATXT2
              From    ~~
              Where   MANDT = p.MANDT
              and     WERKS = p.WERKS
              and     MATNR = p.MATNR) as
            MATXT,
            p.AUFNR,
            p.ODQTY,
            p.BOX,
            p.STATE,
              (Select S_FLG
               From   ~~~~
               Where  MANDT = p.MANDT
               and    WERKS = p.WERKS
               and    AUFNR = p.AUFNR) as
            S_FLG,
            p.MATNR
      INTO :it_z4srmm7132_out-PKDAY,
           :it_z4srmm7132_out-MATXT,
           :it_z4srmm7132_out-AUFNR,
           :it_z4srmm7132_out-ODQTY,
           :it_z4srmm7132_out-BOX,
           :it_z4srmm7132_out-STATE,
           :it_z4srmm7132_out-S_FLG,
           :it_z4srmm7132_out-MATNR
     From   (Select p.MANDT, p.WERKS, p.PKDAY, p.MATNR,
             p.AUFNR, p.LIFNR, p.ODQTY, p.STATE, Count(PK_ID) as Box
             From   ~~~ p,
                    (Select MANDT, WERKS, PKDAY, MATNR, AUFNR
                     From ~~~
                     Where MANDT = :SY-MANDT
                     and   WERKS = :I_WERKS
                     and   PKDAY Between :BeginPK_Day and :EndPK_Day
                     and ((:A_FLAG = 'X'
                             AND (AUFNR Between :BeginPK_Lot
                                           and :EndPK_Lot))
                      OR (:A_FLAG = ' ' AND AUFNR LIKE '%'))
                     and ((:P_FLAG = 'X'
                              AND (PK_ID Between :BeginPK_Box
                                            and :EndPK_Box))
                      OR ( :P_FLAG = ' ' AND PK_ID LIKE '%'))
             and   MATNR Like '%'||:I_MATNR||'%'
             Group by MANDT, WERKS, PKDAY, MATNR, AUFNR) o
             Where   p.MANDT = o.MANDT
             and     p.WERKS = o.WERKS
             and     p.PKDAY = o.PKDAY
             and     p.MATNR = o.MATNR
             and     p.AUFNR = o.AUFNR
             and     p.STATE = 'P'
             Group by p.MANDT, p.WERKS, p.PKDAY, p.MATNR,
                      p.AUFNR, p.LIFNR, p.ODQTY, p.STATE) P
  ENDEXEC.

토드에서는 돌아 가는데 SAP에서는 : "ORA-01008: not all variables bound"

이런 덤프가 떨어지네요 이유좀 가르쳐주세요 MES TABLE에서 가져오는거라 OPEN 도 못쓰고 후..