SFLIGHT table in SAP ERP or S/4HANA stores Flight data. There are total 14 fields in SFLIGHT table. The Flight table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of SFLIGHT table. It is in Data Model: BC_TRAVEL for Workbench Training and Docu. (SAPBC_DATAMODEL) ABAP package and is part of the Training and Demo (BC-DWB-TND) module.
SAP SFLIGHT Table Fields
Following is the list of fields that are available in SAP SFLIGHT table. The primary key fields of Flight table in SAP are MANDT (Client), CARRID (Airline Code), CONNID (Flight Connection Number), FLDATE (Flight date).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | S_MANDT | T000 | CLNT(3) |
| CARRID | Airline Code | S_CARR_ID | SCARR | CHAR(3) |
| CONNID | Flight Connection Number | S_CONN_ID | SPFLI | NUMC(4) |
| FLDATE | Flight date | S_DATE | DATS(8) | |
| PRICE | Airfare | S_PRICE | CURR(15) | |
| CURRENCY | Local currency of airline | S_CURRCODE | SCURX | CUKY(5) |
| PLANETYPE | Aircraft Type | S_PLANETYE | SAPLANE | CHAR(10) |
| SEATSMAX | Maximum capacity in economy class | S_SEATSMAX | INT4(10) | |
| SEATSOCC | Occupied seats in economy class | S_SEATSOCC | INT4(10) | |
| PAYMENTSUM | Total of current bookings | S_SUM | CURR(17) | |
| SEATSMAX_B | Maximum capacity in business class | S_SMAX_B | INT4(10) | |
| SEATSOCC_B | Occupied seats in business class | S_SOCC_B | INT4(10) | |
| SEATSMAX_F | Maximum capacity in first class | S_SMAX_F | INT4(10) | |
| SEATSOCC_F | Occupied seats in first class | S_SOCC_F | INT4(10) |
