SAP table SPFLI (Flight schedule)

SAP table SPFLI has 3 primary key fields being MANDT,CARRID,CONNID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 S_MANDT
CARRID Airline Code CHAR 3 0 SCARR S_CARR_ID
CONNID Flight Connection Number NUMC 4 0 S_CONN_ID
COUNTRYFR Country/Region Key CHAR 3 0 SGEOCITY LAND1
CITYFROM Departure city CHAR 20 0 SGEOCITY S_FROM_CIT
AIRPFROM Departure airport CHAR 3 0 SAIRPORT S_FROMAIRP
COUNTRYTO Country/Region Key CHAR 3 0 SGEOCITY LAND1
CITYTO Arrival city CHAR 20 0 SGEOCITY S_TO_CITY
AIRPTO Destination airport CHAR 3 0 SAIRPORT S_TOAIRP
FLTIME Flight time INT4 10 0 S_FLTIME
DEPTIME Departure time TIMS 6 0 S_DEP_TIME
ARRTIME Arrival time TIMS 6 0 S_ARR_TIME
DISTANCE Distance QUAN 9 4 S_DISTANCE
DISTID Mass unit of distance (kms, miles) UNIT 3 0 * S_DISTID
FLTYPE Flight type CHAR 1 0 S_FLTYPE
Scheduled
X Charter
PERIOD Arrival n day(s) later INT1 3 0 S_PERIOD

SPFLI foreign key relationships

Table Field Check Table Check Field
0 SPFLI AIRPFROM SAIRPORT Airports MANDT
0 SPFLI AIRPFROM SAIRPORT Airports ID
1 SPFLI AIRPTO SAIRPORT Airports MANDT
1 SPFLI AIRPTO SAIRPORT Airports ID
0 SPFLI CARRID SCARR Airline MANDT
1 SPFLI CITYFROM SGEOCITY Geographical position of a city MANDT
1 SPFLI CITYFROM SGEOCITY Geographical position of a city CITY
1 SPFLI CITYFROM SGEOCITY Geographical position of a city COUNTRY
0 SPFLI CITYTO SGEOCITY Geographical position of a city MANDT
0 SPFLI CITYTO SGEOCITY Geographical position of a city CITY
0 SPFLI CITYTO SGEOCITY Geographical position of a city COUNTRY
1 SPFLI COUNTRYFR SGEOCITY Geographical position of a city MANDT
1 SPFLI COUNTRYFR SGEOCITY Geographical position of a city CITY
1 SPFLI COUNTRYFR SGEOCITY Geographical position of a city COUNTRY
0 SPFLI COUNTRYTO SGEOCITY Geographical position of a city MANDT
0 SPFLI COUNTRYTO SGEOCITY Geographical position of a city CITY
0 SPFLI COUNTRYTO SGEOCITY Geographical position of a city COUNTRY