SPFLI (Flight schedule) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SPFLI to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
S_MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
CARRID
Airline Code
|
S_CARR_ID | SCARR |
CHAR
|
3 | 0 | |||||||
|
CONNID
Flight Connection Number
|
S_CONN_ID |
NUMC
|
4 | 0 | ||||||||
|
COUNTRYFR
Country Key
|
LAND1 | SGEOCITY |
CHAR
|
3 | 0 | |||||||
|
CITYFROM
Departure city
|
S_FROM_CIT | SGEOCITY |
CHAR
|
20 | 0 | |||||||
|
AIRPFROM
Departure airport
|
S_FROMAIRP | SAIRPORT |
CHAR
|
3 | 0 | |||||||
|
COUNTRYTO
Country Key
|
LAND1 | SGEOCITY |
CHAR
|
3 | 0 | |||||||
|
CITYTO
Arrival city
|
S_TO_CITY | SGEOCITY |
CHAR
|
20 | 0 | |||||||
|
AIRPTO
Destination airport
|
S_TOAIRP | SAIRPORT |
CHAR
|
3 | 0 | |||||||
|
FLTIME
Flight time
|
S_FLTIME |
INT4
|
10 | 0 | ||||||||
|
DEPTIME
Departure time
|
S_DEP_TIME |
TIMS
|
6 | 0 | ||||||||
|
ARRTIME
Arrival time
|
S_ARR_TIME |
TIMS
|
6 | 0 | ||||||||
|
DISTANCE
Distance
|
S_DISTANCE |
QUAN
|
9 | 4 | ||||||||
|
DISTID
Mass unit of distance (kms, miles)
|
S_DISTID |
UNIT
|
3 | 0 | ||||||||
|
FLTYPE
Flight type
|
S_FLTYPE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
PERIOD
Arrival n day(s) later
|
S_PERIOD |
INT1
|
3 | 0 | ||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SPFLI | AIRPFROM | SPFLI | MANDT |
SAIRPORT
Airports
|
MANDT |
| SPFLI | AIRPFROM | SPFLI | AIRPFROM |
SAIRPORT
Airports
|
ID |
| SPFLI | AIRPTO | SPFLI | MANDT |
SAIRPORT
Airports
|
MANDT |
| SPFLI | AIRPTO | SPFLI | AIRPTO |
SAIRPORT
Airports
|
ID |
| SPFLI | CARRID | SPFLI | MANDT |
SCARR
Airline
|
MANDT |
| SPFLI | CARRID | SPFLI | CARRID |
SCARR
Airline
|
CARRID |
| SPFLI | CITYFROM | SPFLI | MANDT |
SGEOCITY
Geographical position of a city
|
MANDT |
| SPFLI | CITYFROM | SPFLI | CITYFROM |
SGEOCITY
Geographical position of a city
|
CITY |
| SPFLI | CITYFROM | SPFLI | COUNTRYFR |
SGEOCITY
Geographical position of a city
|
COUNTRY |
| SPFLI | CITYTO | SPFLI | COUNTRYTO |
SGEOCITY
Geographical position of a city
|
COUNTRY |
| SPFLI | CITYTO | SPFLI | MANDT |
SGEOCITY
Geographical position of a city
|
MANDT |
| SPFLI | CITYTO | SPFLI | CITYTO |
SGEOCITY
Geographical position of a city
|
CITY |
| SPFLI | COUNTRYFR | SPFLI | MANDT |
SGEOCITY
Geographical position of a city
|
MANDT |
| SPFLI | COUNTRYFR | SPFLI | CITYFROM |
SGEOCITY
Geographical position of a city
|
CITY |
| SPFLI | COUNTRYFR | SPFLI | COUNTRYFR |
SGEOCITY
Geographical position of a city
|
COUNTRY |
| SPFLI | COUNTRYTO | SPFLI | CITYTO |
SGEOCITY
Geographical position of a city
|
CITY |
| SPFLI | COUNTRYTO | SPFLI | COUNTRYTO |
SGEOCITY
Geographical position of a city
|
COUNTRY |
| SPFLI | COUNTRYTO | SPFLI | MANDT |
SGEOCITY
Geographical position of a city
|
MANDT |
| SPFLI | MANDT | SPFLI | MANDT |
T000
Clients
|
MANDT |