DEMO_DBTAB_SPFLI - Flight schedule
Flight schedule information is stored in SAP table DEMO_DBTAB_SPFLI.
It is part of development package SABAP_DEMOS_SHEETS in software component BC-ABA-LA. This development package consists of objects that can be grouped under "ABAP Cheat Sheets".
It is part of development package SABAP_DEMOS_SHEETS in software component BC-ABA-LA. This development package consists of objects that can be grouped under "ABAP Cheat Sheets".
Fields for table DEMO_DBTAB_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 | DEMO_DBTAB_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 |