Skip to Content

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

Transaction Journal Report

Dear All,

Anyone can help me how to display journal number into transaction journal report?

Thanks,

Saufil

Former Member replied

Hi Saufil,

If you remove Where Condition from the above query then it should work.

OrĀ  try this

SELECT T4.SeriesName, T3.Number, T0.TransId,

CASE WHEN T1.LocManTran = 'Y' THEN T0.ShortName ELSE T1.[FormatCode] END as 'Account Code',

CASE WHEN T1.LocManTran = 'Y' THEN T2.CardName ELSE T1.AcctName END as 'Account Name',

T0.[Debit], T0.[Credit], T3.Memo as 'Remarks'

FROM JDT1 T0

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

LEFT JOIN OCRD T2 ON T2.CardCode = T0.ShortName

INNER JOIN OJDT T3 ON T3.TransId = T0.TransId

INNER JOIN NNM1 T4 ON T4.Series = T3.Series

ORDER BY T0.TransId

Thanks,

Rahul

0 View this answer in context

Helpful Answer

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