SAP ABAP Table /SAPQUERY/T000 (Flight schedule)
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/T000   Table Relationship Diagram
Short Description Flight schedule    
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  
4 COUNTRYFR LAND1 LAND1 CHAR 3   0   Country Key /SAPQUERY/TA03
5 CITYFROM /SAPQUERY/S_CITY /SAPQUERY/S_CITY CHAR 20   0   City /SAPQUERY/TA03
6 AIRPFROM /SAPQUERY/S_FROMAIRP /SAPQUERY/S_AIRPID CHAR 3   0   Departure airport /SAPQUERY/TA01
7 COUNTRYTO LAND1 LAND1 CHAR 3   0   Country Key /SAPQUERY/TA03
8 CITYTO /SAPQUERY/S_TO_CITY /SAPQUERY/S_CITY CHAR 20   0   Arrival city /SAPQUERY/TA03
9 AIRPTO /SAPQUERY/S_TOAIRP /SAPQUERY/S_AIRPID CHAR 3   0   Destination airport /SAPQUERY/TA01
10 FLTIME /SAPQUERY/S_FLTIME /SAPQUERY/S_DURA INT4 10   0   Flight time  
11 DEPTIME /SAPQUERY/S_DEP_TIME /SAPQUERY/S_TIME TIMS 6   0   Departure time  
12 ARRTIME /SAPQUERY/S_ARR_TIME /SAPQUERY/S_TIME TIMS 6   0   Arrival time  
13 DISTANCE /SAPQUERY/S_DISTANCE /SAPQUERY/S_DISTANCE QUAN 9   4   Distance  
14 DISTID /SAPQUERY/S_DISTID MEINS UNIT 3   0   Mass unit of distance (kms, miles) *
15 FLTYPE /SAPQUERY/S_FLTYPE /SAPQUERY/S_FLTYPE CHAR 1   0   Flight type  
16 PERIOD /SAPQUERY/S_PERIOD INT1 INT1 3   0   Arrival n day(s) later  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPQUERY/T000 AIRPFROM /SAPQUERY/TA01 ID REF 1 CN
2 /SAPQUERY/T000 AIRPTO /SAPQUERY/TA01 ID REF 1 CN
3 /SAPQUERY/T000 CARRID /SAPQUERY/TA00 CARRID KEY 1 CN
4 /SAPQUERY/T000 CITYFROM /SAPQUERY/TA03 CITY REF 1 CN
5 /SAPQUERY/T000 CITYTO /SAPQUERY/TA03 CITY REF 1 CN
6 /SAPQUERY/T000 COUNTRYFR /SAPQUERY/TA03 COUNTRY REF 1 CN
7 /SAPQUERY/T000 COUNTRYTO /SAPQUERY/TA03 COUNTRY REF 1 CN
8 /SAPQUERY/T000 MANDT T000 MANDT    
History
Last changed by/on SAP  20140117 
SAP Release Created in 740