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.
@AbapCatalog.sqlViewName: ‘ZFLIGHT_AVW’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@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
{
spfli.carrid,
spfli.connid,
spfli.countryfr,
spfli.cityfrom,
spfli.airpfrom,
spfli.countryto,
spfli.cityto,
spfli.airpto,
/* Associations */
_scarr
}
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
Data Preview.