Fdt_Test_Pfli_Cds

SPFLI CDS | view: FDT_TEST_PFLI | Extraction: Not supported | Component: BRFplus - ABAP-Based Business Rules
Tables used: SPFLI
Column Name Description
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
  • ?
  • Departure airport
  • FDT_TEST_PFLI_CDS.[column in domain "S_MANDT"] == SAIRPORT.MANDT
  • FDT_TEST_PFLI_CDS.AIRPFROM == SAIRPORT.ID
Check against airport
  • ?
  • Destination airport
  • FDT_TEST_PFLI_CDS.[column in domain "S_MANDT"] == SAIRPORT.MANDT
  • FDT_TEST_PFLI_CDS.AIRPTO == SAIRPORT.ID
Check Against Airline
  • Airline Code
  • ?
  • FDT_TEST_PFLI_CDS.CARRID == SCARR.CARRID
  • FDT_TEST_PFLI_CDS.[column in domain "S_MANDT"] == SCARR.MANDT
Check against city
  • ?
  • Departure city
  • Country/Region Key
  • FDT_TEST_PFLI_CDS.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • FDT_TEST_PFLI_CDS.CITYFROM == SGEOCITY.CITY
  • FDT_TEST_PFLI_CDS.COUNTRYFR == SGEOCITY.COUNTRY
Check against city
  • ?
  • Arrival city
  • Country/Region Key
  • FDT_TEST_PFLI_CDS.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • FDT_TEST_PFLI_CDS.CITYTO == SGEOCITY.CITY
  • FDT_TEST_PFLI_CDS.COUNTRYTO == SGEOCITY.COUNTRY
Check against country of departure city
  • ?
  • Departure city
  • Country/Region Key
  • FDT_TEST_PFLI_CDS.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • FDT_TEST_PFLI_CDS.CITYFROM == SGEOCITY.CITY
  • FDT_TEST_PFLI_CDS.COUNTRYFR == SGEOCITY.COUNTRY
Check against country of arrival city
  • ?
  • Arrival city
  • Country/Region Key
  • FDT_TEST_PFLI_CDS.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • FDT_TEST_PFLI_CDS.CITYTO == SGEOCITY.CITY
  • FDT_TEST_PFLI_CDS.COUNTRYTO == SGEOCITY.COUNTRY