SADL_V_ExpVoc_Connection_Par

APC Tests: Connection | view: SADL_V_E_CONP | Extraction: Not supported | Component: REST Integration für CDS und BOPF via SADL
Tables used: SPFLI
Column Name Description
Airline FK Airline Code
ConnectionID Flight Connection Number
Column Name Description
Column Name Description
📏 Mass unit of distance (kms, miles) (DistanceUnit):
Distance Distance
Column Name Description
DepartureTime Departure time
ArrivalTime Arrival time
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Check Against Airline
  • Airline Code
  • ?
  • SADL_V_EXPVOC_CONNECTION_PAR.AIRLINE == SCARR.CARRID
  • SADL_V_EXPVOC_CONNECTION_PAR.[column in domain "S_MANDT"] == SCARR.MANDT
Check against airport
  • Departure airport
  • ?
  • SADL_V_EXPVOC_CONNECTION_PAR.AIRPORTOFDEPARTURE == SAIRPORT.ID
  • SADL_V_EXPVOC_CONNECTION_PAR.[column in domain "S_MANDT"] == SAIRPORT.MANDT
Check against city
  • Departure city
  • Country/Region Key
  • ?
  • SADL_V_EXPVOC_CONNECTION_PAR.CITYOFDEPARTURE == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION_PAR.COUNTRYOFDEPARTURE == SGEOCITY.COUNTRY
  • SADL_V_EXPVOC_CONNECTION_PAR.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against country of departure city
  • Departure city
  • Country/Region Key
  • ?
  • SADL_V_EXPVOC_CONNECTION_PAR.CITYOFDEPARTURE == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION_PAR.COUNTRYOFDEPARTURE == SGEOCITY.COUNTRY
  • SADL_V_EXPVOC_CONNECTION_PAR.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against country of arrival city
  • Arrival city
  • Country/Region Key
  • ?
  • SADL_V_EXPVOC_CONNECTION_PAR.DESTINATIONCITY == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION_PAR.COUNTRYTO == SGEOCITY.COUNTRY
  • SADL_V_EXPVOC_CONNECTION_PAR.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against airport
  • Destination airport
  • ?
  • SADL_V_EXPVOC_CONNECTION_PAR.DESTINATIONAIRPORT == SAIRPORT.ID
  • SADL_V_EXPVOC_CONNECTION_PAR.[column in domain "S_MANDT"] == SAIRPORT.MANDT
Check against city
  • Arrival city
  • Country/Region Key
  • ?
  • SADL_V_EXPVOC_CONNECTION_PAR.DESTINATIONCITY == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION_PAR.COUNTRYTO == SGEOCITY.COUNTRY
  • SADL_V_EXPVOC_CONNECTION_PAR.[column in domain "S_MANDT"] == SGEOCITY.MANDT