Table contains the metadata

(2) Share

Report

Posted on by LB developer

392

Dear experts,

Do you know which table contains the metadata information? Customer would like to extract some of the tables filtered by a predefined property value.

Thanks,

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Kevin Xia Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can refer to this blog: alexdmeyer.com. The article describes how to create an Excel file, which has a centralized source of information surrounding FO data entities metadata, the data sources used (both root data source and all data sources), and the way to see dependencies between different data entities. You can also refer to this official document: System tables - Finance & Operations | Dynamics 365 | Microsoft Learn. This article contains the documentation available for the System classes.

Best regards,

Kevin

Was this reply helpful? Yes No
AR-01121610-0 4,971 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hy,

as the search for data entities and related tables and fields are often time consuming I've created a entity and table search tool, it is currently based on V10.0.38.

DMF Entity Research - Power BI

May ne this helps a little bit.

Herzliche Grüße / kind regards,

Andreas Raithel

D365FO Solution Architect

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,057 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Application metadata is stored in the application layer, not in database. It means in source code files (before compilation) and .NET assemblies, runtime metadata files etc. in the actual application.

The easiest way to get tables with a particular value of a property is using Metadata search in Visual Studio. In more advanced scenarios, you can use the metadata API, which is what Alex has done in his blog post.

Was this reply helpful? Yes No