BOM 表

 

 

SELECT * FROM SAPSR3.STZU@SAP_SEP where stlnr='00508457';--查看BOM创建日期时间

SELECT * FROM  SAPSR3.ZSTKO_OUT2011_1@SAP_SEP; --2022
SELECT * FROM SAPSR3.ZSTPO_OUT2011_1@SAP_SEP;

SELECT * FROM SAPSR3.ZSTKO_OUT2012_1@SAP_SEP; --2023
SELECT * FROM SAPSR3.ZSTPO_OUT2012_1@SAP_SEP;

SELECT * FROM SAPSR3.ZSTKO_OUT2061_1@SAP_SEP;  --2021
SELECT * FROM SAPSR3.ZSTPO_OUT2061A_1@SAP_SEP;

 

SELECT * FROM SAPSR3.ZSTKO_OUT2061_1@SAP_SEP WHERE MATNR='000000101002031253';--2021
SELECT * FROM SAPSR3.ZSTKO_OUT2012_1@SAP_SEP WHERE MATNR='000000101002031253';--2023
SELECT * FROM SAPSR3.ZSTKO_OUT2011_1@SAP_SEP WHERE MATNR='000000101002031253';--2022