Sadl_V_Cds_Sflight_Ext

Extension of sadl_v_cds_sflight | view: SADL_V_SFLIGHT_X | Extraction: Not supported | Component: Business Service Adaptation
Tables used: SFLIGHT,Β SCURX
Column Name Description
Column Name Description
πŸ’² Local currency of airline (ext_flightcurrency):
ext_flightprice Airfare
πŸ’² Payment currency (ext_othercurrency):
ext_otherprice Airfare
ext_otherprice2 Airfare
ext_sbookprice Airfare
Column Name Description
Column Name Description
Column Name Description
ext_seatsmax Maximum Capacity in Economy Class Show values
ext_seatsddictext Occupied seats in economy class Show values
Column Name Description Domain name
ext_seatsnewtext Occupied seats in economy class
Master Data Relations Join Conditions
Generic foreign key
  • Client
  • Airline Code
  • SADL_V_CDS_SFLIGHT_EXT.EXT_CLIENT == SCARR.MANDT
  • SADL_V_CDS_SFLIGHT_EXT.EXT_CARRIER == SCARR.CARRID
Check against table SPFLI SADL_V_CDS_SFLIGHT_EXT.EXT_CLIENT == T000.MANDT
Check Against Flight Plan
  • Flight Connection Number
  • Client
  • Airline Code
  • SADL_V_CDS_SFLIGHT_EXT.EXT_CONNECTION_ID == SPFLI.CONNID
  • SADL_V_CDS_SFLIGHT_EXT.EXT_CLIENT == SPFLI.MANDT
  • SADL_V_CDS_SFLIGHT_EXT.EXT_CARRIER == SPFLI.CARRID
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline SADL_V_CDS_SFLIGHT_EXT.EXT_FLIGHTCURRENCY == SCURX.CURRKEY