I_MDODRFDistributionStatus

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_MDODRFDistributionStatus.
-- 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.
-- SQL view name: IMDODRFDISTRSTAT

CREATE VIEW I_MDODRFDistributionStatus AS
SELECT
  _t2.rep_sta_id AS id,
  _t3.business_system AS BusinessSystem,
  _t1.bus_sys_id AS BusinessSystemId,
  _t2.repstatus AS ReplicationStatus,
  _t2.msg_guid AS MessageId,
  _t2.last_replication AS LastStatusChange,
  _t2.run_id AS DistributionRunId,
  _t2.log_hndl AS ApplicationLogId,
  _t2.business_object AS BusinessObjectType,
  cast ( _t2.object_id as mdo_objectinstancekey ) AS ObjectInstanceKey
FROM drfd_replication AS _t1
INNER JOIN drfd_obj_rep_sta AS _t2 ON /* join condition not captured in parsed metadata */
INNER JOIN mdg_bus_sys_tech AS _t3 ON /* join condition not captured in parsed metadata */
INNER JOIN I_MDOLatestDistributionStatus AS _t4 ON /* join condition not captured in parsed metadata */
;