SQLMZD

Transparent Table Temporary Data

SQL Monitor: Data

SQLMZD is an SAP database table in S/4HANA. SQL Monitor: Data. It contains 4 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 (4)

KeyField Data ElementDescription DomainTypeLength
KEY measid int4 INT4
KEY infoid int4 INT4
KEY subid int4 INT4
KEY timeid int4 INT4

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]
    PRIMARY KEY (MEASID, INFOID, SUBID, TIMEID)
);