Skip to Content

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

Query Help Plz

Hi experts:

I have a problem with my query, I have 2 series of billing

If I want to get a report of a single series that I only get the full amount without detail.

I am not throwing well this amount. In fact is bigger

It's just that simple add up the total of all invoices of that series, omitting the invoices canceled (with the targettype <> 14) who comes to me for being alive only bills that are not within any notes credit

This is my query:

SELECT TIPO = 'SELLOS', (SUM(T0.DOCTOTAL)) MONTO FROM OINV T0 INNER JOIN NNM1 T1 ON T0.SERIES = T1.SERIES INNER JOIN INV1 T2 ON T0.DocEntry = T2.DocEntry WHERE T0.DocDate BETWEEN [%0] AND [%1] AND T1.SeriesName = 'SELLOS' AND T0.CANCELED = 'N' and T2.TargetType <>'14'

Best regards.

Helpful Answer

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