sadl_v_cds_sflight_all

Complete SFLIGHT table projected | view: SADL_V_SFLIGHT2 | Extraction: Not supported | Component: Business Service Adaptation
Tables used: SFLIGHT
Column Name Description
carrid FK Airline Code
connid FK Flight Connection Number
fldate Flight date
Column Name Description
💲 Local currency of airline (currency):
price Airfare
paymentsum Total of current bookings
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
seatsmax_b Maximum Capacity in Business Class Show values
seatsocc_b Occupied seats in business class Show values
seatsmax_f Maximum Capacity in First Class Show values
seatsocc_f Occupied seats in first class Show values
Column Name Description Domain name
connid_first_char null
ext_10 null
Master Data Relations Join Conditions
Generic foreign key
  • Airline Code
  • ?
  • SADL_V_CDS_SFLIGHT_ALL.CARRID == SCARR.CARRID
  • SADL_V_CDS_SFLIGHT_ALL.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Plan
  • Flight Connection Number
  • Airline Code
  • ?
  • SADL_V_CDS_SFLIGHT_ALL.CONNID == SPFLI.CONNID
  • SADL_V_CDS_SFLIGHT_ALL.CARRID == SPFLI.CARRID
  • SADL_V_CDS_SFLIGHT_ALL.[column in domain "S_MANDT"] == SPFLI.MANDT
Check Against Airplane
  • ?
  • Aircraft Type
  • SADL_V_CDS_SFLIGHT_ALL.[column in domain "S_MANDT"] == SAPLANE.MANDT
  • SADL_V_CDS_SFLIGHT_ALL.PLANETYPE == SAPLANE.PLANETYPE
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline SADL_V_CDS_SFLIGHT_ALL.CURRENCY == SCURX.CURRKEY