Extend employee details (custom fields / in-app / side by side)

[Expert]

Hi,  I would like to extend the employee details with custom fields.  I tried the following this to achieve this:  - Custom business objects with a CDS viewThe custom business object has been used for the custom fields and the CDS (API) view is used to join theI_PersonWorkAgreement_1 data. This would be a perfect solution, but cds data is not editable.  - 2 different datasources in WebIDE1 datasource to get the custom fields data (external database with custom fiedls only) and 1 datasource to get the employee data (I_PersonWorkAgreement_1 for example). I am able to expose those datasources, but i couldnt figure out how to join these tables within the Web IDE  - Adding custom fields to a SAP application with employee detailsThe employee fact sheet application is the only application with employee data. However, the employee fact sheet application is not editable to add custom fields.  Is there another way to achieve this within the SAP architecture?  

[SreekanthKrishn · Accepted solution]

Hi,

We have a similar requirement and we achieved this by:-

1. Create CBO for custom fields.

2. Create a wrapper CDS view joining hte standard HR view I_PersonWorkAgreement and the CBO view.

3. Expose this wrapper view as API which can be consumed in WEBIDE.

Thanks

Sreekanth

[Former Member · Accepted solution]

Is it possible to edit the data? Since you're using a cds view

[SreekanthKrishn · Accepted solution]

yes, Edit it in the CBO.

[Former Member · Accepted solution]

Thank you for your reply. Edit in the CBO is possible, however the CBO will only show the custom fields and not the fields from I_PersonWorkAgreement, which makes editing hard, in this case.

[Former Member · Accepted solution]

Thanks again, a side by side extension is possible, like a fiori app. But the fiori app uses the cds view as datasource (joining Personworkagremeent and CBO), which means not possible to edit the data in the fiori app

[SreekanthKrishn · Accepted solution]

yes True. If thats what you need to acheive, then you need to craete a side by side extension for this.

[SreekanthKrishn · Accepted solution]

Side by side extensions (FIORI) can access APIs which will support CRUD operations. So you will be able to edit as well.