on 07-22-2015 7:50 AM
I WANT REPORT SHOULD BE LIKE THIS
GL Account | Account Name | Document number | Document type | Doc date | Offset Account | Account name/ BP name | Details/remarks | BP Group | Dr Amount | Cr Amount |
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
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.