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 = ' '