I_AddlOwnrReplicationStatus

DDL: I_ADDLOWNRREPLICATIONSTATUS Type: view_entity BASIC Package: MDC_ADAPTER_REUSE
8 Fields 2 Data Sources

Replication status of messages

I_AddlOwnrReplicationStatus is a Basic CDS View that provides data about "Replication status of messages" in SAP S/4HANA. It reads from 2 data sources (mdg_bus_sys_tech, drfd_obj_rep_sta) and exposes 8 fields with key fields DRFReplicationStatusUUID, MDChgProcessSrceObjectTypeCode, MasterDataChangeProcess, MDChgProcessStep, MDChgProcessFederationDRFKey. Part of development package MDC_ADAPTER_REUSE.

Data Sources (2)

SourceAliasJoin Type
mdg_bus_sys_tech bus_sys inner
drfd_obj_rep_sta drfd_obj_rep_sta from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Replication status of messages view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY DRFReplicationStatusUUID drfd_obj_rep_sta rep_sta_id DRF GUID
KEY MDChgProcessSrceObjectTypeCode drfd_obj_rep_sta business_object Business Object
KEY MasterDataChangeProcess
KEY MDChgProcessStep
KEY MDChgProcessFederationDRFKey
KEY BusinessSystemName mdg_bus_sys_tech business_system Business System
KEY DataReplicationFrameworkRun drfd_obj_rep_sta run_id UUID
DRFReplicationStatus drfd_obj_rep_sta repstatus 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 I_AddlOwnrReplicationStatus.
-- 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_AddlOwnrReplicationStatus AS
SELECT
  drfd_obj_rep_sta.rep_sta_id AS DRFReplicationStatusUUID,
  drfd_obj_rep_sta.business_object AS MDChgProcessSrceObjectTypeCode,
  cast( substring(drfd_obj_rep_sta.object_id, 1, 12) as mdc_process_id ) AS MasterDataChangeProcess,
  cast( substring(drfd_obj_rep_sta.object_id, 13, 4) as mdc_process_step_no ) AS MDChgProcessStep,
  cast( substring(drfd_obj_rep_sta.object_id, 17, 32) as mdc_fed_drf_key ) AS MDChgProcessFederationDRFKey,
  bus_sys.business_system AS BusinessSystemName,
  drfd_obj_rep_sta.run_id AS DataReplicationFrameworkRun,
  drfd_obj_rep_sta.repstatus AS DRFReplicationStatus
FROM drfd_obj_rep_sta
INNER JOIN mdg_bus_sys_tech AS bus_sys ON /* join condition not captured in parsed metadata */
;

Learn More