BOM SQL 조회

EXPL_BOM_V2는 넘모 느령

    SELECT stko.stlty,

           stko.stlnr,  

           stko.stlal,  

           stko.stkoz,

           stpo.idnrk,  

           stpo.menge,  

           stpo.meins,  

           stpo.sortf,  

           mast.matnr,

           mast.werks,

           mast.stlan,  

           mast.stlnr,

           mast.stlal,

           stko.bmein,  

           stko.bmeng,  

           mkal.verid

      FROM stko

      JOIN stas

        ON stko.stlty = stas.stlty

       AND stko.stlnr = stas.stlnr

       AND stko.stlal = stas.stlal

      JOIN stpo

        ON stas.stlty = stpo.stlty

       AND stas.stlnr = stpo.stlnr

       AND stas.stlkn = stpo.stlkn

      JOIN mast

        ON stko.stlnr = mast.stlnr

       AND stko.stlal = mast.stlal

      JOIN mkal

        ON mast.matnr = mkal.matnr

       AND mast.werks = mkal.werks

       AND mast.stlan = mkal.stlan

       AND mast.stlal = mkal.stlal

     WHERE mkal.werks = '2000'

       AND mkal.matnr = '000000000006820009'

       AND stko.stlty = 'M'

       AND stas.lkenz = ' '

       AND stpo.lkenz = ' '