SIT2_DEMO_CONN

Situation Demo Connections | #masterdata | Component: Situation handling: Situation Engine
Column Name Description
MANDT Client
CARRID FK Airline Code
CONNID Flight Connection Number
Column Name Description
Column Name Description
📏 Mass unit of distance (kms, miles) (DISTID):
DISTANCE Distance
Column Name Description
DEPTIME Departure time
ARRTIME Arrival time
Column Name Description
Column Name Description Domain name
FLTIME Flight time S_DURA
PERIOD Arrival n day(s) later INT1
Master Data Relations Join Conditions
Departure airport
  • Client
  • Departure airport
Destination airport
  • Client
  • Destination airport
Airline Code
  • Airline Code
  • Client
Departure city
  • Country/Region Key
  • Client
  • Departure city
  • SIT2_DEMO_CONN.COUNTRYFR == SGEOCITY.COUNTRY
  • SIT2_DEMO_CONN.MANDT == SGEOCITY.MANDT
  • SIT2_DEMO_CONN.CITYFROM == SGEOCITY.CITY
Arrival city
  • Country/Region Key
  • Client
  • Arrival city
  • SIT2_DEMO_CONN.COUNTRYTO == SGEOCITY.COUNTRY
  • SIT2_DEMO_CONN.MANDT == SGEOCITY.MANDT
  • SIT2_DEMO_CONN.CITYTO == SGEOCITY.CITY
Country/Region Key
  • Country/Region Key
  • Client
  • Departure city
  • SIT2_DEMO_CONN.COUNTRYFR == SGEOCITY.COUNTRY
  • SIT2_DEMO_CONN.MANDT == SGEOCITY.MANDT
  • SIT2_DEMO_CONN.CITYFROM == SGEOCITY.CITY
Country/Region Key
  • Country/Region Key
  • Client
  • Arrival city
  • SIT2_DEMO_CONN.COUNTRYTO == SGEOCITY.COUNTRY
  • SIT2_DEMO_CONN.MANDT == SGEOCITY.MANDT
  • SIT2_DEMO_CONN.CITYTO == SGEOCITY.CITY