top of page
Search
  • ABS

ivend-SAP Integration Monitor from SBO to ivend Query

Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As LogDatetime,

Case isNull(Status, 0) When 0 Then 'Not Processed' Else 'Failed' End As Status

From RepIntegrationLog

Where DBName = 'SAP_Blank_Rups' And Flag = 0


Not include failed record:

And isNull(Status, 0) <> 1


And run on CXSINTEGRATION database


2 views0 comments

Recent Posts

See All

SAP B1/iVend- Query Inventory In SAP

Check inventory audit in SAP select  a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then  'Sale Invoice' when a.TransType = 14 then  'Sale Credit Note' when a

Comments


Post: Blog2_Post
bottom of page