Adding custom reference field to Data Entity Extension in D365 / AX 7

 Purpose:

The purpose of this document is to show how to add a custom reference field in the existing data entity

Business requirement:

Adding custom reference field to the existing data entity. 

Development:

To demonstrate we have added compensation level reference in HcmPositionDetail table. We need to add this field in the existing data entity HcmPositionDetailEntity. 

Step #1 Creating HcmPositionDetailEntity entity extension

Step #2 In order to add the reference field we need to add the reference data source first and creates the relation

Here in our case the data source we need to add is ‘HcmCompensationLevel’.

Step #3 Creating extension of data entity staging table. Here the staging table  is HcmPositionDetailStaging

Step #4 Adding custom field to the staging table. 

Step #5 Now build and sync the project

Step #6 You have now successfully added custom field. You can verify if the custom field added or not go to

Workspaces > Data Management > Data Entities > Search data entity > Click on Modify Target Mapping