SADL_V_ExpVoc_Connection

APC Tests: Connection | view: SADL_V_E_CONN | 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
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Check Against Airline
  • ?
  • Airline Code
  • SADL_V_EXPVOC_CONNECTION.[column in domain "S_MANDT"] == SCARR.MANDT
  • SADL_V_EXPVOC_CONNECTION.AIRLINE == SCARR.CARRID
Check against airport
  • Departure airport
  • ?
  • SADL_V_EXPVOC_CONNECTION.AIRPORTOFDEPARTURE == SAIRPORT.ID
  • SADL_V_EXPVOC_CONNECTION.[column in domain "S_MANDT"] == SAIRPORT.MANDT
Check against city
  • Departure city
  • Country/Region Key
  • ?
  • SADL_V_EXPVOC_CONNECTION.CITYOFDEPARTURE == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION.COUNTRYOFDEPARTURE == SGEOCITY.COUNTRY
  • SADL_V_EXPVOC_CONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against country of departure city
  • Departure city
  • Country/Region Key
  • ?
  • SADL_V_EXPVOC_CONNECTION.CITYOFDEPARTURE == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION.COUNTRYOFDEPARTURE == SGEOCITY.COUNTRY
  • SADL_V_EXPVOC_CONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check against country of arrival city
  • ?
  • Arrival city
  • Country/Region Key
  • SADL_V_EXPVOC_CONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • SADL_V_EXPVOC_CONNECTION.DESTINATIONCITY == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION.COUNTRYTO == SGEOCITY.COUNTRY
Check against airport
  • ?
  • Destination airport
  • SADL_V_EXPVOC_CONNECTION.[column in domain "S_MANDT"] == SAIRPORT.MANDT
  • SADL_V_EXPVOC_CONNECTION.DESTINATIONAIRPORT == SAIRPORT.ID
Check against city
  • ?
  • Arrival city
  • Country/Region Key
  • SADL_V_EXPVOC_CONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • SADL_V_EXPVOC_CONNECTION.DESTINATIONCITY == SGEOCITY.CITY
  • SADL_V_EXPVOC_CONNECTION.COUNTRYTO == SGEOCITY.COUNTRY