Production Material Request (PMR) CDS not available

[SAPSupport]

Dear all,

"I_EWM_ProdnMatlReqItem" CDS view is not released.We're trying to find an alternative one. The requirement is to get PMR starting from ManufacturingOrder.We found "I_EWM_OutbDelivOrdItem" but not able to get PMR starting from ManufacturingOrder.Could you please suggest one CDS view to get PMR number according to a selected ManufacturingOrder?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear SAP Community,

Please check my feedback on the matter:

1. Information via production material request:
   1. I_EWM_ProdnMatlReqHeader: Is not released. Does not hold production orders. Cannot be used.
2. Information via single order picked stock:
   1. I_EWM_PhysStockProd: Holds the stock and the link to the PMR document (Document number). 
   2. api_whse_physstockprod: Gives the same information as the CDS
3. Information via warehouse tasks:
   1. I_EWM_WarehouseTask_2: Does hold the production order and the document ID of the production material request. The document number link is missing.
   2. api_warehouse_order_task_2: Is giving less information. The link with PMR document ID is not present.
4. Information via production order
   1. I_manufacturingOrder: Does not hold info on PMR.
   2. I_manufacturingOrderitem: Does not hold info on PMR.

If you want to get for exemple the physical stock with a manufacturing order, the only way is to:

• Make use of the I_EWM_WarehouseTask_2 to retrieve PMR reference(DocumentReltdStockDocUUID : Document ID and DocumentReltdStockDocItemUUID : Item ID) with manufacturing order.
• The next step is to use I_EWM_PhysStockProd to read physical stock with the fields:  EWMStockRefDocumentUUID & EWMStockRefDocItemUUID and EWMDocumentCategory as the stock reference is the same for physical stock and warehouse tasks.

Best regards,

Geovana