DHSQL_REPLICATION_STATUS

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_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_REPLICATION_STATUS AS
SELECT
  repln.sql_service_name AS SqlServiceName,
  repln.alias_name AS Objname,
  coalesce( repls.sql_service_name_raw, repln.sql_service_name ) AS SqlServiceNameRaw,
  coalesce( repls.external_entity_name_raw, repln.alias_name ) AS AliasNameRaw,
  cast( case when repln.status = 'E' then 'ERROR' when repln.action = 'C' and repln.status = ' ' then 'PREPARING' when repln.action = 'C' and repln.status = 'I' then 'PREPARING' when stat.Status is null then 'PREPARING' when stat.Status = 'E' then 'ERROR' when stat.Status <> 'R' then 'DOES_NOT_EXIST' when stat.WriteBlocked = 'X' then 'FULL' else 'READY' end as abap.char(20) ) as Status AS char20asStatus,
  cast( case when stat.PrioReadEnabled is null then 'PREPARING' when stat.PrioReadEnabled = '' and repln.process_option <> 'I' then 'DELTA' when stat.PrioWriteFinished <> 'X' then 'INITIAL_LOAD' else 'END_OF_INITIAL' end as abap.char(20) ) as Phase AS char20asPhase,
  stat.LastWriteTs AS LastWriteTs,
  stat.LastActionTs AS LastActionTs,
  repln.uname AS uname
FROM dhsql_replicatn AS repln
;