on 01-06-2015 10:24 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.