Skip to Content

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

error group by

hello everyone,

i've a syntax problem in this query, i can't be able to find the error. i want to calculate subtotal with function group by ROLL UP, but THE FUNCTION GROUP BY doesn't work. Can anybody help me? thank you

SELECT T2.CardName, T1.CardName, T0.U_DtInMan, T0.U_DtRiMan, T0.U_ImpMan, 13 - month(T0.[U_DtInMan]) AS Mesi_manutenzione, (T0.[U_ImpMan] * (13 - month(T0.[U_DtInMan])) /12) AS importo_annuale_manutenzione FROM OINV T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode INNER JOIN OCRD T2 ON T0.FatherCard = T2.CardCode WHERE T0.U_ImpMan <> 0 and T0.U_DtRiMan >=[%0] and T0.U_DtRiMan <=[%1] GROUP BY T2.CardName WITH ROLLUP

Former Member
replied

I would like to get some idea about what the calculation is for and what you are trying to do. I might probably be able to help you after understand your requirement.

Suda

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