Skip to Content

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

Goods Receipt Query

This question is answered

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

Former Member
October 14, 2008 at 01:15 AM
0 Likes
Correct Answer
Former Member replied
October 14, 2008 at 01:15 AM

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 Likes 0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question

2 replies