SAP ABAP Table /SAPQUERY/T200 (Single Flight Booking)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-QUE (Application Component) SAP Query
     ⤷ /SAPQUERY/BC (Package) Feature Content for SAP Query
Basic Data
Table Category TRANSP    Transparent table 
Transparent table /SAPQUERY/T200   Table Relationship Diagram
Short Description Single Flight Booking    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 CARRID /SAPQUERY/S_CARR_ID /SAPQUERY/S_CARR_ID CHAR 3   0   Airline Code /SAPQUERY/TA00
3 CONNID /SAPQUERY/S_CONN_ID /SAPQUERY/S_CONN_ID NUMC 4   0   Flight Connection Number /SAPQUERY/T000
4 FLDATE /SAPQUERY/S_DATE /SAPQUERY/S_DATE DATS 8   0   Flight date /SAPQUERY/T100
5 BOOKID /SAPQUERY/S_BOOK_ID /SAPQUERY/S_BOOK_ID NUMC 8   0   Booking number  
6 CUSTOMID /SAPQUERY/S_CUSTOMER /SAPQUERY/S_BUSPANUM NUMC 8   0   Customer Number /SAPQUERY/TA02
7 CUSTTYPE /SAPQUERY/S_CUSTTYPE /SAPQUERY/S_CUSTTYPE CHAR 1   0   Customer type  
8 SMOKER /SAPQUERY/S_SMOKER /SAPQUERY/S_SMOKER CHAR 1   0   Smoker  
9 LUGGWEIGHT /SAPQUERY/S_LUGWEIGH /SAPQUERY/S_LUGWEIGH QUAN 8   4   Weight of Luggage  
10 WUNIT /SAPQUERY/S_WEIUNIT MEINS UNIT 3   0   Weight Unit T006
11 INVOICE /SAPQUERY/S_INVFLAG /SAPQUERY/S_FLAG CHAR 1   0   Invoice flag  
12 CLASS /SAPQUERY/S_CLASS /SAPQUERY/S_CLASS CHAR 1   0   Flight Class  
13 FORCURAM /SAPQUERY/S_F_CUR_PR /SAPQUERY/S_PRICE CURR 15   2   Booking price in foreign currency (dependent on location)  
14 FORCURKEY /SAPQUERY/S_CURR /SAPQUERY/S_CURR CUKY 5   0   Payment currency *
15 LOCCURAM /SAPQUERY/S_L_CUR_PR /SAPQUERY/S_PRICE CURR 15   2   Price of booking in local currency of airline  
16 LOCCURKEY /SAPQUERY/S_CURRCODE /SAPQUERY/S_CURR CUKY 5   0   Local currency of airline *
17 ORDER_DATE /SAPQUERY/S_BDATE DATUM DATS 8   0   Booking Date  
18 COUNTER /SAPQUERY/S_COUNTNUM /SAPQUERY/S_COUNTNUM NUMC 8   0   Number of sales office *
19 AGENCYNUM /SAPQUERY/S_AGNCYNUM /SAPQUERY/S_BUSPANUM NUMC 8   0   Travel Agency Number *
20 CANCELLED /SAPQUERY/S_CANCEL /SAPQUERY/S_CANCEL CHAR 1   0   Cancelation flag  
21 RESERVED /SAPQUERY/S_RESERV /SAPQUERY/S_RESERV CHAR 1   0   Reservation flag  
22 PASSNAME /SAPQUERY/S_PASSNAME /SAPQUERY/S_CUSTNAME CHAR 25   0   Name of the Passenger  
23 PASSFORM /SAPQUERY/S_FORM /SAPQUERY/S_TEXT15 CHAR 15   0   Form of address  
24 PASSBIRTH /SAPQUERY/S_BIRTHDAT /SAPQUERY/S_DATE DATS 8   0   Date of Birth of a Passenger *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPQUERY/T200 CARRID /SAPQUERY/TA00 CARRID KEY 1 CN
2 /SAPQUERY/T200 CONNID /SAPQUERY/T000 CONNID    
3 /SAPQUERY/T200 CUSTOMID /SAPQUERY/TA02 ID KEY 1 CN
4 /SAPQUERY/T200 FLDATE /SAPQUERY/T100 FLDATE KEY 1 CN
5 /SAPQUERY/T200 MANDT T000 MANDT    
6 /SAPQUERY/T200 WUNIT T006 MSEHI    
History
Last changed by/on SAP  20140117 
SAP Release Created in 740