Snowfun

导航

 

原因:今天在制MO未取进去原因为业务人员维护验货客户尾缀时维护ZZ导致,需更新为C开头即可

 

SELECT * FROM IN_SFCHEADER WHERE MO_ID in('001100518321','001100518326')

此MO在跑IN表是存在的,跑完IN2ODS后被删除,存储过程FP_PREPROCESS

 

SELECT * FROM IN_SFCHEADER WHERE MO_ID in('001100518321','001100518326')

 

 表名ztpp_fp_0026,事务代码ZFP026

select * from SAP_QM_CUSTOMER where row_id='CC'

update SAP_QM_CUSTOMER set row_id='CC' where row_id='ZZ'

posted on 2017-07-27 15:03  Snowfun  阅读(123)  评论(0编辑  收藏  举报