CDS views for Manage Workforce app SAP Public Cloud 2502

[vk36]

Hi,

In order to export employee master, we have to refer to multiple CDS views. Infact, I checked multiple CDS views in Customer Data Browser app but email id is missing in all of them. I need to know if there is any standard CDS view which contain all the fields including email id of the employee. 

Downloading multiple CDS files and then compiling is becoming a task now. Please help.

[IreneLiu]

Hi @vk36 

If you want to get email address information based on Person External ID(Worker ID) via CDS view, then you need to create a custom CDS view with I_WorkforcePerson and follow the association to get Workplace information.

Or if you are using Business partner i.e. Employee business partner number to fetch email address information, then you can directly use I_BusinessUserBasic which would give both Business User and the workplace related information like email address.

Alternatively you can also check I_WorkplaceAddress but a BP GUID is needed for this CDS view.

For documentation of those CDS views, kindly search in the help page CDS Views.

Best regards,
Irene