Skip to Content

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

AP Invoice Query

hi all,

I need to write a query for AP invoice and group by vendor, my query look like got problem:

SELECT T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[VatSum] FROM OPCH T0

WHERE T0.[DocDate] Between [%1] AND[%2]

GROUP BY T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[VatSum]

I need the query group by vendor total amount without the tax figure or any report in sapb1 I can get my results? thanks!

hooi

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