Skip to Content

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

Goods Receipt Query

Hello -

We have this Query to show us when we have received products into stock. But, it doesn't seem right. The date is not right. Think it is linked to wrong doc...please check anyone!

Thanks!

Mike

SELECT T0.BASEREF [PO#], T0.ITEMCODE [Item#], T0.DOCDATE [Receipt Date], T0.QUANTITY [Receipt Qty], T0.PRICE [Cost]

FROM [DBO].[PDN1] T0

replied

Mike,

Try this:

SELECT T0.BASEREF PO#, T0.ITEMCODE Item#, 
T1.DocDate 'Receipt Date', 
T0.QUANTITY 'Receipt Qty', T0.PRICE Cost
FROM DBO.PDN1 T0
INNER JOIN DBO.OPDN T1 ON T1.DocNum = T0.DocEntry
Where T0.BASEREF is not NULL and T0.ITEMCODE is not 
NULL

Thanks,

Gordon

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