The ACMHEXDB_SFLIGHT table in SAP ERP or S/4HANA stores ACMHEX: Flights (DBTable) data. There are total 13 fields in ACMHEXDB_SFLIGHT table. The ACMHEX: Flights (DBTable) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ACMHEXDB_SFLIGHT table. It is in Hierarchy Example (SACMHIEREX) ABAP package and is part of the Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module.
SAP ACMHEXDB_SFLIGHT Table Fields
Following is the list of fields that are available in SAP ACMHEXDB_SFLIGHT table. The primary key fields of the table are MANDT (Client), CARRID (ACMHEX: Carrier-ID (=Airline-ID)), CONNID (ACMHEX: Connection-ID), FLDATE (ACMHEX: Flight Date).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| CARRID | ACMHEX: Carrier-ID (=Airline-ID) | ACMHEX_CARR_ID | ACMHEXDB_SCARR | CHAR (3) |
| CONNID | ACMHEX: Connection-ID | ACMHEX_CONN_ID | ACMHEXDB_SPFLI | NUMC (4) |
| FLDATE | ACMHEX: Flight Date | ACMHEX_DATE | DATS (8) | |
| UUID | ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables | ACMTST_ID | RAW (16) | |
| PRICE | ACMHEX: Airfare (Price) | ACMHEX_PRICE | CURR (15) | |
| PLANETYPE | ACMHEX: Plane-Type | ACMHEX_PLANETYPE | ACMHEXDB_SPLANET | CHAR (10) |
| SEATSMAX | ACMHEX: Maximum Number of Seats | ACMHEX_SEATS_MAX | INT4 (10) | |
| SEATSOCC | ACMHEX: Occupied Number of Seats | ACMHEX_SEATS_OCC | INT4 (10) | |
| COUNTRYFR | Country/Region Key | LAND1 | ACMHEXDB_SCOUNTR | CHAR (3) |
| CITYFROM | ACMHEX: City | ACMHEX_CITY | ACMHEXDB_SCITY | CHAR (20) |
| COUNTRYTO | Country/Region Key | LAND1 | ACMHEXDB_SCOUNTR | CHAR (3) |
| CITYTO | ACMHEX: City | ACMHEX_CITY | ACMHEXDB_SCITY | CHAR (20) |
