Skip to Content

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

need oact.acctname in report

i creating report on GL but havent get OACT.ACCTNAME IN QUERY . it gives only first row data.

find attachment for your reference

query as below

                

SELECT DISTINCT T0.[DocNum], T0.[DocType], T0.[DocDate], T0.[Comments], T0.[CardName], T0.BPACT, T0.[NoDocSum] , T0.[TransId] ,T0.DOCTOTALSY,T3.SERIESNAME,T0.JRNLMEMO,T4.REF3,T5.DEBIT FROM OVPM T0  INNER JOIN OACT T1 ON T0.CashAcct = T1.AcctCode INNER JOIN OJDT T4 ON T0.TransId = T4.TransId INNER JOIN [dbo].[JDT1]  T5 ON T4.TransId = T5.TransId

INNER JOIN nnm1 T3 ON T0.SERIES = T3.SERIES WHERE T3.SERIES IN ('167','115','172 ',' 114')

Former Member replied

Hi,

Try:

SELECT DISTINCT T0.[DocNum], T0.[DocType], T0.[DocDate], T0.[Comments], T0.[CardName], T0.BPACT, T0.[NoDocSum] , T0.[TransId] ,T0.DOCTOTALSY,T3.SERIESNAME,T0.JRNLMEMO,T4.REF3,T5.DEBIT, T1.AcctName

FROM OVPM T0

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

INNER JOIN [dbo].[JDT1] T5 ON T4.TransId = T5.TransId

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

INNER JOIN nnm1 T3 ON T0.SERIES = T3.SERIES

WHERE T3.SERIES IN ('167','115','172 ',' 114')

Thanks,

Gordon

1 View this answer in context

Helpful Answer

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