list of PO with WBS, customer and service performer

[Expert]

Hello,  We are using professional services and we are creating a lot of PO for contingent worker and for licensing. In the app Monitor Purchase Order item, we can have the service performer information. I am looking to have a list of PO with the WBS element and te customer number. How to you proceed to find the PO that was created for your project ?  Pascale

[Expert · Accepted solution]

Hi ‎@Pascale Schäkel

I did not try.

But I think you may try to create the query based on following CDS views.

I_PURORDACCOUNTASSIGNMENTAPI01 ( PURCHASEORDER, WBSELEMENTINTERNALID ) >> I_WORKPACKAGEWORKITEM (WORKPACKAGE, ENGAGEMENTPROJECT) >> I_ENGAGEMENTPROJECTATTRIBUTE (ENGAGEMENTPROJECT, CUSTOMER)

From the 1st CDS view, you can get the WBS ID for the PO. From the 2nd CDS view, you can get the project ID for the WBS . From the last CDS view, yon can get the customer number for the project ID.

Thanks and regards,

Corey

[Expert]

This is a re-posted Q&A of an earlier question on this community