Skip to Content

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

Query Report PO

Hi Experts,

Is it possible to get full flow of purchase order: from Purchase order to A/P Credit memo.

Item foreign name,Itemcode,Cardcode,Docdate,Quantity,Total.e.t.c..

In SAP Purchase analysis report : Item Foreign name not included so i need to write separate query. can any one help me regarding this ..query.

kart

replied

Please check if you are looking this kind of query:

Select t2.frgnname,t0.itemcode, t1.cardcode as Vendor#, sum(t0.quantity) 
as Quantity, sum(t0.LineTotal) as Amount
from pch1 t0
inner join opch t1 on t1.docentry = t0.docentry
Inner Join oitm t2 on t2.itemcode = t0.itemcode
where t1.DocType = 'I' and T1.DocDate between '[%0]' and '[%1]'
Group By t2.frgnname,t0.itemcode, t1.cardcode

This is based on A/P invoice. If this meets your need, all other A/P documents have exact query format.

Thanks,

Gordon

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