How to view the breakdown of how an entity is created from the tables that form it?

(2) Share

Report

Posted on by DC-23081429-0

Hello,

I was wondering if anyone would be able to help me with the below (or point me in the right direction). I'm looking to bring out the entity 'EcoResProductAttributeValueV3Entity' in D365 F&O through the Azure Synapse Link. Now because I can't enable change tracking on this entity I need to bring out all the constituent tables and then re-create this entity as a view and store it in Fabric for further manipulation.

Is there a tool or way that I can view how all the joins behind the scenes are created to pull this entity together?

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 235,796 Most Valuable Professional on at

Like (2)

Report

How to view the breakdown of how an entity is created from the tables that form it?

Another option is installing AOT Browser, which gives you a plenty of information directly in GUI, therefore you don't need a development environment. But I don't remember what exactly it says about joins.

Was this reply helpful? Yes No
André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (1)

Report

How to view the breakdown of how an entity is created from the tables that form it?

Hi,

If you have access to a development environment, you can go to the object definition of the data entity and see which tables and joins are used. You can see this in the data sources node. Note that data entities can have specifics where behavior like filling fields or setting ranges are managed by X++ logic. This also needs to be checked, next to the tables used.

Was this reply helpful? Yes No
DC-23081429-0 8 on at

Like (1)

Report

How to view the breakdown of how an entity is created from the tables that form it?

Is anyone able to help with this please?

Was this reply helpful? Yes No

Community site session details

How to view the breakdown of how an entity is created from the tables that form it?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to view the breakdown of how an entity is created from the tables that form it?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates