--针对外购半成品（外购半成品暂时只有成品层有BOM数据，外购半成品没有BOM数据）
SELECT * FROM SAP_QM_CUSTOMER WHERE MATNR='';
--select * from TB_ADDBOMWG_LOG;
--SELECT * FROM TB_MAN_ROUTING_QM;
SELECT * FROM IN_ITEM WHERE ITEM_ID LIKE '%000000103040000441%';
SELECT * FROM IN_ITEM_SITE WHERE ITEM_ID LIKE '%000000103040000441%';
SELECT * FROM IN_BOM_HEADER WHERE BOM_ID='00116631_2023_01CZ';
SELECT * FROM IN_BOM_DETAILS WHERE BOM_ID='00116631_2023_01CZ';
SELECT * FROM IN_ROUTING_HEADER WHERE ROUTING_ID like '%50091251_2023CZ%';
SELECT * FROM IN_ROUTINGOPERATION WHERE ROUTING_ID like '%50091251_2023CZ%';
SELECT * FROM IN_SALES_ORDER WHERE SO_ID='' AND SO_LINE_ID LIKE '10_1';
SELECT * FROM IN_ITEMBOMROUTING WHERE BOM_ID='00116631_2023_01CZ';--PRODUCED_ITEM_ID LIKE '%000000101003000301%';
SELECT * FROM IN_SFCHEADER WHERE MO_ID IN (''); --ITEM : 000000101005008245CA
SELECT * FROM IN_SFCHEADER_20170411 WHERE MO_ID IN (''); --一开始时进入IN_SFCHEADER个的数据作一个备份
SELECT * FROM IN_SFCHEADER_TEMP WHERE MO_ID IN ('');--进入 IN_SFCHEADER表后被删除的数据保存在此表
SELECT * FROM IN_SALES_ORDER WHERE SO_ID='' AND SO_LINE_ID LIKE '70%';--00359383_2023_01CA
SELECT * FROM IN_ITEMBOMROUTING WHERE PRODUCED_ITEM_ID LIKE '%000000101005008245%';--00359383_2023_01CA 50359108_2023CA 000000101005008245CA
--SELECT * FROM IN_ITEMBOMROUTING_TEMP WHERE PRODUCED_ITEM_ID LIKE '%000000101005008245%'; 被删除的数据
SELECT * FROM IN_ITEM WHERE ITEM_ID LIKE '%000000101005008245%';
SELECT * FROM IN_ITEM_SITE WHERE ITEM_ID LIKE '%000000101005008245%';
SELECT * FROM IN_BOM_HEADER WHERE PRODUCT_ID like'%000000101005008245%'; --BOMID : 00359383_2023_01CA
SELECT * FROM IN_BOM_DETAILS WHERE BOM_ID='00119770_2023_01CA';
SELECT * FROM IN_ROUTING_HEADER WHERE ROUTING_ID like '%50359108_2023CA%'; --00359383_2023_01CA
------------------------------
