Query Report PO

[Former Member]

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

[Former Member · Accepted solution]

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

[former_member187989]

SELECT T2.FrgnName, T1.ItemCode, T0.CardCode, T0.DocDate, T1.Quantity, T0.DocTotal FROM OPOR T0  INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T0.DocDate BETWEEN '[%0]' AND
'[%1]'

Jeyakanthan