S_Connections

Flight Connections | view: S_CONNECTIONSV | Extraction: Not supported | Component: ABAP Syntax, Compiler, Runtime
Tables used: SPFLI
Column Name Description
CarrierId FK Airline Code
ConnectionId Flight Connection Number
Column Name Description
Column Name Description
📏 Mass unit of distance (kms, miles) (DistanceUnitId):
Distance Distance
Column Name Description
DepartureTime Departure time
ArrivalTime Arrival time
Column Name Description
FlightType Flight type Show values
Column Name Description Domain name
FlightTime Flight time S_DURA
ArrivalsDays Arrival n day(s) later INT1
Master Data Relations Join Conditions
Check against airport
  • ?
  • Departure airport
  • S_CONNECTIONS.[column in domain "S_MANDT"] == SAIRPORT.MANDT
  • S_CONNECTIONS.AIRPORTFROM == SAIRPORT.ID
Check against airport
  • ?
  • Destination airport
  • S_CONNECTIONS.[column in domain "S_MANDT"] == SAIRPORT.MANDT
  • S_CONNECTIONS.AIRPORTTO == SAIRPORT.ID
Check Against Airline
  • ?
  • Airline Code
  • S_CONNECTIONS.[column in domain "S_MANDT"] == SCARR.MANDT
  • S_CONNECTIONS.CARRIERID == SCARR.CARRID
Check against city
  • Departure city
  • Country/Region Key
  • ?
  • S_CONNECTIONS.CITYFROM == SGEOCITY.CITY
  • S_CONNECTIONS.COUNTRYFROM == SGEOCITY.COUNTRY
  • S_CONNECTIONS.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against city
  • Arrival city
  • Country/Region Key
  • ?
  • S_CONNECTIONS.CITYTO == SGEOCITY.CITY
  • S_CONNECTIONS.COUNTRYTO == SGEOCITY.COUNTRY
  • S_CONNECTIONS.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against country of departure city
  • Departure city
  • Country/Region Key
  • ?
  • S_CONNECTIONS.CITYFROM == SGEOCITY.CITY
  • S_CONNECTIONS.COUNTRYFROM == SGEOCITY.COUNTRY
  • S_CONNECTIONS.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against country of arrival city
  • Arrival city
  • Country/Region Key
  • ?
  • S_CONNECTIONS.CITYTO == SGEOCITY.CITY
  • S_CONNECTIONS.COUNTRYTO == SGEOCITY.COUNTRY
  • S_CONNECTIONS.[column in domain "S_MANDT"] == SGEOCITY.MANDT