Virtual Tables in Dynamics NAV

Virtual Table : This tables store system provided information. You can use this tables as normal table , the difference is that you cannot change the information present in Virtual tables ie. Virtual Tables are only readable. Another difference is that, This tables are computed at runtime instead of storing in database as normal tables does.

Some of the Important Virtual Tables are :

Date, Integer, File, Drive, Monitor, Session, Database File, Table Information, Field, Server, Windows Object, Windows Group Member, SID - Account ID, User SID.

Table ID's range:

• 2000000001 – 2000000203 In Dynamics Nav 2009 R2
• 2000000001 – 2000000130 In Dynamics Nav 2013 R2

Information provided by virtual tables:

• Integers in the range – 1.000.000.000 to 1.000.000.000.
• Dates within a given period.
• An overview of the operating system files.
• An overview of the logical disk drives.
• A trace of database requests from your client to the database.
• An overview of the users that are currently connected to the database.
• An overview of the operating system files that store the database.

How to use Virtual tables :

To view information from these virtual tables you can 

• Create a "Form" with data source as a "Virtual Table" in Nav 2009 R2
• Create a "Page" with  data source as a "Virtual Table" in Nav 2013 R2

Example :  You can find Virtual table in Dynamics Nav 2009 R2, Here 

• Go to "File" >> "Database" >> "Information"

• Go to "Sessions" Tab then Lookup in "Current Sessions" Value

 You will find a Form "Database Sessions" reflecting "Sessions" table (Virtual Table).

As shown below :

Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.


Thanks for Reading,

Shubin Dongre