Cds_With_Dcl_Pfcg

CDS based on DCL with PFCG conditions | view: CDSFRWK_DEMO_14B | Extraction: Not supported | Component: Unit test framework for CDS
Tables used: SFLIGHT
Column Name Description
carrid FK Airline Code
connid FK Flight Connection Number
fldate Flight date
Column Name Description
Column Name Description
Column Name Description
fldate Flight date
Column Name Description
seatsmax Maximum Capacity in Economy Class Show values
seatsocc Occupied seats in economy class Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Generic foreign key
  • ?
  • Airline Code
  • CDS_WITH_DCL_PFCG.[column in domain "S_MANDT"] == SCARR.MANDT
  • CDS_WITH_DCL_PFCG.CARRID == SCARR.CARRID
Check Against Flight Plan
  • Flight Connection Number
  • ?
  • Airline Code
  • CDS_WITH_DCL_PFCG.CONNID == SPFLI.CONNID
  • CDS_WITH_DCL_PFCG.[column in domain "S_MANDT"] == SPFLI.MANDT
  • CDS_WITH_DCL_PFCG.CARRID == SPFLI.CARRID
Check Against Airplane
  • ?
  • Aircraft Type
  • CDS_WITH_DCL_PFCG.[column in domain "S_MANDT"] == SAPLANE.MANDT
  • CDS_WITH_DCL_PFCG.PLANETYPE == SAPLANE.PLANETYPE
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline CDS_WITH_DCL_PFCG.CURRENCY == SCURX.CURRKEY