SQLMZD

Transparent Table Temporary Data
14 Fields 3 CDS Views

SQL Monitor: Data

SQLMZD is an SAP database table in S/4HANA. SQL Monitor: Data. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
sqlmdzd1 view from SQL Monitor
SQLMDZVDISZ view from
SQLMEZVDISZ view_entity from

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY measid INT4 INT4
KEY infoid INT4 INT4
KEY subid INT4 INT4
KEY timeid INT4 INT4
xcnt abap.dec
rcnt abap.dec
rtmin abap.dec
rtmax abap.dec
rtsum abap.dec
rtsqs abap.dec
dbmin abap.dec
dbmax abap.dec
dbsum abap.dec
dbsqs abap.dec

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: Data
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SQLMZD (
    MEASID,  -- INT4 [INT4]
    INFOID,  -- INT4 [INT4]
    SUBID,   -- INT4 [INT4]
    TIMEID,  -- INT4 [INT4]
    XCNT,    -- abap.dec
    RCNT,    -- abap.dec
    RTMIN,   -- abap.dec
    RTMAX,   -- abap.dec
    RTSUM,   -- abap.dec
    RTSQS,   -- abap.dec
    DBMIN,   -- abap.dec
    DBMAX,   -- abap.dec
    DBSUM,   -- abap.dec
    DBSQS,   -- abap.dec
    PRIMARY KEY (MEASID, INFOID, SUBID, TIMEID)
);

Learn More