dhrdb_metrics_tab_aggr

DDL: DHRDB_METRICS_TAB_AGGR Type: view_entity
8 Fields 1 Data Sources

Aggregated values of DHRDB_METRICS

dhrdb_metrics_tab_aggr is a CDS View that provides data about "Aggregated values of DHRDB_METRICS" in SAP S/4HANA. It reads from 1 data source (dhrdb_metrics) and exposes 8 fields with key fields buffer_id, package_id, value_name.

Data Sources (1)

SourceAliasJoin Type
dhrdb_metrics dhrdb_metrics from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Aggregated values of DHRDB_METRICS view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY buffer_id buffer_id Buffer Table ID
KEY package_id package_id Report Chain ID
KEY value_name value_name metric val name
min_value Value from table
max_value Value from table
sum_value Value from table
counter
one

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 dhrdb_metrics_tab_aggr.
-- 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 dhrdb_metrics_tab_aggr AS
SELECT
  buffer_id,
  package_id,
  value_name,
  min( cast( value as abap.int8 ) ) AS min_value,
  max( cast( value as abap.int8 ) ) AS max_value,
  sum( cast( value as abap.int8 ) ) AS sum_value,
  count( * ) AS counter,
  cast( 1 as abap.decfloat34 ) AS one
FROM dhrdb_metrics
;

Learn More