Skip to Content

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

Sum of Doctotal in Query Generator

Hi All,

I am currently trying to create a query that has the total of all documents per customer but am having trouble trying to figure out how to calculate. Currently I have:

SELECT T0.[CardCode], T0.[CardName], T1.[City], T1.[State], T2.[DocNum], T2.[DocDueDate], T2.[DocTotal] FROM OCRD T0  INNER JOIN CRD1 T1 ON T0.CardCode = T1.CardCode INNER JOIN ORDR T2 ON T0.CardCode = T2.CardCode

Please help!

Thank you!

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