Skip to Content

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

Total value In query

Hi,

I have this query

SELECT T0.DocNum, T0.DocType, T0.CardCode, T0.CardName, T0.DocTotal, T0.Footer FROM OINV T0

In end of the DocTotal column i need total of document total

how to do it

Regards

srinivas

replied
SELECT T0.DocNum, T0.DocType, T0.CardCode,
 T0.CardName, T0.DocTotal, T0.Footer 
FROM OINV T0 
Union all
Select 0,'','','Total:',sum(t.doctotal),'' From OINV t 
0 View this answer in context

Helpful Answer

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