SADL_SB_AUNIT_SPFLI

Flight Model: Schedules | view: VSADLSB_AU_SPFLI | Extraction: Not supported | Component: REST Integration für CDS und BOPF via SADL
Tables used: SPFLI
Column Name Description
carrier_id FK Airline Code
connection_id Flight Connection Number
Column Name Description
Column Name Description
📏 Mass unit of distance (kms, miles) (distance_unit):
distance Distance
Column Name Description
departure_time Departure time
arrival_time Arrival time
Column Name Description
Column Name Description Domain name
flight_type Flight type
flight_time Flight time
period Arrival n day(s) later
Master Data Relations Join Conditions
Check Against Airline
  • ?
  • Airline Code
  • SADL_SB_AUNIT_SPFLI.[column in domain "S_MANDT"] == SCARR.MANDT
  • SADL_SB_AUNIT_SPFLI.CARRIER_ID == SCARR.CARRID
Check against airport
  • ?
  • Departure airport
  • SADL_SB_AUNIT_SPFLI.[column in domain "S_MANDT"] == SAIRPORT.MANDT
  • SADL_SB_AUNIT_SPFLI.FROM_AIRPORT == SAIRPORT.ID
Check against city
  • ?
  • Country/Region Key
  • Departure city
  • SADL_SB_AUNIT_SPFLI.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • SADL_SB_AUNIT_SPFLI.FROM_COUNTRY == SGEOCITY.COUNTRY
  • SADL_SB_AUNIT_SPFLI.FROM_CITY == SGEOCITY.CITY
Check against country of departure city
  • ?
  • Country/Region Key
  • Departure city
  • SADL_SB_AUNIT_SPFLI.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • SADL_SB_AUNIT_SPFLI.FROM_COUNTRY == SGEOCITY.COUNTRY
  • SADL_SB_AUNIT_SPFLI.FROM_CITY == SGEOCITY.CITY
Check against airport
  • ?
  • Destination airport
  • SADL_SB_AUNIT_SPFLI.[column in domain "S_MANDT"] == SAIRPORT.MANDT
  • SADL_SB_AUNIT_SPFLI.TO_AIRPORT == SAIRPORT.ID
Check against city
  • Arrival city
  • ?
  • Country/Region Key
  • SADL_SB_AUNIT_SPFLI.TO_CITY == SGEOCITY.CITY
  • SADL_SB_AUNIT_SPFLI.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • SADL_SB_AUNIT_SPFLI.TO_COUNTRY == SGEOCITY.COUNTRY
Check against country of arrival city
  • Arrival city
  • ?
  • Country/Region Key
  • SADL_SB_AUNIT_SPFLI.TO_CITY == SGEOCITY.CITY
  • SADL_SB_AUNIT_SPFLI.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • SADL_SB_AUNIT_SPFLI.TO_COUNTRY == SGEOCITY.COUNTRY