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?

All responses (3)

Answers (0)

Martin Dráb 230,605 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.
André Arnaud de Cal... 291,904 Super User 2024 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.
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?