1. Home
  2. Resources
  3. SAP Tables
  4. SFLIGHT - Flight

SAP Table SFLIGHT

Flight

SFLIGHT (Flight) 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 SFLIGHT to other SAP tables.

SFLIGHT table fields

Field Data element Checktable Datatype Length Decimals
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 SPFLI NUMC 4 0
FLDATE Flight date S_DATE DATS 8 0
PRICE Airfare S_PRICE CURR 15 2
CURRENCY Local currency of airline S_CURRCODE SCURX CUKY 5 0
PLANETYPE Aircraft Type S_PLANETYE SAPLANE CHAR 10 0
SEATSMAX Maximum capacity in economy class S_SEATSMAX INT4 10 0
0 Whole numbers
SEATSOCC Occupied seats in economy class S_SEATSOCC INT4 10 0
0 Whole numbers
PAYMENTSUM Total of current bookings S_SUM CURR 17 2
SEATSMAX_B Maximum capacity in business class S_SMAX_B INT4 10 0
0 Whole numbers
SEATSOCC_B Occupied seats in business class S_SOCC_B INT4 10 0
0 Whole numbers
SEATSMAX_F Maximum capacity in first class S_SMAX_F INT4 10 0
0 Whole numbers
SEATSOCC_F Occupied seats in first class S_SOCC_F INT4 10 0
0 Whole numbers

SFLIGHT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SFLIGHT CARRID SFLIGHT MANDT SCARR Airline MANDT
SFLIGHT CARRID SFLIGHT CARRID SCARR Airline CARRID
SFLIGHT CONNID SFLIGHT MANDT SPFLI Flight schedule MANDT
SFLIGHT CONNID SFLIGHT CARRID SPFLI Flight schedule CARRID
SFLIGHT CONNID SFLIGHT CONNID SPFLI Flight schedule CONNID
SFLIGHT CURRENCY SFLIGHT CURRENCY SCURX Currency for Workbench training data model BC_Travel CURRKEY
SFLIGHT MANDT SFLIGHT MANDT T000 Clients MANDT
SFLIGHT PLANETYPE SFLIGHT MANDT SAPLANE Plane MANDT
SFLIGHT PLANETYPE SFLIGHT PLANETYPE SAPLANE Plane PLANETYPE