sadl_sb_aunit_sflight

Flight Model: Flights | view: VSADLSB_AU_SFLGH | Extraction: Not supported | Component: REST Integration für CDS und BOPF via SADL
Tables used: SFLIGHT
Column Name Description
carrier_id FK Airline Code
connection_id FK Flight Connection Number
flight_date null
Column Name Description
💲 Local currency of airline (currency):
price Airfare
Column Name Description
Column Name Description
Column Name Description
seats_total Maximum Capacity in Economy Class Show values
seats_occupied Occupied seats in economy class Show values
Column Name Description Domain name
seats_free null
Master Data Relations Join Conditions
Generic foreign key
  • ?
  • Airline Code
  • SADL_SB_AUNIT_SFLIGHT.[column in domain "S_MANDT"] == SCARR.MANDT
  • SADL_SB_AUNIT_SFLIGHT.CARRIER_ID == SCARR.CARRID
Check Against Flight Plan
  • ?
  • Flight Connection Number
  • Airline Code
  • SADL_SB_AUNIT_SFLIGHT.[column in domain "S_MANDT"] == SPFLI.MANDT
  • SADL_SB_AUNIT_SFLIGHT.CONNECTION_ID == SPFLI.CONNID
  • SADL_SB_AUNIT_SFLIGHT.CARRIER_ID == SPFLI.CARRID
Check Against Airplane
  • ?
  • Aircraft Type
  • SADL_SB_AUNIT_SFLIGHT.[column in domain "S_MANDT"] == SAPLANE.MANDT
  • SADL_SB_AUNIT_SFLIGHT.PLANE_TYPE == SAPLANE.PLANETYPE
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline SADL_SB_AUNIT_SFLIGHT.CURRENCY == SCURX.CURRKEY