Association in ABAP CDS
An association in CDS view joins different data sources. Defining and using associations is a high-value wrapping of the syntax for joins.
A CDS View with association between SPFLI & SCARR table.
@EndUserText.label: ‘Flight CDS View with association’
define view Zflight_Asso_Vw
as select from spfli
association [1..1] to scarr as _scarr
on $projection.carrid = _scarr.carrid
/* Associations */
Data Preview- No particular field of _SCARR added to the select . So in data preview only fields of spfli table are shown.
To add particular field of association _scarr, it can be added by the alias name and dot followed by field name