cancel
Showing results for 
Search instead for 
Did you mean: 

I need query Report discount analysis

karthick_s8
Participant
0 Kudos

I WANT REPORT SHOULD BE LIKE THIS

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member212181
Active Contributor
0 Kudos

Hi Karthick,

Please try below query.

Make necessary changes if required.

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

,T3.CardName

, T0.[Memo], T4.[GroupName], T1.[Debit], T1.[Credit] 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]

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

Note:

Best way is to follow SAP Standard report
MModules > Financials > Financial Report > Accounting > General Ledger

Thanks

Unnikrishnan

karthick_s8
Participant
0 Kudos

Hi unniKrishnan,

Your Query works goood.how to link OPRC(cost centre ) details in this query,

for ex: cost centre 1,cost centre2...like that??

former_member205766
Active Contributor
0 Kudos

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

karthick_s8
Participant
0 Kudos

Thanks for you all

Regards

Karthick

Answers (1)

Answers (1)

former_member205766
Active Contributor
0 Kudos

Hi Karthick

Can you try the General Ledger Report in SAP Business one under Financial Module => Financial Report => Accounting => General Ledger

Check the below link it may helps you

Query For General Ledger | SCN

With Regards

Balaji Sampath