SQL

BOM元件损耗

SELECT A~MATNR A~WERKS A~STLAN A~STLNR A~STLAL
B~STKOZ
C~STLTY C~STLNR C~STLKN C~STPOZ C~IDNRK C~AUSCH
FROM MAST AS A JOIN STKO AS B ON A~STLNR EQ B~STLNR
AND A~STLAL EQ B~STLAL
JOIN STPO AS C ON B~STLNR EQ C~STLNR
WHERE A~WERKS EQ '6100'
AND C~AUSCH GT 0