SAP table SFLIGHT (Flight)

SAP table SFLIGHT has 4 primary key fields being MANDT,CARRID,CONNID,FLDATE.

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 SPFLI S_CONN_ID
FLDATE Flight date DATS 8 0 S_DATE
PRICE Airfare CURR 15 2 S_PRICE
CURRENCY Local currency of airline CUKY 5 0 SCURX S_CURRCODE
PLANETYPE Aircraft Type CHAR 10 0 SAPLANE S_PLANETYE
SEATSMAX Maximum Capacity in Economy Class INT4 10 0 S_SEATSMAX
SEATSOCC Occupied seats in economy class INT4 10 0 S_SEATSOCC
PAYMENTSUM Total of current bookings CURR 17 2 S_SUM
SEATSMAX_B Maximum Capacity in Business Class INT4 10 0 S_SMAX_B
SEATSOCC_B Occupied seats in business class INT4 10 0 S_SOCC_B
SEATSMAX_F Maximum Capacity in First Class INT4 10 0 S_SMAX_F
SEATSOCC_F Occupied seats in first class INT4 10 0 S_SOCC_F

SFLIGHT foreign key relationships

Table Field Check Table Check Field
0 SFLIGHT CARRID SCARR Airline MANDT
1 SFLIGHT CONNID SPFLI Flight schedule MANDT
1 SFLIGHT CONNID SPFLI Flight schedule CARRID
0 SFLIGHT PLANETYPE SAPLANE Plane MANDT
0 SFLIGHT PLANETYPE SAPLANE Plane PLANETYPE