i_cbc_backsync_metrics

DDL: I_CBC_BACKSYNC_METRICS Type: view_entity Package: S_CBC_REV_METRICS

Backsync Metrics CDS View

i_cbc_backsync_metrics is a CDS View that provides data about "Backsync Metrics CDS View" in SAP S/4HANA. It reads from 3 data sources (pre_staging_hdr, backsync_metrics, scbc_l_rev) and exposes 5 fields. Part of development package S_CBC_REV_METRICS.

Data Sources (3)

SourceAliasJoin Type
pre_staging_hdr hdr left_outer
backsync_metrics metrics from
scbc_l_rev rev_hdr left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Backsync Metrics CDS View view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
context
created_date backsync_metrics created_date Time Stamp
record_count
payload_size
memory_used

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 i_cbc_backsync_metrics.
-- 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 i_cbc_backsync_metrics AS
SELECT
  case when rev_hdr.context is null then hdr.context else rev_hdr.context end AS context,
  metrics.created_date AS created_date,
  sum(metrics.record_count) AS record_count,
  sum(metrics.payload_size) AS payload_size,
  sum(metrics.memory_used) AS memory_used
FROM backsync_metrics AS metrics
LEFT OUTER JOIN pre_staging_hdr AS hdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scbc_l_rev AS rev_hdr ON /* join condition not captured in parsed metadata */
;