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 | 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 | 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 | ||||||
|
||||||||||
|
SEATSOCC
Occupied seats in economy class
|
S_SEATSOCC |
INT4
|
10 | 0 | ||||||
|
||||||||||
|
PAYMENTSUM
Total of current bookings
|
S_SUM |
CURR
|
17 | 2 | ||||||
|
SEATSMAX_B
Maximum capacity in business class
|
S_SMAX_B |
INT4
|
10 | 0 | ||||||
|
||||||||||
|
SEATSOCC_B
Occupied seats in business class
|
S_SOCC_B |
INT4
|
10 | 0 | ||||||
|
||||||||||
|
SEATSMAX_F
Maximum capacity in first class
|
S_SMAX_F |
INT4
|
10 | 0 | ||||||
|
||||||||||
|
SEATSOCC_F
Occupied seats in first class
|
S_SOCC_F |
INT4
|
10 | 0 | ||||||
|
||||||||||
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 | CARRID |
SPFLI
Flight schedule
|
CARRID |
| SFLIGHT | CONNID | SFLIGHT | CONNID |
SPFLI
Flight schedule
|
CONNID |
| SFLIGHT | CONNID | SFLIGHT | MANDT |
SPFLI
Flight schedule
|
MANDT |
| 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 |