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. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
GSM_I_MS_INT_VALUES_R view_entity from GSM-MS: Metric Values
GSM_I_MSC_INT_VALUES_R view_entity from GSM-MS: Metric Values
SMN_I_TS_WP_COUNT_ALL_R view from SMN: Tenant Single All Processes Count
SMN_I_TS_WP_COUNT_BTCH_R view from SMN: Tenant Single Background Processes Count
SMN_I_TS_WP_COUNT_DIA_R view from SMN: Tenant Single Dialog 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)
);