/SAPQUERY/T000 - Flight schedule
Flight schedule information is stored in SAP table /SAPQUERY/T000.
It is part of development package /SAPQUERY/BC in software component BC-SRV-QUE. This development package consists of objects that can be grouped under "Feature Content for SAP Query".
It is part of development package /SAPQUERY/BC in software component BC-SRV-QUE. This development package consists of objects that can be grouped under "Feature Content for SAP Query".
Fields for table /SAPQUERY/T000
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
CARRID | Airline Code | X | /SAPQUERY/S_CARR_ID | CHAR | 6 | /SAPQUERY/TA00 |
CONNID | Flight Connection Number | X | /SAPQUERY/S_CONN_ID | NUMC | 8 | |
COUNTRYFR | Country/Region Key | LAND1 | CHAR | 6 | /SAPQUERY/TA03 | |
CITYFROM | City | /SAPQUERY/S_CITY | CHAR | 40 | /SAPQUERY/TA03 | |
AIRPFROM | Departure airport | /SAPQUERY/S_FROMAIRP | CHAR | 6 | /SAPQUERY/TA01 | |
COUNTRYTO | Country/Region Key | LAND1 | CHAR | 6 | /SAPQUERY/TA03 | |
CITYTO | Arrival city | /SAPQUERY/S_TO_CITY | CHAR | 40 | /SAPQUERY/TA03 | |
AIRPTO | Destination airport | /SAPQUERY/S_TOAIRP | CHAR | 6 | /SAPQUERY/TA01 | |
FLTIME | Flight time | /SAPQUERY/S_FLTIME | INT4 | 4 | ||
DEPTIME | Departure time | /SAPQUERY/S_DEP_TIME | TIMS | 12 | ||
ARRTIME | Arrival time | /SAPQUERY/S_ARR_TIME | TIMS | 12 | ||
DISTANCE | Distance | /SAPQUERY/S_DISTANCE | QUAN | 5 | ||
DISTID | Mass unit of distance (kms, miles) | /SAPQUERY/S_DISTID | UNIT | 6 | * | |
FLTYPE | Flight type | /SAPQUERY/S_FLTYPE | CHAR | 2 | ||
PERIOD | Arrival n day(s) later | /SAPQUERY/S_PERIOD | INT1 | 1 |