/SAPQUERY/T211

Single Container Flight Booking | #transactional | Component: SAP Query
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
Column Name Description
CUSTTYPE Customer type Show values
INVOICE Invoice flag Show values
CONTAINER Container Size Show values
CANCELLED Cancelation flag Show values
RESERVED Reservation flag Show values
Column Name Description Domain name
MATERIAL Material number /SAPQUERY/S_MATNR
COUNTER Number of sales office /SAPQUERY/S_COUNTNUM
AGENCYNUM Travel Agency Number /SAPQUERY/S_BUSPANUM
Master Data Relations Join Conditions
Check Against Airline
Check Against Flight Connection
  • Flight Connection Number
  • Client
  • Airline Code
Check against customer table
  • Customer Number
  • Client
Client /SAPQUERY/T211.MANDT == T000.MANDT
Check Against Units
  • /SAPQUERY/T211.MANDT == T006.MANDT
  • /SAPQUERY/T211.WUNIT == T006.MSEHI