top of page
  • ABS

SAP - AP Invoice vs AP Reserve Invoice in SQL

SELECT T0.CardCode, T0.CardName, T0.DocNum, T0.DocDate, T1.ItemCode, T1.Dscription, T1.Quantity, T1.Price, T1.LineTotal from OPCH T0 INNER JOIN PCH1 T1 ON T1.DocEntry = T0.DocEntry WHERE T1.LineStatus = 'O' AND T0.DocStatus = 'O' AND T0.IsIns = 'Y' There is a filed "isIns" in OPCH table which differs b/w AP Invoices and AP Reserve Invoices 'Y' denotes for reserve invoice. SELECT T0.DocNum,T0.CardCode ,T0.CardName ,T1.ItemCode,T1.Dscription ,T1.Quantity ,T1.Price,T1.OpenQty , T0.DocTotal FROM OPCH T0 INNER JOIN PCH1 T1 on T0.DocEntry=T1.DocEntry WHERE T0.DocStatus='O' and T0.InvntSttus='O' and T0.isIns='Y' InvntSttus='C': Delivered


3 views0 comments

Recent Posts

See All

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 'Fa


Post: Blog2_Post
bottom of page