P_Sitn2DemoFlightCalc1

Calculated Fields for Situation Demo | view: PSITN2DFLIC1 | TRAN | Extraction: Not supported | Component: Situation handling: Situation Engine
Column Name Description
SitnDemoCarrierID FK Airline Code
SitnDemoConnectionID FK Flight Connection Number
SitnDemoFlightDate Flight date
Column Name Description
💲 Local currency of airline (SitnDemoCurrency):
SitnDemoPrice Airfare
SitnDemoBusClPrice null
SitnDemo1stClPrice null
Column Name Description
Column Name Description
SitnDemoFlightDate Flight date
Column Name Description
SitnDemoSeatsOccupiedQty Occupied seats in economy class Show values
SitnDemoSeatsOccupiedBusClQty Occupied seats in business class Show values
SitnDemoSeatsOccupied1stClQty Occupied seats in first class Show values
SitnDemoSeatsMaxQty Maximum Capacity in Economy Class Show values
SitnDemoSeatsMaxBusClQty Maximum Capacity in Business Class Show values
SitnDemoSeatsMax1stClQty Maximum Capacity in First Class Show values
Column Name Description Domain name
SitnDemoLuggageWgtRatio null
SitnDemoOccupiedSeatsRatio null
SitnDemoSeatOccpcyEconomyRatio null
SitnDemoSeatsOccpcyBusClRatio null
SitnDemoSeatsOccpcy1stClRatio null
Master Data Relations Join Conditions
Airline Code
  • Airline Code
  • ?
  • P_SITN2DEMOFLIGHTCALC1.SITNDEMOCARRIERID == SIT2_DEMO_CARR.CARRID
  • P_SITN2DEMOFLIGHTCALC1.[column in domain "S_MANDT"] == SIT2_DEMO_CARR.MANDT
Flight Connection Number
  • Airline Code
  • ?
  • Flight Connection Number
  • P_SITN2DEMOFLIGHTCALC1.SITNDEMOCARRIERID == SIT2_DEMO_CONN.CARRID
  • P_SITN2DEMOFLIGHTCALC1.[column in domain "S_MANDT"] == SIT2_DEMO_CONN.MANDT
  • P_SITN2DEMOFLIGHTCALC1.SITNDEMOCONNECTIONID == SIT2_DEMO_CONN.CONNID
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline P_SITN2DEMOFLIGHTCALC1.SITNDEMOCURRENCY == SCURX.CURRKEY