Tables, views, and maps are elements that X++ SQL statements can
reference to read and write business data. These elements are specified
in the Application Object Tree (AOT) under AOT > Data Dictionary.
The following describes these elements.
- AOT element: Tables
Description: Tables store business data. Each table in the AOT has a corresponding table in the underlying Microsoft SQL Server database.
In Microsoft Dynamics AX, tables have advanced features beyond what tables might have in the underlying database. The advanced features include the following:
Tables are specified at AOT > Data Dictionary > Tables.
- Method members - A table can have methods, just as a class in X++ or C# can have methods.
- Table inheritance - A table can extend, or be derived from another table. That same table can be the base table for several derived tables.
- Valid time state - A table can be configured to track data relationships for specific date-time spans.
- AOT element: Views
Description: A view is an X++ SQL select statement that is given a name that is reusable in other X++ SQL statements. The select statement of the view can reference one table, or it can join tables. Also, a view can reference other views, or a mix of views and tables. A view can also reference maps.
Developers are encouraged to consider using an AOT query element as the source of data for their view.
Views are specified at AOT > Data Dictionary > Views.
- AOT element: Maps
Description: A map can unify the access to similar columns and methods that are present in multiple tables. You associate a map field with a field in one or more tables. This enables you to use the same field name to access fields with different names in different tables. Methods on maps enable you to create or modify methods that act on the table fields that the map references.
Maps are specified at AOT > Data Dictionary > Maps.
My above blog is based on Microsoft's Official information.
I
hope this blog about 'Microsoft Dynamics AX 2012 - Tables, Views, and Maps' was
informative.
Please feel free to leave your
comments.
No comments:
Post a Comment