DHRDB_API_METRIC

DDL: DHRDB_API_METRIC Type: view_entity Package: SADI_RDB_API
9 Fields 2 Data Sources

Provides statistical data for RDB

DHRDB_API_METRIC is a CDS View that provides data about "Provides statistical data for RDB" in SAP S/4HANA. It reads from 2 data sources (DHRDB_METRICS_BUFFER, dhrdb_statbuffer) and exposes 9 fields with key field buffer_id. Part of development package SADI_RDB_API.

Data Sources (2)

SourceAliasJoin Type
DHRDB_METRICS_BUFFER aggr inner
dhrdb_statbuffer stat from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Provides statistical data for RDB view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY buffer_id dhrdb_statbuffer buffer_id Buffer Table ID
objname dhrdb_statbuffer objname Table Name
objtype dhrdb_statbuffer objtype Translation OType
ProducerType dhrdb_statbuffer producer_type Producer Type Code
ProducerId dhrdb_statbuffer producer_id Registration ID
ConsumerType dhrdb_statbuffer consumer_type Consumer Type Code
CreatedAt dhrdb_statbuffer created_at Uploaded On
DeletedAt dhrdb_statbuffer deleted_at Time Stamp
data_read DHRDB_METRICS_BUFFER data_read

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_API_METRIC.
-- 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_API_METRIC AS
SELECT
  stat.buffer_id AS buffer_id,
  stat.objname AS objname,
  stat.objtype AS objtype,
  stat.producer_type AS ProducerType,
  stat.producer_id AS ProducerId,
  stat.consumer_type AS ConsumerType,
  stat.created_at AS CreatedAt,
  stat.deleted_at AS DeletedAt,
  aggr.data_read AS data_read
FROM dhrdb_statbuffer AS stat
INNER JOIN DHRDB_METRICS_BUFFER AS aggr ON /* join condition not captured in parsed metadata */
;

Learn More