Hi all, need an query in AP invoice

[Former Member]

Dear sap experts,

we are using sap 9.0 and pl 08.

I need an query in AP invoice following

From A/P invoice, Posting date,Vendor name,Vendor reference number,Item number,Item description,total before tax,tax amount,total value invoice,

project name,division, Project, share & for line item after qty & unit price, Excise duty amount, Vat/CST amount, TDS amount & total bill value.

From the month april(2015) to may(2016)

whole year dump status.....

Please help me to generate this report...

Thanks.

Message was edited by: Peter Hartwich

[kothandaraman_nagarajan]

Hi,

Please try this query,

SELECT T0.[DocNum], T0.[DocStatus], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price], T1.[LineTotal], T1.[LineVat] FROM OPCH T0  INNER JOIN PCH1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.[DocDate] between [%0] and [%1] GROUP BY T0.[DocNum], T0.[DocStatus], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price], T1.[LineTotal], T1.[LineVat]

Thanks