Business Partner Personnel number CDS view

[Ekaterina_Levi]

Dears,

Please advise what CDS view can i use to extract Business Partner Personnel numbers together with Business Partner number and Name

Ekaterina

Ekaterina

[Jerry_Lowery]

Hi !

You probably need to be looking at the work force agreement views

For example I_PersonWorkAgrmtToExternalID has the personnel id - but it doesn't necessary map to BP Id

In the view browser, if you search the advanced search settings for Column Name with "Personnel Number" you get ~400 views - might want to simplify to "Personnel". 

BUT a lot of those are not released. 

You can look into a custom cds view with the following data sources

You might be hitting up against some GDPR restrictions as well

Thank you

Jerry

[Ekaterina_Levi]

Hi Jerry,

[Ekaterina_Levi]

Hi Jerry, thank you for your feedback, i used I_BuPaIdentification CDS view and it worked. Ekaterina