cancel
Showing results for 
Search instead for 
Did you mean: 

how to get purchase order info from inspection

former_member200567
Active Contributor
0 Kudos

Hi experts,

I am trying to retrieve purchase order information from inspection.

But the only information I can get from MaterialInspection business object is Warehouse Order ID. And unfortunately, I cannot find any relation between Warehouse Order ID and Purchase Order.

Please suggest.

Best Regards,

Fred

Accepted Solutions (0)

Answers (2)

Answers (2)

arunml
Advisor
Advisor
0 Kudos

Hi Fred,

Could you please try the below approach?

In Business Object Material Inspection - MIN_MATERIAL_INSPECTION -> Under ROOT -> There is a BUS_TRANS_DOC_REF BusinessTransactionDocumentReference NODE ROOT -> Can you try to search based on Reference Type 001 -Purchase Order Item?

Best Regards,
Arun


former_member200567
Active Contributor
0 Kudos

Hi Arun,

Thanks, will check it out.

Best Regards,

Fred

Former Member
0 Kudos

Hello Fred,

Purchase Order information is retrieved from the Business Object WarehouseRequest and it is not stored in Inspection or WarehouseOrder.

Here are the steps to navigate to get Purchase Order Information:

1)Navigate from BO : Material Inspection Node:Root to

Node:Business Transaction Document Reference using association

BusinessTransactionDocumentReference.

2)Navigate from here to the BO WarehouseOrder Node:Root using association SiteLogisticsLot.

3)Navigate from here to the BO WarehouseRequest Node:Segment using association SiteLogisticsRequestSegment.

4)Navigate from here to Node: Root of WarehouseRequest using association ToRoot.

5)Navigate form here to Node: BusinessTransactionDocumentReference using association BusinessTransactionDocumentReference.

6)Here you will get the reference of PurchaseOrder. We store Purchase Order ID. There may be multiple references present here. You can filter for Purchase Order where the

BusinessTransactionDocumentReference-Type code is '1' or '001'.

We suggest retrieving purchase order using the alternative key ID stored as

BusinessTransactionDocumentReference-ID.

Regards,

Ajay V Reddy

former_member200567
Active Contributor
0 Kudos

Hi Ajay,

Thanks, will try that out.

Best Regards,

Fred