Field | Key | Data Element | Type | Offset | Leng | Decimals | Check Table | Text |
---|---|---|---|---|---|---|---|---|
MANDT | X | S_MANDT | CLNT | 0 | 3 | 0 | T000 | Client |
CARRID | X | S_CARR_ID | CHAR | 3 | 3 | 0 | SCARR | Airline Code |
CONNID | X | S_CONN_ID | NUMC | 6 | 4 | 0 | Flight Connection Number | |
COUNTRYFR | LAND1 | CHAR | 10 | 3 | 0 | T005 | Country Key | |
CITYFROM | S_FROM_CIT | CHAR | 13 | 20 | 0 | SGEOCITY | Departure city | |
AIRPFROM | S_FROMAIRP | CHAR | 33 | 3 | 0 | SAIRPORT | Departure airport | |
COUNTRYTO | LAND1 | CHAR | 36 | 3 | 0 | T005 | Country Key | |
CITYTO | S_TO_CITY | CHAR | 39 | 20 | 0 | SGEOCITY | Arrival city | |
AIRPTO | S_TOAIRP | CHAR | 59 | 3 | 0 | SAIRPORT | Destination airport | |
FLTIME | S_FLTIME | INT4 | 64 | 10 | 0 | Flight time | ||
DEPTIME | S_DEP_TIME | TIMS | 68 | 6 | 0 | Departure time | ||
ARRTIME | S_ARR_TIME | TIMS | 74 | 6 | 0 | Arrival time | ||
DISTANCE | S_DISTANCE | QUAN | 80 | 9 | 4 | Distance | ||
DISTID | S_DISTID | UNIT | 85 | 3 | 0 | T006 | Mass unit of distance (kms, miles) | |
FLTYPE | S_FLTYPE | CHAR | 88 | 1 | 0 | Flight type | ||
PERIOD | S_PERIOD | INT1 | 89 | 3 | 0 | Arrival n day(s) later |