Friday, May 24, 2024

SAP Table ACMHEXDB_SFLIGHT – ACMHEX: Flights (DBTable)

ACMHEXDB_SFLIGHT is a standard SAP table in SAP ECC (or) S/4HANA which stores ACMHEX: Flights (DBTable) data. There are total 13 fields in ACMHEXDB_SFLIGHT table.This blog post provides key technical details of SAP table ACMHEXDB_SFLIGHT, including its availability across SAP S/4HANA versions and the list of CDS views for ACMHEXDB_SFLIGHT table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Hierarchy Example (SACMHIEREX)
Technical Component Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL)

SAP ACMHEXDB_SFLIGHT Table Fields

The following is the list of fields that are available in SAP ACMHEXDB_SFLIGHT table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
CARRID ACMHEX: Carrier-ID (=Airline-ID) ACMHEX_CARR_ID ACMHEX_CARR_ID ACMHEXDB_SCARR CHAR (3)
CONNID ACMHEX: Connection-ID ACMHEX_CONN_ID ACMHEX_CONN_ID ACMHEXDB_SPFLI NUMC (4)
FLDATE ACMHEX: Flight Date ACMHEX_DATE ACMHEX_DATE DATS (8)
UUID ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables ACMTST_ID ACM_ID RAW (16)
PRICE ACMHEX: Airfare (Price) ACMHEX_PRICE ACMHEX_PRICE CURR (15)
PLANETYPE ACMHEX: Plane-Type ACMHEX_PLANETYPE ACMHEX_PLANETYPE ACMHEXDB_SPLANET CHAR (10)
SEATSMAX ACMHEX: Maximum Number of Seats ACMHEX_SEATS_MAX ACMHEX_SEATS INT4 (10)
SEATSOCC ACMHEX: Occupied Number of Seats ACMHEX_SEATS_OCC ACMHEX_SEATS INT4 (10)
COUNTRYFR Country/Region Key LAND1 LAND1 ACMHEXDB_SCOUNTR CHAR (3)
CITYFROM ACMHEX: City ACMHEX_CITY ACMHEX_CITY ACMHEXDB_SCITY CHAR (20)
COUNTRYTO Country/Region Key LAND1 LAND1 ACMHEXDB_SCOUNTR CHAR (3)
CITYTO ACMHEX: City ACMHEX_CITY ACMHEX_CITY ACMHEXDB_SCITY CHAR (20)

Availability

The SAP table ACMHEXDB_SFLIGHT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ACMHEXDB_SFLIGHT table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.