GSM_MS_VAL

Transparent Table Temporary Data

GSM-MS: Metric Values

GSM_MS_VAL is an SAP database table in S/4HANA. GSM-MS: Metric Values. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SMN_I_TS_WP_COUNT_ALL_R view from SMN: Tenant Single All Processes Count

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY timestamp_utc TIMESTAMP Time Stamp
KEY metric_id GSM_CR_METRIC_ID Metric ID
KEY context_id GSM_CR_CONTEXT_ID Context ID
KEY context_type GSM_CR_CONTEXT_TYPE Context Type
KEY attributes_id GSM_CR_ATTRIBUTES_ID Attributes ID
time_period GSM_CR_TIME_PERIOD Time Period
value_timestamp TIMESTAMP Time Stamp
value_rating GSM_CR_RATING Rating
value_count GSM_CR_VALUE Metric Value
value_max GSM_CR_VALUE Metric Value
value_min GSM_CR_VALUE Metric Value
value_sum GSM_CR_VALUE Metric Value
value_text GSM_CR_VALUE_TEXT Metric Value Text
retention_time GSM_CR_RETENTION_TIME Retention Time
metric_auth_group GSM_CR_METRIC_AUTH_GROUP Metric Auth. Group

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.

-- GSM-MS: Metric Values
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSM_MS_VAL (
    CLIENT,             -- Client [MANDT]
    TIMESTAMP_UTC,      -- Time Stamp [TIMESTAMP]
    METRIC_ID,          -- Metric ID [GSM_CR_METRIC_ID]
    CONTEXT_ID,         -- Context ID [GSM_CR_CONTEXT_ID]
    CONTEXT_TYPE,       -- Context Type [GSM_CR_CONTEXT_TYPE]
    ATTRIBUTES_ID,      -- Attributes ID [GSM_CR_ATTRIBUTES_ID]
    TIME_PERIOD,        -- Time Period [GSM_CR_TIME_PERIOD]
    VALUE_TIMESTAMP,    -- Time Stamp [TIMESTAMP]
    VALUE_RATING,       -- Rating [GSM_CR_RATING]
    VALUE_COUNT,        -- Metric Value [GSM_CR_VALUE]
    VALUE_MAX,          -- Metric Value [GSM_CR_VALUE]
    VALUE_MIN,          -- Metric Value [GSM_CR_VALUE]
    VALUE_SUM,          -- Metric Value [GSM_CR_VALUE]
    VALUE_TEXT,         -- Metric Value Text [GSM_CR_VALUE_TEXT]
    RETENTION_TIME,     -- Retention Time [GSM_CR_RETENTION_TIME]
    METRIC_AUTH_GROUP,  -- Metric Auth. Group [GSM_CR_METRIC_AUTH_GROUP]
    PRIMARY KEY (CLIENT, TIMESTAMP_UTC, METRIC_ID, CONTEXT_ID, CONTEXT_TYPE, ATTRIBUTES_ID)
);