GSM_I_MSC_INT_VALUES_R

DDL: GSM_I_MSC_INT_VALUES_R Type: view_entity

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)

SourceAliasJoin Type
gsm_ms_cur _Current inner
GSM_I_MD_METRIC_ACT_R _Metrics inner
gsm_ms_val _Values from

Annotations (6)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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 */
;