Skip to Content
0
Mar 03, 2011 at 07:26 AM

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

18 Views

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