Production Order Query

[Former Member]

Hi Experts,

Please Help me with query for to display

Production Order components with out back flush items.

[former_member212181 · Accepted solution]

Hi Anil,

Please try below query

[former_member212181 · Accepted solution]

Sorry for Last  message, There is some issue with my browser, iam not able to post queries

Please find the attached file for quesy

Production Order.txt.zip

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT T0.[Status], T0.[DocNum], T0.[PostDate], T0.[CardCode], T1.[ItemCode] FROM OWOR T0  INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[IssueType] != 'B'

Thanks.