SAP ABAP Table /SAPQUERY/T100 (Flight)
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/T100   Table Relationship Diagram
Short Description Flight    
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  
5 PRICE /SAPQUERY/S_PRICE /SAPQUERY/S_PRICE CURR 15   2   Airfare  
6 CURRENCY /SAPQUERY/S_CURRCODE /SAPQUERY/S_CURR CUKY 5   0   Local currency of airline *
7 PLANETYPE /SAPQUERY/S_PLANETYE /SAPQUERY/S_PLANE CHAR 10   0   Aircraft Type *
8 SEATSMAX /SAPQUERY/S_SEATSMAX /SAPQUERY/S_SEATS INT4 10   0   Maximum capacity in economy class  
9 SEATSOCC /SAPQUERY/S_SEATSOCC /SAPQUERY/S_SEATS INT4 10   0   Occupied seats in economy class  
10 PAYMENTSUM /SAPQUERY/S_SUM /SAPQUERY/S_SUM CURR 17   2   Total of current bookings  
11 SEATSMAX_B /SAPQUERY/S_SMAX_B /SAPQUERY/S_SEATS INT4 10   0   Maximum capacity in business class  
12 SEATSOCC_B /SAPQUERY/S_SOCC_B /SAPQUERY/S_SEATS INT4 10   0   Occupied seats in business class  
13 SEATSMAX_F /SAPQUERY/S_SMAX_F /SAPQUERY/S_SEATS INT4 10   0   Maximum capacity in first class  
14 SEATSOCC_F /SAPQUERY/S_SOCC_F /SAPQUERY/S_SEATS INT4 10   0   Occupied seats in first class  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPQUERY/T100 CARRID /SAPQUERY/TA00 CARRID    
2 /SAPQUERY/T100 CONNID /SAPQUERY/T000 CONNID KEY 1 CN
3 /SAPQUERY/T100 MANDT T000 MANDT KEY 1 CN
History
Last changed by/on SAP  20140117 
SAP Release Created in 740