DEMO_DBTAB_SPFLI

Flight schedule | #masterdata | Component: ABAP Syntax, Compiler, Runtime
Column Name Description
MANDT FK 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
FLTYPE Flight type Show values
Column Name Description Domain name
FLTIME Flight time S_DURA
PERIOD Arrival n day(s) later INT1
Master Data Relations Join Conditions
Check against airport
  • Client
  • Departure airport
  • DEMO_DBTAB_SPFLI.MANDT == SAIRPORT.MANDT
  • DEMO_DBTAB_SPFLI.AIRPFROM == SAIRPORT.ID
Check against airport
  • Client
  • Destination airport
  • DEMO_DBTAB_SPFLI.MANDT == SAIRPORT.MANDT
  • DEMO_DBTAB_SPFLI.AIRPTO == SAIRPORT.ID
Check Against Airline
  • Client
  • Airline Code
Check against city
  • Country/Region Key
  • Client
  • Departure city
  • DEMO_DBTAB_SPFLI.COUNTRYFR == SGEOCITY.COUNTRY
  • DEMO_DBTAB_SPFLI.MANDT == SGEOCITY.MANDT
  • DEMO_DBTAB_SPFLI.CITYFROM == SGEOCITY.CITY
Check against city
  • Country/Region Key
  • Client
  • Arrival city
  • DEMO_DBTAB_SPFLI.COUNTRYTO == SGEOCITY.COUNTRY
  • DEMO_DBTAB_SPFLI.MANDT == SGEOCITY.MANDT
  • DEMO_DBTAB_SPFLI.CITYTO == SGEOCITY.CITY
Check against country of departure city
  • Country/Region Key
  • Client
  • Departure city
  • DEMO_DBTAB_SPFLI.COUNTRYFR == SGEOCITY.COUNTRY
  • DEMO_DBTAB_SPFLI.MANDT == SGEOCITY.MANDT
  • DEMO_DBTAB_SPFLI.CITYFROM == SGEOCITY.CITY
Check against country of arrival city
  • Country/Region Key
  • Client
  • Arrival city
  • DEMO_DBTAB_SPFLI.COUNTRYTO == SGEOCITY.COUNTRY
  • DEMO_DBTAB_SPFLI.MANDT == SGEOCITY.MANDT
  • DEMO_DBTAB_SPFLI.CITYTO == SGEOCITY.CITY
Client DEMO_DBTAB_SPFLI.MANDT == T000.MANDT