WDR_TEST_SPFLI3

Flight Schedule | #masterdata | Component: Web Dynpro ABAP
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
  • WDR_TEST_SPFLI3.MANDT == SAIRPORT.MANDT
  • WDR_TEST_SPFLI3.AIRPFROM == SAIRPORT.ID
Check against airport
  • Client
  • Destination airport
Check Against Airline
  • Client
  • Airline Code
  • WDR_TEST_SPFLI3.MANDT == SCARR.MANDT
  • WDR_TEST_SPFLI3.CARRID == SCARR.CARRID
Check against city
  • Country/Region Key
  • Client
  • Departure city
  • WDR_TEST_SPFLI3.COUNTRYFR == SGEOCITY.COUNTRY
  • WDR_TEST_SPFLI3.MANDT == SGEOCITY.MANDT
  • WDR_TEST_SPFLI3.CITYFROM == SGEOCITY.CITY
Check against city
  • Country/Region Key
  • Client
  • Arrival city
  • WDR_TEST_SPFLI3.COUNTRYTO == SGEOCITY.COUNTRY
  • WDR_TEST_SPFLI3.MANDT == SGEOCITY.MANDT
  • WDR_TEST_SPFLI3.CITYTO == SGEOCITY.CITY
Check against country of departure city
  • Country/Region Key
  • Client
  • Departure city
  • WDR_TEST_SPFLI3.COUNTRYFR == SGEOCITY.COUNTRY
  • WDR_TEST_SPFLI3.MANDT == SGEOCITY.MANDT
  • WDR_TEST_SPFLI3.CITYFROM == SGEOCITY.CITY
Check against country of arrival city
  • Country/Region Key
  • Client
  • Arrival city
  • WDR_TEST_SPFLI3.COUNTRYTO == SGEOCITY.COUNTRY
  • WDR_TEST_SPFLI3.MANDT == SGEOCITY.MANDT
  • WDR_TEST_SPFLI3.CITYTO == SGEOCITY.CITY
Client WDR_TEST_SPFLI3.MANDT == T000.MANDT