DHSQL_SYS_REPLICATION_STATUS

DDL: DHSQL_SYS_REPLICATION_STATUS Type: view_entity Package: SADI_SQL_SYS_REPL
10 Fields 1 Data Sources 1 OData Services

CDS View for Replication Status

DHSQL_SYS_REPLICATION_STATUS is a CDS View that provides data about "CDS View for Replication Status" in SAP S/4HANA. It reads from 1 data source (DHSQL_REPLICATION_STATUS) and exposes 10 fields. It is exposed through 1 OData service (DHSQL_SYS_REPLICATION_EXT). Part of development package SADI_SQL_SYS_REPL.

Data Sources (1)

SourceAliasJoin Type
DHSQL_REPLICATION_STATUS repl from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CDS View for Replication Status view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
DHSQL_SYS_REPLICATION_EXT

Fields (10)

KeyFieldSource TableSource FieldDescription
SCHEMA_NAME SqlServiceNameRaw Schema Name
OBJECT_NAME AliasNameRaw Object Name
SCHEMA_NAME_UPPER SqlServiceName Schema Name Upper
OBJECT_NAME_UPPER Objname Object Name Upper
REPLICATION_ID replication_id Replication ID
LOAD_TYPE Load_Type
REPLICATION_STATUS Status Replication Status
PHASE Phase Replication Phase
LAST_READ LastActionTs Last Read
LAST_QUEUE_UPDATE LastWriteTs Last Queue Update

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_STATUS.
-- 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_STATUS AS
SELECT
  SqlServiceNameRaw AS SCHEMA_NAME,
  AliasNameRaw AS OBJECT_NAME,
  SqlServiceName AS SCHEMA_NAME_UPPER,
  Objname AS OBJECT_NAME_UPPER,
  REPLICATION_ID,
  LOAD_TYPE,
  Status AS REPLICATION_STATUS,
  PHASE,
  LastActionTs AS LAST_READ,
  LastWriteTs AS LAST_QUEUE_UPDATE
FROM DHSQL_REPLICATION_STATUS AS repl
;

Learn More