Sadl_V_Expvoc_Booking

Integration Test CDS View | view: SADL_V_E_BOOK | Extraction: Not supported | Component: REST Integration für CDS und BOPF via SADL
Tables used: SBOOKSCUSTOM
Column Name Description
carrid FK Airline Code
connid FK Flight Connection Number
fldate FK Flight date
bookid Booking number
Column Name Description
Column Name Description
Column Name Description
fldate FK Flight date
Column Name Description
Column Name Description Domain name
FullName Customer name S_CUSTNAME
Country Country Code S_COUNTRY
City City CITY
Street Street S_STREET
PostBox PO Box S_POSTBOX
PhoneNumber Telephone number of flight customer S_PHONE
EmailAdress Customer e-mail address S_EMAIL
Master Data Relations Join Conditions
Check Against Airline
  • Airline Code
  • ?
  • SADL_V_EXPVOC_BOOKING.CARRID == SCARR.CARRID
  • SADL_V_EXPVOC_BOOKING.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Connection
  • Airline Code
  • ?
  • Flight Connection Number
  • SADL_V_EXPVOC_BOOKING.CARRID == SPFLI.CARRID
  • SADL_V_EXPVOC_BOOKING.[column in domain "S_MANDT"] == SPFLI.MANDT
  • SADL_V_EXPVOC_BOOKING.CONNID == SPFLI.CONNID
Check against customer table
  • Customer Number
  • ?
  • SADL_V_EXPVOC_BOOKING.CUSTOMERID == SCUSTOM.ID
  • SADL_V_EXPVOC_BOOKING.[column in domain "S_MANDT"] == SCUSTOM.MANDT