Share via


Tables, Views, and Maps

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

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 table describes these elements.

AOT element

Description

Tables

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:

  • 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.

Tables are specified at AOT > Data Dictionary > Tables.

Views

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.

Maps

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.

In This Section

Tables Overview

Temporary Tables and the TableType Property

Table Inheritance Overview

Valid Time State Tables and Date Effective Data

Manipulation of Data in Tables

Record Level Security

How to: Define and Modify Table Methods

Map Overview

View Overview

See also

Database for Microsoft Dynamics AX

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.