Skip to Content

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


Can we generate a query like ....where parameters will be

1.) Order Type (Production or Purchase)

2.) Scenrio Name or Scenario Code (MRP scenrios)

and based on above two item list will come...

Please help

Former Member
Former Member replied

check this

SELECT * FROM OITM T0 INNER JOIN ORCM T1 ON T0.[ItemCode] = T1.[ItemCode] INNER JOIN [DBO].[OMSN] T2 ON T2.[AbsEntry] = T1.[ObjAbs] where T2.[MsnCode] = [%0] AND T1.[OrderType] = 'P'

Hopw this will work

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question