SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

/SAPQUERY/T200 Table in SAP | Single Flight Booking Table & Fields List

/SAPQUERY/T200 is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of /SAPQUERY/T200 in SAP.

  • Table description : Single Flight Booking
  • Module : BC-SRV-QUE
  • Parent Module : BC
  • Package : /SAPQUERY/BC
  • Software Component : SAP_BASIS
/SAPQUERY/T200 table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP /SAPQUERY/T200 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
CARRIDAirline Code/SAPQUERY/S_CARR_ID/SAPQUERY/S_CARR_ID
CONNIDFlight Connection Number/SAPQUERY/S_CONN_ID/SAPQUERY/S_CONN_ID
FLDATEFlight date/SAPQUERY/S_DATE/SAPQUERY/S_DATE
BOOKIDBooking number/SAPQUERY/S_BOOK_ID/SAPQUERY/S_BOOK_ID
CUSTOMIDCustomer Number/SAPQUERY/S_CUSTOMER/SAPQUERY/S_BUSPANUM
CUSTTYPECustomer type/SAPQUERY/S_CUSTTYPE/SAPQUERY/S_CUSTTYPE
SMOKERSmoker/SAPQUERY/S_SMOKER/SAPQUERY/S_SMOKER
LUGGWEIGHTWeight of Luggage/SAPQUERY/S_LUGWEIGH/SAPQUERY/S_LUGWEIGH
WUNITWeight Unit/SAPQUERY/S_WEIUNITMEINS
INVOICEInvoice flag/SAPQUERY/S_INVFLAG/SAPQUERY/S_FLAG
CLASSFlight Class/SAPQUERY/S_CLASS/SAPQUERY/S_CLASS
FORCURAMBooking price in foreign currency (dependent on location)/SAPQUERY/S_F_CUR_PR/SAPQUERY/S_PRICE
FORCURKEYPayment currency/SAPQUERY/S_CURR/SAPQUERY/S_CURR
LOCCURAMPrice of booking in local currency of airline/SAPQUERY/S_L_CUR_PR/SAPQUERY/S_PRICE
LOCCURKEYLocal currency of airline/SAPQUERY/S_CURRCODE/SAPQUERY/S_CURR
ORDER_DATEBooking Date/SAPQUERY/S_BDATEDATUM
COUNTERNumber of sales office/SAPQUERY/S_COUNTNUM/SAPQUERY/S_COUNTNUM
AGENCYNUMTravel Agency Number/SAPQUERY/S_AGNCYNUM/SAPQUERY/S_BUSPANUM
CANCELLEDCancelation flag/SAPQUERY/S_CANCEL/SAPQUERY/S_CANCEL
RESERVEDReservation flag/SAPQUERY/S_RESERV/SAPQUERY/S_RESERV
PASSNAMEName of the Passenger/SAPQUERY/S_PASSNAME/SAPQUERY/S_CUSTNAME
PASSFORMForm of address/SAPQUERY/S_FORM/SAPQUERY/S_TEXT15
PASSBIRTHDate of Birth of a Passenger/SAPQUERY/S_BIRTHDAT/SAPQUERY/S_DATE

/SAPQUERY/T200 related tables

TableNote
DAAG_SBOOKSingle Flight Booking
SBOOKSingle Flight Booking
/SAPQUERY/T200Single Flight Booking
/SAPQUERY/T211Single Container Flight Booking
FLIGHTBFlight booking
OMD_SBOOK_TMPKEYFlight booking key store
SCOL_MAP_BOOKID Flight Example: Mapping for Persistent Booking IDs
SFLBOFlight Booking Order
SFLBOPOSFlight Booking Order Item
ADFSH_FLGTCATFlight Scheduling: Flight Category
ADFSH_FLGTCAT_TFlight Scheduling: Flight Category Description
ADFSH_FLGTDETFlight Scheduling: Flight Schedule Details
ADFSH_FLGTMASFlight Scheduling: Flight Schedule Master
ADFSH_FLGTPAXFlight Scheduling: Flight Type
ADFSH_FLGTPAX_TFlight Scheduling: Flight Type Description
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com