SQLMZS

Transparent Table Temporary Data
12 Fields 2 CDS Views

SQL Monitor: Subkeys

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SQLMDZVDISZ view inner CDS View for SQLMCZVDISZ
SQLMEZVDISZ view_entity inner CDS View for SQLMCZVDISZ

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY measid int4 INT4
KEY subid int4 INT4
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]
    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