I_ConfignRevsn

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_ConfignRevsn.
-- 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_ConfignRevsn AS
SELECT
  tgts.revision_id AS ConfignRevsnUUID,
  tgts.target_id AS ConfigurationRevisionTarget,
  rev.receiver_type AS ConfignRevsnReceiverType,
  rev.context AS ConfignRevsnContext,
  rev.group_id AS ConfigurationRevisionGroup,
  rev.transaction_code AS ConfignRevsnTransaction,
  tgts.status AS ConfignRevsnStatus,
  tgts.ext_status AS ConfignRevsnExternalStatusCode,
  tgts.notification_id AS ConfignRevsnNotification,
  rev.created_on AS CreationDateTime,
  rev.created_by AS CreatedBy,
  tgts.changed_on AS LastChangeDateTime,
  tgts.changed_by AS LastChangedBy,
  tgts.pulled_on AS ConfignRevsnPulledDateTime,
  tgts.failed_count AS ConfignRevsnFailedCount,
  rev.sw_version_hashkey AS ConfignRevsnSwVersHashKey
FROM scbc_l_rev_tgt_s AS tgts
INNER JOIN scbc_l_rev AS rev ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ConfignRevsnTarget AS _ConfignRevsnTarget ON ConfigurationRevisionTarget = _ConfignRevsnTarget.ConfigurationRevisionTarget  -- association [1..1]
LEFT OUTER JOIN I_ConfignRevsnSwVersion AS _SoftwareVersion ON ConfignRevsnSwVersHashKey = _SoftwareVersion.ConfignRevsnSwVersionHashKey  -- association [0..1]
LEFT OUTER JOIN I_ConfignRevsnRequest AS _ConfignRevsnRequest ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ConfignRevsnDeltaLog AS _ConfignRevsnDeltaLog ON /* condition not available in parsed metadata */  -- association [0..*]
;