ACMHEXDB_SCITY

Transparent Table Temporary Data
3 Fields 1 CDS Views

ACMHEX: Cities (DBTable)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ACMHEX_SCITY view from ACMHEX: Cities (= artificial Dimension)

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY city ACMHEX_CITY City
KEY country LAND1 Country/Reg.

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: Cities (DBTable)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMHEXDB_SCITY (
    MANDT,    -- Client [MANDT]
    CITY,     -- City [ACMHEX_CITY]
    COUNTRY,  -- Country/Reg. [LAND1]
    PRIMARY KEY (MANDT, CITY, COUNTRY)
);

Learn More