R_Sitn2DemoFlightCalcFields

Calculated Flight Fields | view: RSITN2DCALCFLD | 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
SitnDemoMaxSoldAmount Airfare
SitnDemoSalesDiffAmount null
SitnDemoSlsDiffEconomyClAmount null
SitnDemoSalesDiffBusClAmount null
SitnDemoSalesDiff1stClAmount null
SitnDemoBusClPrice null
SitnDemo1stClPrice null
Column Name Description
Column Name Description
SitnDemoFlightDate Flight date
Column Name Description
Column Name Description Domain name
SitnDemoLuggageWgtRatio null
SitnDemoLuggageWgtChtRatio null
SitnDemoOccupiedSeatsRatio null
SitnDemoOccupiedSeatsChtRatio null
SitnDemoSeatOccpcyEconomyRatio null
SitnDemoSeatsOccpcyBusClRatio null
SitnDemoSeatsOccpcy1stClRatio null
SitnDemoSalesRatio null
SitnDemoSalesChtRatio null
SitnDemoEconomyClSalesRatio null
SitnDemoBusClSalesRatio null
SitnDemo1stClSalesRatio null
Master Data Relations Join Conditions
Airline Code
  • ?
  • Airline Code
  • R_SITN2DEMOFLIGHTCALCFIELDS.[column in domain "S_MANDT"] == SIT2_DEMO_CARR.MANDT
  • R_SITN2DEMOFLIGHTCALCFIELDS.SITNDEMOCARRIERID == SIT2_DEMO_CARR.CARRID
Flight Connection Number
  • ?
  • Flight Connection Number
  • Airline Code
  • R_SITN2DEMOFLIGHTCALCFIELDS.[column in domain "S_MANDT"] == SIT2_DEMO_CONN.MANDT
  • R_SITN2DEMOFLIGHTCALCFIELDS.SITNDEMOCONNECTIONID == SIT2_DEMO_CONN.CONNID
  • R_SITN2DEMOFLIGHTCALCFIELDS.SITNDEMOCARRIERID == SIT2_DEMO_CONN.CARRID
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline R_SITN2DEMOFLIGHTCALCFIELDS.SITNDEMOCURRENCY == SCURX.CURRKEY