Query Report PO
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.
Gordon Du 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.