ABAP CDS ON HANA-(11)ABAP CDSでの関連付け

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.

---