P_Sitn2DemoFlightCalc2

Calculated Fields for Situation Demo | view: PSITN2DFLIC2 | 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):
SitnDemoEconomyClSoldAmount null
SitnDemoBusClSoldAmount null
SitnDemo1stClSoldAmount null
SitnDemoCurrentSoldAmount Airfare
SitnDemoCurSoldEconomyClAmount Airfare
SitnDemoCurSoldBusClAmount Airfare
SitnDemoCurSold1stClAmount Airfare
SitnDemoMaxSoldAmount Airfare
SitnDemoMaxSoldEconomyClAmount Airfare
SitnDemoMaxSoldBusClAmount Airfare
SitnDemoMaxSold1stClAmount Airfare
SitnDemoBusClPrice null
SitnDemo1stClPrice null
Column Name Description
Column Name Description
SitnDemoFlightDate Flight date
Today null
Column Name Description
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_SITN2DEMOFLIGHTCALC2.SITNDEMOCARRIERID == SIT2_DEMO_CARR.CARRID
  • P_SITN2DEMOFLIGHTCALC2.[column in domain "S_MANDT"] == SIT2_DEMO_CARR.MANDT
Flight Connection Number
  • Airline Code
  • Flight Connection Number
  • ?
  • P_SITN2DEMOFLIGHTCALC2.SITNDEMOCARRIERID == SIT2_DEMO_CONN.CARRID
  • P_SITN2DEMOFLIGHTCALC2.SITNDEMOCONNECTIONID == SIT2_DEMO_CONN.CONNID
  • P_SITN2DEMOFLIGHTCALC2.[column in domain "S_MANDT"] == SIT2_DEMO_CONN.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline P_SITN2DEMOFLIGHTCALC2.SITNDEMOCURRENCY == SCURX.CURRKEY