You may have seen several posts listing the Virtual tables. Most of they say you create page/form and type in one by one table id in Range (2000000001.. 2000000200) and find the Virtual Tables and note them.
Today I will demo you easy way for getting this list with no additional efforts.
You will get below table list in every posts. I have listed tables below in Nav-2015.
| Object Designer | Virtual | Itself from Virtual Table | ||||
| Type | ID | Name | Object Type | Object ID | Object Name | |
| Yes | Table | 2000000001 | Object | |||
| 1 | 2000000004 | Permission Set | Table | 2000000004 | Permission Set | |
| 1 | 2000000005 | Permission | Table | 2000000005 | Permission | |
| 1 | 2000000006 | Company | Table | 2000000006 | Company | |
| Yes | Table | 2000000007 | Date | |||
| Yes | Table | 2000000009 | Session | |||
| Yes | Table | 2000000020 | Drive | |||
| Yes | Table | 2000000022 | File | |||
| Yes | Table | 2000000026 | Integer | |||
| Yes | Table | 2000000028 | Table Information | |||
| Yes | Table | 2000000029 | System Object | |||
| Yes | Table | 2000000038 | AllObj | |||
| Yes | Table | 2000000039 | Printer | |||
| Yes | Table | 2000000040 | License Information | |||
| Yes | Table | 2000000041 | Field | |||
| Yes | Table | 2000000043 | License Permission | |||
| Yes | Table | 2000000044 | Permission Range | |||
| Yes | Table | 2000000045 | Windows Language | |||
| Yes | Table | 2000000048 | Database | |||
| Yes | Table | 2000000049 | Code Coverage | |||
| 1 | 2000000053 | Access Control | Table | 2000000053 | Access Control | |
| Yes | Table | 2000000055 | SID – Account ID | |||
| Yes | Table | 2000000058 | AllObjWithCaption | |||
| Yes | Table | 2000000063 | Key | |||
| 1 | 2000000065 | Send-To Program | Table | 2000000065 | Send-To Program | |
| 1 | 2000000066 | Style Sheet | Table | 2000000066 | Style Sheet | |
| 1 | 2000000067 | User Default Style Sheet | Table | 2000000067 | User Default Style Sheet | |
| 1 | 2000000068 | Record Link | Table | 2000000068 | Record Link | |
| 1 | 2000000069 | Client Add-in | Table | 2000000069 | Client Add-in | |
| 1 | 2000000071 | Object Metadata | Table | 2000000071 | Object Metadata | |
| 1 | 2000000072 | Profile | Table | 2000000072 | Profile | |
| 1 | 2000000073 | User Personalization | Table | 2000000073 | User Personalization | |
| 1 | 2000000074 | Profile Metadata | Table | 2000000074 | Profile Metadata | |
| 1 | 2000000075 | User Metadata | Table | 2000000075 | User Metadata | |
| 1 | 2000000076 | Web Service | Table | 2000000076 | Web Service | |
| 1 | 2000000078 | Chart | Table | 2000000078 | Chart | |
| 1 | 2000000079 | Object Tracking | Table | 2000000079 | Object Tracking | |
| 1 | 2000000080 | Page Data Personalization | Table | 2000000080 | Page Data Personalization | |
| 1 | 2000000100 | Debugger Breakpoint | Table | 2000000100 | Debugger Breakpoint | |
| Yes | Table | 2000000101 | Debugger Call Stack | |||
| Yes | Table | 2000000102 | Debugger Variable | |||
| Yes | Table | 2000000103 | Debugger Watch Value | |||
| 1 | 2000000104 | Debugger Watch | Table | 2000000104 | Debugger Watch | |
| 1 | 2000000110 | Active Session | Table | 2000000110 | Active Session | |
| 1 | 2000000111 | Session Event | Table | 2000000111 | Session Event | |
| 1 | 2000000112 | Server Instance | Table | 2000000112 | Server Instance | |
| 1 | 2000000114 | Document Service | Table | 2000000114 | Document Service | |
| 1 | 2000000120 | User | Table | 2000000120 | User | |
| 1 | 2000000121 | User Property | Table | 2000000121 | User Property | |
| 1 | 2000000130 | Device | Table | 2000000130 | Device | |
| Yes | Table | 2000000135 | Table Synch. Setup | |||
All marked as Yes in above table under Virtual column are all the Virtual Tables.
I have not type one by one in the Page/form to get this list.
The Virtual table itself in Navision lists the Virtual tables in Navision. List can be different depending on the Version of Navision you see them.
Today I will share you smart way of finding this list of Virtual tables.
Next time you need not to do so hard work to list all the Virtual tables.
Here too you need to create a list page but you will not be required to key in the id of tables one by one, in fact only one table id which will give answers to your query.
Save and execute your Page/Form.
Now go to object Designer. Copy all the tables with id in range defined above and paste in Excel.
Copy above table list in Excel side by side and compare as above table shown in beginning of the post. All those which don’t match are your Virtual tables.
So easy, if anything is available why to waste effort for same.
It always good to share what you know with community, by this way we keep learning from each other.
Stay tuned for many such Tips.
ARKSD Consultancy Private Limited 