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