Monday, 31 December 2012

Microsoft Dynamics AX 2012 - Tables, Views, and Maps

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:
  1. Method members - A table can have methods, just as a class in X++ or C# can have methods.
  2. Table inheritance - A table can extend, or be derived from another table. That same table can be the base table for several derived tables.
  3. Valid time state - A table can be configured to track data relationships for specific date-time spans.
Tables are specified at AOT > Data Dictionary > Tables.
  • 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.
A query can use tables, views, or maps for its data sources. Queries are specified at AOT > Queries.

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