S_Connections

DDL: S_CONNECTIONS SQL: S_ConnectionsV Type: view

Flight Connections

S_Connections is a CDS View that provides data about "Flight Connections" in SAP S/4HANA. It reads from 1 data source (spfli) and exposes 21 fields with key fields CarrierId, ConnectionId. It has 6 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
spfli spfli from

Associations (6)

CardinalityTargetAliasCondition
[1] S_Carrier _Carrier $projection.CarrierId = _Carrier.CarrierId
[*] S_Flights _Flights $projection.CarrierId = _Flights.CarrierId and $projection.ConnectionId = _Flights.ConnectionId
[1] S_Airports _FromAirport $projection.AirportFrom = _FromAirport.AirportId
[1] S_CityAirport _FromCity $projection.AirportFrom = _FromCity.AirportId and $projection.CityFrom = _FromCity.City and $projection.CountryFrom = _FromCity.Country
[1] S_Airports _ToAirport $projection.AirportTo = _ToAirport.AirportId
[1] S_CityAirport _ToCity $projection.AirportTo = _ToCity.AirportId and $projection.CityTo = _ToCity.City and $projection.CountryTo = _ToCity.Country

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName S_ConnectionsV view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Flight Connections view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CarrierId carrid
KEY ConnectionId connid
CountryFrom countryfr
CityFrom cityfrom
AirportFrom airpfrom
CountryTo countryto
CityTo cityto
AirportTo airpto
FlightTime fltime
DepartureTime deptime
ArrivalTime arrtime
Distance distance
DistanceUnitId distid
FlightType fltype
ArrivalsDays period
_Carrier _Carrier
_Flights _Flights
_FromAirport _FromAirport
_FromCity _FromCity
_ToAirport _ToAirport
_ToCity _ToCity 
@AbapCatalog.sqlViewName: 'S_ConnectionsV'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Flight Connections'
define view S_Connections as select from spfli
association [1]    to S_Carrier    as _Carrier   on $projection.CarrierId =  _Carrier.CarrierId
association [*]    to S_Flights    as _Flights  on $projection.CarrierId =  _Flights.CarrierId 
                                                     and $projection.ConnectionId = _Flights.ConnectionId
association [1]    to S_Airports           as _FromAirport      on $projection.AirportFrom =  _FromAirport.AirportId
association [1]    to S_CityAirport        as _FromCity  on $projection.AirportFrom =  _FromCity.AirportId and $projection.CityFrom = _FromCity.City and $projection.CountryFrom = _FromCity.Country 
association [1]    to S_Airports           as _ToAirport      on $projection.AirportTo =  _ToAirport.AirportId
association [1]    to S_CityAirport        as _ToCity  on $projection.AirportTo =  _ToCity.AirportId and $projection.CityTo = _ToCity.City and $projection.CountryTo = _ToCity.Country
{

  key carrid as CarrierId, 
  key connid as ConnectionId, 
  
  countryfr as CountryFrom, 
  cityfrom  as CityFrom, 
  airpfrom  as AirportFrom, 
  
  countryto as CountryTo, 
  cityto    as CityTo, 
  airpto    as AirportTo,  
  
  fltime    as FlightTime ,   
  deptime   as DepartureTime, 
  arrtime   as ArrivalTime, 
  distance  as Distance, 
  distid    as DistanceUnitId, 
  fltype    as FlightType, 
  period    as ArrivalsDays,
  _Carrier,
  _Flights,
  _FromAirport,
  _FromCity,
  _ToAirport,
  _ToCity
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SPFLI"
],
"ASSOCIATED":
[
"S_AIRPORTS",
"S_CARRIER",
"S_CITYAIRPORT",
"S_FLIGHTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More