GSM_I_MS_API_VALUES_ATTR_S_R

DDL: GSM_I_MS_API_VALUES_ATTR_S_R Type: view_entity Package: S_GSM_MS

GSM-MS: Metric Values (Attr. String)

GSM_I_MS_API_VALUES_ATTR_S_R is a CDS View that provides data about "GSM-MS: Metric Values (Attr. String)" in SAP S/4HANA. It reads from 2 data sources (GSM_I_MS_INT_ATTR_S_R, GSM_I_MS_API_VALUES_R) and exposes 16 fields with key fields Timestamp_Utc, Provider_Id, Metric_Id, Context_Id, Context_Type. Part of development package S_GSM_MS.

Data Sources (2)

SourceAliasJoin Type
GSM_I_MS_INT_ATTR_S_R _Attributes inner
GSM_I_MS_API_VALUES_R _Values from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label GSM-MS: Metric Values (Attr. String) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Timestamp_Utc GSM_I_MS_API_VALUES_R Timestamp_Utc Timestamp
KEY Provider_Id GSM_I_MS_API_VALUES_R Provider_Id Provider ID
KEY Metric_Id GSM_I_MS_API_VALUES_R Metric_Id Metric ID
KEY Context_Id GSM_I_MS_API_VALUES_R Context_Id Context ID
KEY Context_Type GSM_I_MS_API_VALUES_R Context_Type Context Type
KEY Attributes_Id GSM_I_MS_API_VALUES_R Attributes_Id Attributes ID
Attributes GSM_I_MS_INT_ATTR_S_R Attributes Dep. Attributes
Time_Period GSM_I_MS_API_VALUES_R Time_Period Time Period in Month
Value_Timestamp GSM_I_MS_API_VALUES_R Value_Timestamp Time Stamp
Value_Rating GSM_I_MS_API_VALUES_R Value_Rating Rating
Value_Count GSM_I_MS_API_VALUES_R Value_Count Metric Value
Value_Max GSM_I_MS_API_VALUES_R Value_Max Metric Value
Value_Min GSM_I_MS_API_VALUES_R Value_Min Metric Value
Value_Sum GSM_I_MS_API_VALUES_R Value_Sum Metric Value
Value_Text GSM_I_MS_API_VALUES_R Value_Text Metric Value Text
Target_Type GSM_I_MS_API_VALUES_R Target_type Target Type

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_MS_API_VALUES_ATTR_S_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_MS_API_VALUES_ATTR_S_R AS
SELECT
  _Values.Timestamp_Utc AS Timestamp_Utc,
  _Values.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,
  _Attributes.Attributes AS Attributes,
  _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,
  _Values.Target_type AS Target_Type
FROM GSM_I_MS_API_VALUES_R AS _Values
INNER JOIN GSM_I_MS_INT_ATTR_S_R AS _Attributes ON /* join condition not captured in parsed metadata */
;