SQLMZS

Transparent Table Temporary Data
17 Fields 2 CDS Views

SQL Monitor: Subkeys

SQLMZS is an SAP database table in S/4HANA. SQL Monitor: Subkeys. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SQLMDZVDISZ view inner
SQLMEZVDISZ view_entity inner

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY measid INT4 INT4
KEY subid INT4 INT4
runlevel SQLMRUNLEVEL Run Mode
roottype SQLMROOTTYPE Request Type
rootname SQLMROOTNAME Entry Point
stmtkind SQLMSTMTKIND SQL Operation
tablenames SQLMTABLENAMES Table Names
tablename01 SQLMTABLENAME Table Name
tablename02 SQLMTABLENAME Table Name
tablename03 SQLMTABLENAME Table Name
tablename04 SQLMTABLENAME Table Name
tablename05 SQLMTABLENAME Table Name
tablename06 SQLMTABLENAME Table Name
tablename07 SQLMTABLENAME Table Name
tablename08 SQLMTABLENAME Table Name
tablename09 SQLMTABLENAME Table Name
tablename10 SQLMTABLENAME Table Name

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: Subkeys
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SQLMZS (
    MEASID,       -- INT4 [INT4]
    SUBID,        -- INT4 [INT4]
    RUNLEVEL,     -- Run Mode [SQLMRUNLEVEL]
    ROOTTYPE,     -- Request Type [SQLMROOTTYPE]
    ROOTNAME,     -- Entry Point [SQLMROOTNAME]
    STMTKIND,     -- SQL Operation [SQLMSTMTKIND]
    TABLENAMES,   -- Table Names [SQLMTABLENAMES]
    TABLENAME01,  -- Table Name [SQLMTABLENAME]
    TABLENAME02,  -- Table Name [SQLMTABLENAME]
    TABLENAME03,  -- Table Name [SQLMTABLENAME]
    TABLENAME04,  -- Table Name [SQLMTABLENAME]
    TABLENAME05,  -- Table Name [SQLMTABLENAME]
    TABLENAME06,  -- Table Name [SQLMTABLENAME]
    TABLENAME07,  -- Table Name [SQLMTABLENAME]
    TABLENAME08,  -- Table Name [SQLMTABLENAME]
    TABLENAME09,  -- Table Name [SQLMTABLENAME]
    TABLENAME10,  -- Table Name [SQLMTABLENAME]
    PRIMARY KEY (MEASID, SUBID)
);

Learn More