Skip to Content

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

Inner join - OACT into query

How do I inner join OACT table ( acctcode) into this formula?

SELECT T0.[DocNum],T0.[CardCode], T0.[CardName], T0.[Address], T0.[DocStatus], T0.[NumAtCard], T1.[Dscription], T1.[VatSumSy], T1.[LineTotal], (T1.[LineTotal] + T1.[VatSumSy]) AS 'Row Total Incl Tax' FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry

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