cancel
Showing results for 
Search instead for 
Did you mean: 

How to get Row = 2 Details in report from JDT1 Table

former_member209725
Participant
0 Kudos

Dear Experts,

SELECT T0.TransId, T0.Account, T1.[AcctName]Row1, T0.Debit, T0.Credit, T0.RefDate, T0.BaseRef, T0.Closed, T0.Ref1, T0.Ref2, T0.Ref3Line, T0.RelType

FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode

WHERE T1.[AcctName] = [%0]

in above query i want ROW2 Detail from JDT1Table.

Any Help?

Regards,

Rahul

Edited by: RAVI_JHA_SAP on Mar 3, 2011 8:27 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI Ravi ,

There is a Report in the Standard SAP , which will meet your requirement .

Check the Financial -> Financial Reports ->Accounting - > General Ledger Report

Untick the BP and Choose the Account in the Ledger Selection.

Enter the parameter as needed .

Hope u will get the result.

Thanks

--

Ashish Ranjan

former_member209725
Participant
0 Kudos

closed.

Answers (2)

Answers (2)

Former Member
0 Kudos

You may try:

SELECT T0.TransId, T0.Account, T1.AcctName, T0.Debit, T0.Credit, T0.RefDate, T0.BaseRef, T0.Closed, T0.Ref1, T0.Ref2, T0.Ref3Line, T0.RelType

FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode

WHERE T1.AcctName = '[%0\]' and T0.Line_ID = 1

Former Member
0 Kudos

Hi Ravi.......

Try this.....

SELECT T0.TransId, T0.Account, T1.AcctName, T0.Debit, T0.Credit, T0.RefDate, T0.BaseRef, T0.Closed, T0.Ref1, T0.Ref2, T0.Ref3Line, T0.RelType 
FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode 
WHERE (T1.AcctName = '[%0]' or '[%0]'='') and T0.[Line_ID]=2

Regards,

Rahul