DHSQL_SYS_REPLICATION_METRIC

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 DHSQL_SYS_REPLICATION_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 DHSQL_SYS_REPLICATION_METRIC AS
SELECT
  REPLICATION_ID,
  schema_name_raw AS SCHEMA_NAME,
  object_name_raw AS OBJECT_NAME,
  schema_name AS SCHEMA_NAME_UPPER,
  object_name AS OBJECT_NAME_UPPER,
  PACKAGE_SIZE,
  avg_package_size / 1048576 AS AVG_PACKAGE_SIZE,
  PROCESSED_RECORDS,
  PROCESSED_PACKAGES,
  process_data / 1048576 AS PROCESS_DATA,
  PACKAGE_READS,
  data_read / 1048576 AS DATA_READ,
  AVG_PACKAGE_LIFESPAN,
  CREATED_AT
FROM DHSQL_REPLICATION_METRIC AS repl
;