GSM_I_MS_API_VALUES_R

CDS View

GSM-MS: Metric Values

GSM_I_MS_API_VALUES_R is a CDS View in S/4HANA. GSM-MS: Metric Values. It contains 15 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
GSM_C_MS_AS_CPU_USAGE_PCT_R view_entity from GSM-MS-AS-ABAP: CPU Utilization in Prcnt
GSM_C_MS_AS_DB_PERF_R view_entity from GSM-MS-AS-ABAP: ABAP Database Perf.
GSM_C_MS_AS_DB_PERF_R view_entity inner GSM-MS-AS-ABAP: ABAP Database Perf.
GSM_I_MS_API_VALUES_ATTR_E_R view_entity from GSM-MS: Metric Values (Attr. String)
GSM_I_MS_API_VALUES_ATTR_S_R view_entity from GSM-MS: Metric Values (Attr. String)
tmo_exp_i_tgpr_run view from Telemetry Provider Run Time Data
tmo_exp_i_tgpr_run view inner Telemetry Provider Run Time Data
TMO_HM_C_EMAIL_ERRORS_R view_entity from CDS View Email Errors
TMO_I_TA_CPU_UTILIZATION_R view from SMN: Aggregated CPU Utilization

Fields (15)

KeyField CDS FieldsUsed in Views
KEY Attributes_Id Attributes_Id 4
KEY Context_Id Context_Id,Instance_Name 5
KEY Context_Type Context_Type 3
KEY Metric_Id Metric_Id 3
KEY Provider_Id Provider_Id 3
KEY Target_type Target_Type 5
KEY Timestamp_Utc Timestamp_Utc 5
Time_Period Time_Period 3
Value_Count Value_Count 2
Value_Max Run_Time,Value_Max,Value_Total 4
Value_Min Value_Min 2
Value_Rating Value_Rating 2
Value_Sum Avg_Time_Db_Client_Us,Value_Errors,Value_Sum 5
Value_Text Value_Text 2
Value_Timestamp Value_Timestamp 3

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSM_I_MS_API_VALUES_R (
    ATTRIBUTES_ID,
    CONTEXT_ID,
    CONTEXT_TYPE,
    METRIC_ID,
    PROVIDER_ID,
    TARGET_TYPE,
    TIMESTAMP_UTC,
    TIME_PERIOD,
    VALUE_COUNT,
    VALUE_MAX,
    VALUE_MIN,
    VALUE_RATING,
    VALUE_SUM,
    VALUE_TEXT,
    VALUE_TIMESTAMP,
    PRIMARY KEY (ATTRIBUTES_ID, CONTEXT_ID, CONTEXT_TYPE, METRIC_ID, PROVIDER_ID, TARGET_TYPE, TIMESTAMP_UTC)
);