GSM_I_MSC_INT_VALUES_R
GSM-MS: Metric Values
GSM_I_MSC_INT_VALUES_R is a CDS View that provides data about "GSM-MS: Metric Values" in SAP S/4HANA. It reads from 3 data sources (gsm_ms_cur, GSM_I_MD_METRIC_ACT_R, gsm_ms_val) and exposes 14 fields with key fields Timestamp_Utc, Provider_Id, Metric_Id, Context_Id, Context_Type.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| gsm_ms_cur | _Current | inner |
| GSM_I_MD_METRIC_ACT_R | _Metrics | inner |
| gsm_ms_val | _Values | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | GSM-MS: Metric Values | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
Fields (14)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Timestamp_Utc | gsm_ms_val | timestamp_utc | Timestamp |
| KEY | Provider_Id | GSM_I_MD_METRIC_ACT_R | provider_id | Provider ID |
| KEY | Metric_Id | gsm_ms_val | metric_id | Metric ID |
| KEY | Context_Id | gsm_ms_val | context_id | Context ID |
| KEY | Context_Type | gsm_ms_val | context_type | Context Type |
| KEY | Attributes_Id | gsm_ms_val | attributes_id | Attributes ID |
| Time_Period | gsm_ms_val | time_period | Time Period in Month | |
| Value_Timestamp | gsm_ms_val | value_timestamp | Time Stamp | |
| Value_Rating | gsm_ms_val | value_rating | Rating | |
| Value_Count | gsm_ms_val | value_count | Metric Value | |
| Value_Max | gsm_ms_val | value_max | Metric Value | |
| Value_Min | gsm_ms_val | value_min | Metric Value | |
| Value_Sum | gsm_ms_val | value_sum | Metric Value | |
| Value_Text | gsm_ms_val | value_text | Metric Value Text |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view GSM_I_MSC_INT_VALUES_R.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW GSM_I_MSC_INT_VALUES_R AS
SELECT
_Values.timestamp_utc AS Timestamp_Utc,
_Metrics.provider_id AS Provider_Id,
_Values.metric_id AS Metric_Id,
_Values.context_id AS Context_Id,
_Values.context_type AS Context_Type,
_Values.attributes_id AS Attributes_Id,
_Values.time_period AS Time_Period,
_Values.value_timestamp AS Value_Timestamp,
_Values.value_rating AS Value_Rating,
_Values.value_count AS Value_Count,
_Values.value_max AS Value_Max,
_Values.value_min AS Value_Min,
_Values.value_sum AS Value_Sum,
_Values.value_text AS Value_Text
FROM gsm_ms_val AS _Values
INNER JOIN gsm_ms_cur AS _Current ON /* join condition not captured in parsed metadata */
INNER JOIN GSM_I_MD_METRIC_ACT_R AS _Metrics ON /* join condition not captured in parsed metadata */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA