It is possible to access this table with Business Central On-Premises, but not with Business Central Public Cloud. We have received some information back from Microsoft explaining that this table is not exposed for BC Public Cloud as it may contain cross-tenant data.
It is possible to access some of the metadata tables such as 2000000136 "Table Metadata" and 2000000141 "Table Relations Metadata", and this offers some information, but it is not as comprehensive and there are some gaps as described above.
In a similar way, we are also unable to access non-English versions of captions and option strings
Comments
This is needed. We made this post in 2019:
https://github.com/microsoft/AL/issues/5512
Category: Development
One suggestion/refinement to this idea: if Microsoft is not keen on exposing this table due to cross-tenant security concerns, perhaps the key properties it holds could be provided in some new AL functions. For example, Rob's example of seeing the CalcFormula for flow fields could be provided via a new property/method on the FieldRef data type?
If more convincing is needed... having the CalcFormula available for extensions would be very helpful for 2 reasons:
1) performance investigations (being able to identify the underlying CalcFormula being executed when we call fieldRef.CalcField and find this to be a bottleneck)
2) user experience - being able to show this CalcFormula to users so they understand how the value has been calculated.
Category: Development
It seems Table Relations Metadata are also notably missing the filters on table relations, and multiple other developers are bemused by that:
* https://www.yammer.com/dynamicsnavdev/threads/1160835072
* https://www.yammer.com/dynamicsnavdev/threads/1257336580669440
Category: Development
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team