SAP_MATERIAL_SO:处理材料订单缺少BOM,ROUTING信息
1. 增加这部分订单的BOM信息
2. 增加这部分订单材料的ROUTING信息
3. 如果是已开工单,则需要将BOM和ROUTING信息更新到IN_MO和IN_SFCHEADER中
目的: 从STG的IN表导数据到ODS对应表,对应关系如下
IN_ITEM => MST_ITEMMASTER
IN_ITEM_SITE => MST_ITEMSITEMASTER
IN_UOMCONVERSION => MST_UOMCONVERSION
IN_SUPPLIER => MST_SUPPLIERMASTER
IN_CUSTOMER => MST_CUSTOMERMASTER
IN_SUPPLIER_ITEM => MST_APPRSUPITEM
IN_BOM_HEADER => MST_BOMHEADER
IN_BOM_DETAILS => MST_BOMCOMPONENTS
IN_HIS_CONSUME => MST_BOMCOMPONENTS
IN_ROUTING_HEADER => MST_ROUTINGHEADER
IN_ROUTINGOPERATION => MST_ROUTINGOPERATION
IN_RESOURCE => MST_RESOURCEMASTER
IN_OPRESOURCE => MST_OPRESOURCE
IN_ITEMBOMROUTING => MST_ITEMBOMROUTING
IN_RES_CAPABILITY =>MST_WORKCENTERMASTER,MST_WORKCENTERDETAIL
IN_SALES_ORDER =>SALESORDERMASTER和SALESORDERLINE
IN_INVENTORY (- IN_MO_RESERVATION) => INVENTORY
IN_PO => PURCHORDMASTER
IN_PO => PURCHORDLINE
IN_SOURCING => SALESORDERLINE_P (+update SALESORDERLINE)
IN_SOURCING => INVENTORYPROPERTY (+update INVENTORY)
IN_MO => PRODUCTIONORDERS ---订单-MFG0001写进此表
IN_MO => SUPPLYDMDPEGGING --綁定写进此表
IN_SFCHEADER => SFCHEADER ---REL单、不需要领料
IN_SFCLINE => SFCLINE不需要领料
替代料表 SELECT * FROM ABPPMGR.MST_BOMCOMPONENTSALT where alternateitem like '000000102002000817CZ%' ;--alternateitem替代料,item为主料