sadl_v_cds_sflight3

sadl_v_cds_sflight3 | view: SADL_V_SFLIGHT3 | Extraction: Not supported | Component: Business Service Adaptation
Tables used: SFLIGHT,Β SCURX
Column Name Description
Column Name Description
πŸ’² Local currency of airline (flightcurrency):
flightprice Airfare
sbookprice Airfare
πŸ’² Payment currency (othercurrency):
otherprice Airfare
ext_otherprice2 Airfare
πŸ’² Local currency of airline (ext_flightcurrency):
ext_flightprice Airfare
πŸ’² Payment currency (ext_othercurrency):
ext_otherprice Airfare
ext_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
ext_seatsmax Maximum Capacity in Economy Class Show values
ext_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
ext_seatsnewtext Occupied seats in economy class
Master Data Relations | to Other Relations ↓ Join Conditions
Generic foreign key
  • Airline Code
  • Airline Code
  • Client
  • SADL_V_CDS_SFLIGHT3.CARRIER == SCARR.CARRID
  • SADL_V_CDS_SFLIGHT3.EXT_CARRIER == SCARR.CARRID
  • SADL_V_CDS_SFLIGHT3.EXT_CLIENT == SCARR.MANDT
Check Against Flight Plan
  • Airline Code
  • Airline Code
  • Flight Connection Number
  • Flight Connection Number
  • Client
  • SADL_V_CDS_SFLIGHT3.CARRIER == SPFLI.CARRID
  • SADL_V_CDS_SFLIGHT3.EXT_CARRIER == SPFLI.CARRID
  • SADL_V_CDS_SFLIGHT3.CONNECTION_ID == SPFLI.CONNID
  • SADL_V_CDS_SFLIGHT3.EXT_CONNECTION_ID == SPFLI.CONNID
  • SADL_V_CDS_SFLIGHT3.EXT_CLIENT == SPFLI.MANDT
Generic foreign key
  • Airline Code
  • Airline Code
  • Client
  • SADL_V_CDS_SFLIGHT3.CARRIER == SCARR.CARRID
  • SADL_V_CDS_SFLIGHT3.EXT_CARRIER == SCARR.CARRID
  • SADL_V_CDS_SFLIGHT3.EXT_CLIENT == SCARR.MANDT
Check against table SPFLI SADL_V_CDS_SFLIGHT3.EXT_CLIENT == T000.MANDT
Check Against Flight Plan
  • Airline Code
  • Airline Code
  • Flight Connection Number
  • Flight Connection Number
  • Client
  • SADL_V_CDS_SFLIGHT3.CARRIER == SPFLI.CARRID
  • SADL_V_CDS_SFLIGHT3.EXT_CARRIER == SPFLI.CARRID
  • SADL_V_CDS_SFLIGHT3.CONNECTION_ID == SPFLI.CONNID
  • SADL_V_CDS_SFLIGHT3.EXT_CONNECTION_ID == SPFLI.CONNID
  • SADL_V_CDS_SFLIGHT3.EXT_CLIENT == SPFLI.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline
  • Local currency of airline
  • Local currency of airline
  • SADL_V_CDS_SFLIGHT3.EXT_FLIGHTCURRENCY == SCURX.CURRKEY
  • SADL_V_CDS_SFLIGHT3.FLIGHTCURRENCY == SCURX.CURRKEY
Local currency of airline
  • Local currency of airline
  • Local currency of airline
  • SADL_V_CDS_SFLIGHT3.EXT_FLIGHTCURRENCY == SCURX.CURRKEY
  • SADL_V_CDS_SFLIGHT3.FLIGHTCURRENCY == SCURX.CURRKEY