In CDS, an association represents the relationship between two CDS views.
You use associations to:
In addition, you can also open the Data Preview view from the source code editor of a DDL source. Then choose from the context menu.
The Data Preview tool appears and displays the top 100 records by default.
You can also choose > in the breadcrumb bar to follow an association.
Associations defined for the CDS view are listed.
The Data Preview tool displays the result set for the selected association. You can apply filters to the current result set or use the breadcrumb to navigate to the previous result set.
You can use the SQL Console option on the Data Preview menu to view the generated Open SQL query for an association. The generated query uses the SQL view to display records.