GSM_MS_VAL
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA