SQLMZI

Transparent Table Temporary Data
17 Fields 2 CDS Views

SQL Monitor: Info & Key

SQLMZI is an SAP database table in S/4HANA. SQL Monitor: Info & Key. 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 infoid INT4 INT4
progname PROGNAME Program Name
progkind SQLMPROGKIND Prog. Kind
proctype SQLMPROCTYPE Proc. Bl. Type
procname SQLMPROCNAME Proc Block Name
procline SQLMPROCLINE Proc Block Line
hashcode SQLMHASHCODE Hash Code
line INT4 INT4
fragment SQLMFRAGMENT ABAP Source Code
pgmid PGMID Program ID
object TROBJTYPE Object Type
obj_name SOBJ_NAME Object Name
devclass DEVCLASS Package
progdate SQLMPROGDATE Date
progtime SQLMPROGTIME Time
outdated SQLMOUTDATED Outdated

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: Info & Key
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SQLMZI (
    MEASID,    -- INT4 [INT4]
    INFOID,    -- INT4 [INT4]
    PROGNAME,  -- Program Name [PROGNAME]
    PROGKIND,  -- Prog. Kind [SQLMPROGKIND]
    PROCTYPE,  -- Proc. Bl. Type [SQLMPROCTYPE]
    PROCNAME,  -- Proc Block Name [SQLMPROCNAME]
    PROCLINE,  -- Proc Block Line [SQLMPROCLINE]
    HASHCODE,  -- Hash Code [SQLMHASHCODE]
    LINE,      -- INT4 [INT4]
    FRAGMENT,  -- ABAP Source Code [SQLMFRAGMENT]
    PGMID,     -- Program ID [PGMID]
    OBJECT,    -- Object Type [TROBJTYPE]
    OBJ_NAME,  -- Object Name [SOBJ_NAME]
    DEVCLASS,  -- Package [DEVCLASS]
    PROGDATE,  -- Date [SQLMPROGDATE]
    PROGTIME,  -- Time [SQLMPROGTIME]
    OUTDATED,  -- Outdated [SQLMOUTDATED]
    PRIMARY KEY (MEASID, INFOID)
);

Learn More