cancel
Showing results for 
Search instead for 
Did you mean: 

Report or Query for Receipt for Production without Issuing

Former Member
0 Kudos

Hello,

I am looking for an query in SAP-B1 which will provide me the daywise detail of Receipt for Production done without Issuing Material or Shortage of Material Issued.

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this:

SELECT T0.[DocNum], T0.[Status], T0.[PlannedQty], T0.[CmpltQty], T1.[IssuedQty] FROM OWOR T0  INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[Status] = 'r' and  T0.[CmpltQty]  >0 and  T1.[IssuedQty]  = 0

Thanks & Regards,

Nagarajan