demo_cds_scarr_spfli

CDS DDIC-based view, simple join | view: DEMO_CDS_JOIN | Extraction: Not supported | Component: ABAP Syntax, Compiler, Runtime
Tables used: SCARRSPFLI
Column Name Description
id FK Airline Code
carrier Airline name
flight Flight Connection Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Check against city
  • ?
  • Departure city
  • ?
  • DEMO_CDS_SCARR_SPFLI.[column in domain "S_MANDT"] == SGEOCITY.MANDT
  • DEMO_CDS_SCARR_SPFLI.DEPARTURE == SGEOCITY.CITY
  • DEMO_CDS_SCARR_SPFLI.[column in domain "LAND1"] == SGEOCITY.COUNTRY
Check against city
  • ?
  • Arrival city
  • ?
  • DEMO_CDS_SCARR_SPFLI.[column in domain "LAND1"] == SGEOCITY.COUNTRY
  • DEMO_CDS_SCARR_SPFLI.DESTINATION == SGEOCITY.CITY
  • DEMO_CDS_SCARR_SPFLI.[column in domain "S_MANDT"] == SGEOCITY.MANDT
Check Against Airline
  • Airline Code
  • ?
  • DEMO_CDS_SCARR_SPFLI.ID == SCARR.CARRID
  • DEMO_CDS_SCARR_SPFLI.[column in domain "S_MANDT"] == SCARR.MANDT