Skip to Content

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

PurChase Tracking Report

Hi All,

I Need Purchase Tracking Report from Purchase Order To GRN .I have a Query but I want PO with GRn

and Po without Grn Details

SELECT distinct T0.[DocNum]'PO No',T4.[DocNum]'GRN No',T3.[BaseRef], T0.[DocStatus], T0.[CardCode], T0.[CardName], T0.[DocDate],

T0.[DocDueDate], T0.[NumAtCard], T0.[TotalExpns],T0.[DocTotal], T1.[ItemCode], T1.[Dscription], T1.[Quantity],

T1.[Price], T1.[LineTotal], T1.[Project], T3.[ItemCode], T3.[Dscription], T3.[Quantity]

FROM OPOR T0 , POR1 T1, NNM1 T2,PDN1 T3,OPDN T4 where T0.DocEntry = T1.DocEntry

and T0.Series = T2.Series AND T3.[BaseRef]=T0.[DocNum]and T4.Docentry=T3.Docentry

if any Modification Pls Help me



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