SAP Table ACTFLI
ABAP/4 book: Flights
ACTFLI (ABAP/4 book: Flights) 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 ACTFLI to other SAP tables.
ACTFLI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | S_MANDT | T000 | CLNT | 3 | 0 | ||||
| CARRID | Airline Code | S_CARR_ID | PLANFLI | CHAR | 3 | 0 | ||||
| CONNID | Flight Connection Number | S_CONN_ID | PLANFLI | NUMC | 4 | 0 | ||||
| FLDATE | Flight date | S_DATE | DATS | 8 | 0 | |||||
| PRICE | Airfare | S_PRICE | CURR | 15 | 2 | |||||
| CURRENCY | Payment currency | S_CURR | SCURX | CUKY | 5 | 0 | ||||
| PLANETYPE | Aircraft Type | S_PLANETYE | CHAR | 10 | 0 | |||||
| SEATSMAX | Maximum capacity in economy class | S_SEATSMAX | INT4 | 10 | 0 |
Possible values
|
||||
| SEATSOCC | Occupied seats in economy class | S_SEATSOCC | INT4 | 10 | 0 |
Possible values
|
||||
| PAYMENTSUM | Total of current bookings | S_SUM | CURR | 17 | 2 | |||||
ACTFLI foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ACTFLI | CARRID | ACTFLI | MANDT | PLANFLI | ABAP/4 book: Connection offers for flights | MANDT |
| ACTFLI | CARRID | ACTFLI | CARRID | PLANFLI | ABAP/4 book: Connection offers for flights | CARRID |
| ACTFLI | CARRID | ACTFLI | CONNID | PLANFLI | ABAP/4 book: Connection offers for flights | CONNID |
| ACTFLI | CONNID | ACTFLI | MANDT | PLANFLI | ABAP/4 book: Connection offers for flights | MANDT |
| ACTFLI | CONNID | ACTFLI | CARRID | PLANFLI | ABAP/4 book: Connection offers for flights | CARRID |
| ACTFLI | CONNID | ACTFLI | CONNID | PLANFLI | ABAP/4 book: Connection offers for flights | CONNID |
| ACTFLI | CURRENCY | ACTFLI | CURRENCY | SCURX | Currency for Workbench training data model BC_Travel | CURRKEY |
| ACTFLI | MANDT | ACTFLI | MANDT | T000 | Clients | MANDT |
