GSM_MSV_VAL

15 Fields 1 CDS Views

Generated Table for View

GSM_MSV_VAL is an SAP database table in S/4HANA. Generated Table for View. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_TS_WP_COUNT_HLP1_R view from KSR: Tenant Single Work Process Count Help

Fields (15)

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
attributes GSM_CR_ATTRIBUTES Attributes

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSM_MSV_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]
    ATTRIBUTES,       -- Attributes [GSM_CR_ATTRIBUTES]
    PRIMARY KEY (CLIENT, TIMESTAMP_UTC, METRIC_ID, CONTEXT_ID, CONTEXT_TYPE, ATTRIBUTES_ID)
);

Learn More