[CDS VIEW] INNER JOIN的例子

HANA CDS View inner join的例子

@AbapCatalog.sqlViewName: 'Z_JOIN_1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'JOIN LEARNING'
define view Z_JOIN_TEST as select from spfli inner join scarr
on spfli.carrid = scarr.carrid
{
    scarr.mandt as Mandt,
    scarr.carrid as Carrid,
    scarr.carrname as Carrname,
    scarr.currcode as Currcode,
    scarr.url as Url,
    spfli.connid as Connid,
    spfli.countryfr as Countryfr,
    spfli.cityfrom as Cityfrom,
    spfli.airpfrom as Airpfrom,
    spfli.countryto as Countryto,
    spfli.cityto as Cityto,
    spfli.airpto as Airpto,
    spfli.fltime as Fltime,
    spfli.deptime as Deptime,
    spfli.arrtime as Arrtime,
    spfli.distance as Distance,
    spfli.distid as Distid,
    spfli.fltype as Fltype,
    spfli.period as Period
}