S_Bookings

Flight Bookings | view: S_BOOKINGSV | Extraction: Not supported | Component: ABAP Syntax, Compiler, Runtime
Tables used: SBOOK
Column Name Description
CarrierId FK Airline Code
ConnectionId FK Flight Connection Number
FlightDate FK Flight date
BookId Booking number
Column Name Description
💲 Payment currency (ForeignCurrencyCode):
ForeignCurrencyAmount Booking price in foreign currency (dependent on location)
💲 Local currency of airline (LocalCurrencyCode):
LocalCurrencyAmount Price of booking in local currency of airline
Column Name Description
📏 Weight Unit (WeightUnit):
LuggageWeight Weight of Luggage
Column Name Description
FlightDate FK Flight date
OrderDate Booking Date
passbirth Date of Birth of a Passenger
Column Name Description
CustomerType Customer type Show values
Smoker Smoker Show values
InvoiceId Invoice flag Show values
Class Flight Class Show values
Cancelled Cancelation flag Show values
Reserved Reservation flag Show values
Column Name Description Domain name
passname Name of the Passenger S_CUSTNAME
passform Form of address S_TEXT15
Master Data Relations | to Other Relations ↓ Join Conditions
Check Against Travel Agency
  • ?
  • Travel Agency Number
  • S_BOOKINGS.[column in domain "S_MANDT"] == STRAVELAG.MANDT
  • S_BOOKINGS.AGENCYNUMBER == STRAVELAG.AGENCYNUM
Check Against Airline
  • Airline Code
  • ?
  • S_BOOKINGS.CARRIERID == SCARR.CARRID
  • S_BOOKINGS.[column in domain "S_MANDT"] == SCARR.MANDT
Check Against Flight Connection
  • Airline Code
  • ?
  • Flight Connection Number
  • S_BOOKINGS.CARRIERID == SPFLI.CARRID
  • S_BOOKINGS.[column in domain "S_MANDT"] == SPFLI.MANDT
  • S_BOOKINGS.CONNECTIONID == SPFLI.CONNID
Check Against Sales Office
  • Number of sales office
  • Airline Code
  • Client
Check against customer table
  • Customer Number
  • ?
  • S_BOOKINGS.CUSTOMERID == SCUSTOM.ID
  • S_BOOKINGS.[column in domain "S_MANDT"] == SCUSTOM.MANDT
Check Against Units
  • Weight Unit
  • Client
  • S_BOOKINGS.WEIGHTUNIT == T006.MSEHI
  • S_BOOKINGS.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Payment currency S_BOOKINGS.FOREIGNCURRENCYCODE == SCURX.CURRKEY
Check Currency S_BOOKINGS.LOCALCURRENCYCODE == SCURX.CURRKEY