SQLMXE

Transparent Table Temporary Data
14 Fields 1 CDS Views

SQL Monitor: Entities

SQLMXE is an SAP database table in S/4HANA. SQL Monitor: Entities. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
sqlmxets view from SQL Monitor: Entities with Timestamp

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY tablenames SQLMTABLENAMES Table Names
KEY idx SYTABIX Table Row
tableviewname SQLMTABLEVIEWNAME Table or View
cdsviewname SQLMCDSVIEWNAME CDS View
sqlviewname SQLMSQLVIEWNAME SQL View Name
proxysqlviewname SQLMPROXYSQLVIEWNAME Proxy View Name
proxycdsviewname SQLMPROXYCDSVIEWNAME Proxy View Name
tablefunctionname SQLMTABLEFUNCTIONNAME CDS Table Function
amdpname SQLMAMDPNAME AMDP Method
annoservicequality SQLMANNOSERVICEQUALITY Service Quality
annosizecategory SQLMANNOSIZECATEGORY Size Category
annodataclass SQLMANNODATACLASS Data Class
as4date AS4DATE Date
as4time AS4TIME Time

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.

-- SQL Monitor: Entities
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SQLMXE (
    TABLENAMES,          -- Table Names [SQLMTABLENAMES]
    IDX,                 -- Table Row [SYTABIX]
    TABLEVIEWNAME,       -- Table or View [SQLMTABLEVIEWNAME]
    CDSVIEWNAME,         -- CDS View [SQLMCDSVIEWNAME]
    SQLVIEWNAME,         -- SQL View Name [SQLMSQLVIEWNAME]
    PROXYSQLVIEWNAME,    -- Proxy View Name [SQLMPROXYSQLVIEWNAME]
    PROXYCDSVIEWNAME,    -- Proxy View Name [SQLMPROXYCDSVIEWNAME]
    TABLEFUNCTIONNAME,   -- CDS Table Function [SQLMTABLEFUNCTIONNAME]
    AMDPNAME,            -- AMDP Method [SQLMAMDPNAME]
    ANNOSERVICEQUALITY,  -- Service Quality [SQLMANNOSERVICEQUALITY]
    ANNOSIZECATEGORY,    -- Size Category [SQLMANNOSIZECATEGORY]
    ANNODATACLASS,       -- Data Class [SQLMANNODATACLASS]
    AS4DATE,             -- Date [AS4DATE]
    AS4TIME,             -- Time [AS4TIME]
    PRIMARY KEY (TABLENAMES, IDX)
);

Learn More