Hi, Readers.
Today I would like to share another mini tip about Business Central, how to quickly check whether the table is a system table in AL.
We briefly discussed System tables, Virtual tables and Virtual tables (entities) in Dataverse before. As mentioned in the post, Microsoft does not provide MS Learn (Docs) about the System tables, but we can find some instructions from the link below.
Table extensibility limitations:
System and virtual tables can’t be extended. System tables are created in the ID range of 2.000.000.000 and above. For more information about object ranges, see Object ranges.
Table object – Business Central | Microsoft Learn

So we can just simply check from the table id, but is there any standard method? Yes, in the Configuration Package feature, when you add the system table, the following error is displayed,
You cannot use system table 2000000006 in the package.

This is a standard control.


So we can also use this method.
codeunit 8616 “Config. Management” -> procedure IsSystemTable

Let’s look at a very simple example.


PS: Dynamics 365 Business Central: How to get table ID and table name of the opening page via AL
Very simple, give it a try!!!😁
END
Hope this will help.
Thanks for reading.
ZHU
コメント