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)

Sort by

DC-23081429-0 8 on at

Like (1)

Report
Copy link

Link copied!

Is anyone able to help with this please?

Was this reply helpful? Yes No
André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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
Martin Dráb 239,632 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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