R_Sitn2DemoConnection

Connections for Situation Demo | view: RSITN2DCONN | TRAN | Extraction: Not supported | Component: Situation handling: Situation Engine
Tables used: SIT2_DEMO_CONN
Column Name Description
SitnDemoCarrierID FK Airline Code
SitnDemoConnectionID Flight Connection Number
Column Name Description
Column Name Description
📏 Mass unit of distance (kms, miles) (SitnDemoFlightDistUnit):
SitnDemoFlightDistance Distance
Column Name Description
SitnDemoDepartTime Departure time
SitnDemoArrivalTime Arrival time
Column Name Description
Column Name Description Domain name
SitnDemoFlightPeriodQty Arrival n day(s) later INT1
Master Data Relations Join Conditions
Departure airport
  • Departure airport
  • ?
  • R_SITN2DEMOCONNECTION.SITNDEMOAIRPORTFROM == SAIRPORT.ID
  • R_SITN2DEMOCONNECTION.[column in domain "S_MANDT"] == SAIRPORT.MANDT
Destination airport
  • Destination airport
  • ?
  • R_SITN2DEMOCONNECTION.SITNDEMOAIRPORTTO == SAIRPORT.ID
  • R_SITN2DEMOCONNECTION.[column in domain "S_MANDT"] == SAIRPORT.MANDT
Airline Code
  • Airline Code
  • ?
  • R_SITN2DEMOCONNECTION.SITNDEMOCARRIERID == SIT2_DEMO_CARR.CARRID
  • R_SITN2DEMOCONNECTION.[column in domain "S_MANDT"] == SIT2_DEMO_CARR.MANDT
Departure city
  • Departure city
  • Country/Region Key
  • ?
  • R_SITN2DEMOCONNECTION.SITNDEMOCITYFROM == SGEOCITY.CITY
  • R_SITN2DEMOCONNECTION.SITNDEMOCOUNTRYFROM == SGEOCITY.COUNTRY
  • R_SITN2DEMOCONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Arrival city
  • Country/Region Key
  • Arrival city
  • ?
  • R_SITN2DEMOCONNECTION.SITNDEMOCOUNTRYTO == SGEOCITY.COUNTRY
  • R_SITN2DEMOCONNECTION.SITNDEMOCITYTO == SGEOCITY.CITY
  • R_SITN2DEMOCONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Country/Region Key
  • Departure city
  • Country/Region Key
  • ?
  • R_SITN2DEMOCONNECTION.SITNDEMOCITYFROM == SGEOCITY.CITY
  • R_SITN2DEMOCONNECTION.SITNDEMOCOUNTRYFROM == SGEOCITY.COUNTRY
  • R_SITN2DEMOCONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Country/Region Key
  • Country/Region Key
  • Arrival city
  • ?
  • R_SITN2DEMOCONNECTION.SITNDEMOCOUNTRYTO == SGEOCITY.COUNTRY
  • R_SITN2DEMOCONNECTION.SITNDEMOCITYTO == SGEOCITY.CITY
  • R_SITN2DEMOCONNECTION.[column in domain "S_MANDT"] == SGEOCITY.MANDT