Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

Creating a view with a query and computed columns

Views are great high-performance ways to bring data from multiple tables together. We can start with a query and then add fields from that query to a field list in order to create a view that is then created in SQL and is usable as a read-only table anywhere in SCM.

This is great for fact panes, reports, and inquiries. Although we will only cover a simple view in this recipe, the key point is to show how we can create view methods that are used as computed columns in the view. Just like we could add a display method to a table, which is then used in a form, we can also do this in a view. The difference is that the work is done by the SQL Server and comes with two big advantages: they are much ...