Skip to Content
Author's profile photo Nagarajan K

Projected MRP Procurement Cost for specified MRP Scenario

Dear all,

To get projected MRP procurement cost for specified MRP scenario, just copy and paste below query into query generator.

SELECT

T1.[MsnCode] AS ‘Scenario’,

T0.[DueDate] AS ‘Due Date’,

T0.[ItemCode] AS ‘Item#’,

T2.[ItemName] AS ‘Desc’,

T0.[Quantity] AS ‘PO Qty’,

T3.[Price] AS ‘Price’,

T0.[Quantity]*T3.[Price] AS ‘AP Cost’

FROM

ORCM T0 INNER JOIN OMSN T1 ON T0.[ObjAbs] = T1.[AbsEntry]

INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode

INNER JOIN ITM1 T3 ON T2.ItemCode = T3.ItemCode

INNER JOIN OPLN T4 ON T3.PriceList = T4.ListNum

WHERE

T1.[MsnCode] =[%0] AND T4.[ListName] =[%1]

ORDER BY

T0.[DueDate]

Hope helpful.

Thanks & Regards,

Nagarajan

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.