on 05-12-2016 9:42 PM
Hello all! Your help is much appreciated. I am trying to see if it is possible to do the following
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.