ACMHEXDB_SFLIGHT

Transparent Table Temporary Data
14 Fields 1 CDS Views

ACMHEX: Flights (DBTable)

ACMHEXDB_SFLIGHT is an SAP database table in S/4HANA. ACMHEX: Flights (DBTable). It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ACMHEX_SFLIGHT view from ACMHEX: Flights (= Info-Cube / to-be-protected Entity)

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY carrid acmhex_carr_id Carrier
KEY connid acmhex_conn_id Connection
KEY fldate acmhex_date Date
uuid acmtst_id ID
price acmhex_price Airfare
currency acmhex_currency_code Currency
planetype acmhex_planetype Planetype
seatsmax acmhex_seats_max Max. Seats
seatsocc acmhex_seats_occ Occupied
countryfr land1 Country/Reg.
cityfrom acmhex_city City
countryto land1 Country/Reg.
cityto acmhex_city City

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- ACMHEX: Flights (DBTable)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMHEXDB_SFLIGHT (
    MANDT,      -- Client [mandt]
    CARRID,     -- Carrier [acmhex_carr_id]
    CONNID,     -- Connection [acmhex_conn_id]
    FLDATE,     -- Date [acmhex_date]
    UUID,       -- ID [acmtst_id]
    PRICE,      -- Airfare [acmhex_price]
    CURRENCY,   -- Currency [acmhex_currency_code]
    PLANETYPE,  -- Planetype [acmhex_planetype]
    SEATSMAX,   -- Max. Seats [acmhex_seats_max]
    SEATSOCC,   -- Occupied [acmhex_seats_occ]
    COUNTRYFR,  -- Country/Reg. [land1]
    CITYFROM,   -- City [acmhex_city]
    COUNTRYTO,  -- Country/Reg. [land1]
    CITYTO,     -- City [acmhex_city]
    PRIMARY KEY (MANDT, CARRID, CONNID, FLDATE)
);

Learn More