Advanced Considerations for Views [AX 2012]
Updated: October 7, 2011
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This topic describes advanced considerations about view objects in Microsoft Dynamics AX.
A company-specific table has its SavePerCompany property set to Yes. And it has a DataAreaId column which stores the company code. A global table has no DataAreaId column.
The first data source on a view can be a global table. The global table can be joined with a company-specific table as the second data source. In this case, the company-specific table is also treated as a global table. This treatment as global means that the view will have no DataAreaId column that is automatically added to the view by the system.
In versions prior to Microsoft Dynamics AX 2012, it was not possible to have this configuration of a global table joined by a company-specific table.
Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. get your copy at the MS Press Store