Skip to main content
Microsoft Dynamics NAV forum
Unanswered

Access to backend table structure/mapping/ERD in NAV?

editSubscribe (0) ShareShare
ReportReport
Posted on by 25

Hi All,
I would like to access/see the backend tables along with the relationship with other tables in NAV. Ideally an ERD (Entity Relationship Diagram) would be great, is there a way I can do this using the Navigator interface or SQL Server/SSMS?

Background: I am trying to mimic pre existing Jet Reports and for that it is important for me to understand the tables and mappings. I have access to SQL server database, but there are thousands of tables and it is almost impossible to go thru each table.
Any help is much appreciated!!

Thank you.

  • RE: Access to backend table structure/mapping/ERD in NAV?

    Hi,

    Good question and one we do get asked now and then. However, NAV has +1400 tables that are all connected in one way or the other, and also some relations are to different tables depending on conditions. Many relationships are defined in C/AL code. In the past there has been some different tools like Navision Developers Toolkit, but at the moment there are no tools that I know off. If there was, then also the diagram would be an enormous web of 1400 tables connected depending on setup (is MRP / HR / SCM / etc used).

    So, in short, sorry there is no tool like this at the moment, unless some partners know otherwise, then please share here.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans