P_SITNSBOOK

Private View for Sflight Bookings | view: PSITNSBOOK | TRAN | Extraction: Not supported | Component: Situation handling across applications, generic
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
order_date Booking Date
Column Name Description
class Flight Class Show values
cancelled Cancelation flag Show values
Column Name Description Domain name
customname Customer name S_CUSTNAME
unique_key_booking null
unique_key_flight null
bookingdescription null
Master Data Relations Join Conditions
Check Against Airline
  • Airline Code
  • ?
  • P_SITNSBOOK.CARRID == SCARR.CARRID
  • P_SITNSBOOK.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Connection
  • Flight Connection Number
  • Airline Code
  • ?
  • P_SITNSBOOK.CONNID == SPFLI.CONNID
  • P_SITNSBOOK.CARRID == SPFLI.CARRID
  • P_SITNSBOOK.[column in domain "S_MANDT"] == SPFLI.MANDT
Check Against Sales Office
  • Airline Code
  • Number of sales office
  • Client
Check against customer table
  • Customer Number
  • ?
  • P_SITNSBOOK.CUSTOMID == SCUSTOM.ID
  • P_SITNSBOOK.[column in domain "S_MANDT"] == SCUSTOM.MANDT