sadl_v_cds_sflight

CDS view on sflight | view: SADL_V_SFLIGHT | Extraction: Not supported | Component: Business Service Adaptation
Tables used: SFLIGHT, SCURX
Column Name Description
Column Name Description
💲 Local currency of airline (flightcurrency):
flightprice Airfare
💲 Payment currency (othercurrency):
otherprice Airfare
sbookprice Airfare
Column Name Description
Column Name Description
Column Name Description
seatsmax Maximum Capacity in Economy Class Show values
seatsddictext Occupied seats in economy class Show values
Column Name Description Domain name
seatsnewtext Occupied seats in economy class
seatsratio Occupied seats in economy class
Master Data Relations Join Conditions
Generic foreign key
  • Airline Code
  • ?
  • SADL_V_CDS_SFLIGHT.CARRIER == SCARR.CARRID
  • SADL_V_CDS_SFLIGHT.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Plan
  • Airline Code
  • Flight Connection Number
  • ?
  • SADL_V_CDS_SFLIGHT.CARRIER == SPFLI.CARRID
  • SADL_V_CDS_SFLIGHT.CONNECTION_ID == SPFLI.CONNID
  • SADL_V_CDS_SFLIGHT.[column in domain "S_MANDT"] == SPFLI.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline SADL_V_CDS_SFLIGHT.FLIGHTCURRENCY == SCURX.CURRKEY