小崔说SAP技术博客 - 企业微信
type: channel
link: https://www.sapxiaocui.top/index.php/tag/%E4%BC%81%E4%B8%9A%E5%BE%AE%E4%BF%A1/
items: SAP B1 企业微信集成开发应用连载四：SAP和企业微信接口推送和回调

SAP B1 企业微信集成开发应用连载四：SAP和企业微信接口推送和回调
type: item
date: 2024-10-21T03:16:00+00:00
description: 1.接口参数配置2.SAP推送日志表SAPR常用查询 2.1.查询待推送列表SELECT * FROM SAPR WHERE Status <> '2' AND SysNo = 'WECOM' AND IFNULL(RunNum,0) < 3 ORDER BY CreateDate DESC 2.2.重置推送UPDATE SAPR set STATUS = 0,RUNNUM = 0 WHERE ID = 'XXX'3.回调接口参数回调审批单列表WECOM常用查询 3.1.查询待企业微信审批列表 SELECT * FROM WECOM WHERE SPSTATUS = 1; 3.2.查询待SAP接口执行列表 SELECT * FROM WECOM WHERE STATUS = 1; 3.3.查询SAP接口执行失败列表 SELECT * FROM WECOM WHERE STATUS = -2; 3.4.重置SAP接口执行列表 UPDATE WECOM WHERE STATUS = 1,RUNNUM = 0 WHERE ID = 'xx'; 3.5.查询待接口主动获取审批状态列表 SELECT * FROM WECOM WHERE STATUS = 3 AND RUNNUM < 4; 3.6.重置审批单号自动获取最新审批状态 UPDATE WECOM SET STATUS = 3,RUNNUM = 0, outdata=null WHERE ID = 'xx'企业微信审批单据的节点明细表通过查询获取节点明细综上，通过连续4期将SAP和企业微信的集成开发方案包完全讲解结束，有任何疑问或者需求随时私信博主哈。