cancel
Showing results for 
Search instead for 
Did you mean: 

Outgoing payment query

Former Member
0 Kudos

Hello all! Your help is much appreciated. I am trying to see if it is possible to do the following

  1. Sort by transfer date, customer name, and transfer amount in ascending order
  2. Filter by transfer account _SYS00000000283
  3. Add credit memos that I may have applied during an outgoing payment (scratch credit memo or copy to credit memo)

Also, I would like to learn SAP query language better. Are there any free resources that I can access to learn how to do this on my own? I have learned all that I can on my own, but besides the basics, I have a hard time with it. Thanks so much in advance!

SELECT T0.[TrsfrAcct], T0.[Canceled], T0.[DocDate], T0.[TrsfrDate], T0.[DocType], T0.[CardCode], T0.[CardName], T1.[NumAtCard], T1.[DiscPrcnt], T1.[DocTotal], T0.[Dcount], T0.[TrsfrSum], T0.[TrsfrRef], T0.[JrnlMemo] FROM OVPM T0  INNER JOIN OPCH T1 ON T0.DocEntry = T1.ReceiptNum WHERE T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1]

-Jessica

Accepted Solutions (0)

Answers (1)

Answers (1)

julie_jamieson2
Active Contributor
0 Kudos

SELECT T0.[TrsfrAcct], T0.[Canceled], T0.[DocDate], T0.[TrsfrDate], T0.[DocType], T0.[CardCode], T0.[CardName]

, CASE WHEN T4.InvType = '18'

  THEN T1.[NumAtCard]

  ELSE T2.NumatCard

  END [NumatCard]

, T1.[DiscPrcnt], T1.[DocTotal], T0.[Dcount], T0.[TrsfrSum], T0.[TrsfrRef], T0.[JrnlMemo]

FROM OVPM T0

INNER JOIN VPM2 T4 ON T0.DocNum = T4.DocNum

LEFT OUTER JOIN OPCH T1 ON T0.DocEntry = T1.ReceiptNum and T4.InvType = T1.ObjType

LEFT OUTER JOIN ORPC T2 ON T0.DocEntry = T2.ReceiptNum and T4.InvType = T2.ObjType


WHERE T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1]

AND T0.TrsfrAcct = '_SYS00000000283'


Order By T0.DocDate, T0.CardName, T0.TrsfrSum


See if this works?