ABAP CDS on HANA-11

cdsAssociation 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.

1


@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.

2


To add particular field of association _scarr, it can be added by the alias name and dot followed by field name

3

Data Preview.

4


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s