DAAG_SBOOK

Single Flight Booking | #transactional | Component: Data Aging
Column Name Description
MANDT FK Client
CARRID FK Airline Code
CONNID FK Flight Connection Number
FLDATE FK Flight date
BOOKID Booking number
Column Name Description
💲 Payment currency (FORCURKEY):
FORCURAM Booking price in foreign currency (dependent on location)
💲 Local currency of airline (LOCCURKEY):
LOCCURAM Price of booking in local currency of airline
Column Name Description
📏 Weight Unit (WUNIT):
LUGGWEIGHT Weight of Luggage
Column Name Description
FLDATE FK Flight date
ORDER_DATE Booking Date
PASSBIRTH Date of Birth of a Passenger
_DATAAGING Data Filter Value for Data Aging
Column Name Description
CUSTTYPE Customer type Show values
SMOKER Smoker Show values
INVOICE Invoice flag Show values
CLASS Flight Class Show values
CANCELLED Cancelation flag Show values
RESERVED Reservation flag Show values
INVOICE_OPEN Open Invoice 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
  • Client
Check Against Airline
  • Client
  • Airline Code
  • DAAG_SBOOK.MANDT == SCARR.MANDT
  • DAAG_SBOOK.CARRID == SCARR.CARRID
Check Against Flight Connection
  • Client
  • Flight Connection Number
  • Airline Code
Check Against Sales Office
  • Airline Code
  • Number of sales office
  • Client
Check against customer table
  • Customer Number
  • Client
Client DAAG_SBOOK.MANDT == T000.MANDT
Check Against Units
  • Client
  • Weight Unit
  • DAAG_SBOOK.MANDT == T006.MANDT
  • DAAG_SBOOK.WUNIT == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Payment currency DAAG_SBOOK.FORCURKEY == SCURX.CURRKEY
Check Currency DAAG_SBOOK.LOCCURKEY == SCURX.CURRKEY