Skip to Content
avatar image
Former Member

Report or Query for Receipt for Production without Issuing

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jan 06, 2015 at 11:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded