Request for CDS view to deduce the FAUF number from the PMR number

[SAPSupport]

Due to our physical production conditions, our process provides for the implementation of an SST between SAP DM and S4H WM. This should first scan an HU, which is provided to the machine fully automatically on an order-related basis, and then read the material number and batch from SAP DM using the Get Retrieve HU API.
Furthermore, we must ensure on the process side that a provided KLT is actually consumed on the corresponding production order (FAUF), as there is no longer any manual intervention. 

SAP DM requires the FAUF so that it can post the consumption. The PMR number is obtained from the WM via the Get Physical Stock API. Our question is:

How can we deduce the FAUF number from the PMR number?
Is there a CDS view or an API that can be used for this?

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

[SAPSupport · Accepted solution]

Please join CDS view I_EWM_PhysStockProd and I_EWM_WarehouseTask_2 to get the EWMStorageBin from stock view based on condition like below:

           ProductName         = <RMXXX>

and    StockView.EWMStockReferenceDocCategory  = WarehouseTaskView.EWMReferenceDocumentCategory            = PWR

and    StockView.EWMStockRefDocumentUUID         = WarehouseTaskView.EWMWarehouseRequestUUID

and    StockView.EWMStockRefDocItemUUID             = WarehouseTaskView.EWMWarehouseRequestItemUUID

and    WarehouseTaskView. ProductionOrder            = <PPO number>

[oumaimayahyaoui · Accepted solution]

Hello,

Could you give us the api that retrieve the batch number, its Material and its manufactoring order , I tried these two :

Warehouse Physical Stock by Product - Read, Update (A2X)

Warehouse Order and Task (A2X)

but it does not give me the manufactoring order

do have an idea ?