Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

I need query Report discount analysis

I WANT REPORT SHOULD BE LIKE THIS

GL AccountAccount NameDocument numberDocument typeDoc dateOffset AccountAccount name/ BP nameDetails/remarksBP GroupDr AmountCr Amount
replied

Hi Karthick

SELECT T1.[Account], T2.[AcctName], T0.[BaseRef], T0.[TransType], T0.[RefDate], T1.[ContraAct]

,T3.CardName

, T0.[Memo], T4.[GroupName], T1.[Debit], T1.[Credit],T1.OcrCode2,T1.OcrCode3,T1.OcrCode4,T1.OcrCode5 FROM OJDT T0

INNER JOIN JDT1 T1 ON T0.[TransId] = T1.[TransId]

Inner JOIN OACT T2 ON T1.Account = T2.AcctCode

Left Outer JOIN OCRD T3 ON  T1.ContraAct = T3.CardCode

Left Outer Join OCRG T4 ON T3.[GroupCode] = T4.[GroupCode]

Left Outer Join OPRC T5 on T1.OcrCode2 = T5.PrcCode

WHERE T0.[RefDate] >=[%0] and  T0.[RefDate] <=[%1] and  T2.[AcctCode] =[%2]

With Regards

Balaji Sampath

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question