SAP ABAP Table /SAPQUERY/T211 (Single Container 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/T211   Table Relationship Diagram
Short Description Single Container 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 LUGGWEIGHT /SAPQUERY/S_LUGWEIGH /SAPQUERY/S_LUGWEIGH QUAN 8   4   Weight of Luggage  
9 WUNIT /SAPQUERY/S_WEIUNIT MEINS UNIT 3   0   Weight Unit T006
10 INVOICE /SAPQUERY/S_INVFLAG /SAPQUERY/S_FLAG CHAR 1   0   Invoice flag  
11 CONTAINER /SAPQUERY/S_CONTAINER /SAPQUERY/S_CONTAINER CHAR 1   0   Container Size  
12 MATERIAL /SAPQUERY/S_MATNR /SAPQUERY/S_MATNR CHAR 18   0   Material number  
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  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPQUERY/T211 CARRID /SAPQUERY/TA00 CARRID KEY 1 CN
2 /SAPQUERY/T211 CONNID /SAPQUERY/T000 CONNID    
3 /SAPQUERY/T211 CUSTOMID /SAPQUERY/TA02 ID KEY 1 CN
4 /SAPQUERY/T211 FLDATE /SAPQUERY/T100 FLDATE KEY 1 CN
5 /SAPQUERY/T211 MANDT T000 MANDT    
6 /SAPQUERY/T211 WUNIT T006 MSEHI    
History
Last changed by/on SAP  20140117 
SAP Release Created in 740