C_IntcoValueChainMntrDocConncn

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 C_IntcoValueChainMntrDocConncn.
-- 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: CVCM_ICMDDCN

CREATE VIEW C_IntcoValueChainMntrDocConncn AS
SELECT
  Document.ValueChainInstanceUUID AS ValueChainInstanceUUID,
  Document.ValueChainStepInstanceUUID AS ValueChainStepInstanceUUID,
  Document.ValueChainDocumentItemOrigin AS ValueChainDocumentItemOrigin,
  Document.ValueChainBusinessObject AS ValueChainBusinessObject,
  Document.ValueChainStepPredecessorUUID AS ValueChainStepPredecessorUUID,
  Document.ValueChainPrdcssrDocItmOrigin AS ValueChainPrdcssrDocItmOrigin,
  Document.ValueChainPredecessorBusObj AS ValueChainPredecessorBusObj,
  _Predecessor.ValueChainStepBusinessObject AS ValueChainPredecessorStpBusObj,
  _Predecessor._StepBusObj._Text[1: Language = $session.system_language].ValueChainStepBusObjDesc AS ValueChainPrdcssrStpBusObjDesc,
  _Instance.ValueChainType AS ValueChainType,
  Document.IsReversalDocument AS IsReversalDocument,
  cast( '' as vcm_business_object_id ) AS DisplayIntcoValueChainDocument,
  cast( '' as vcm_business_object_id ) AS DisplayIntcoValChnPrdcssrDoc
FROM I_IntcoValChnDocConncn AS Document
LEFT OUTER JOIN C_IntcoValueChainDocumentTP AS _Predecessor ON _Predecessor.ValueChainStepInstanceUUID = ValueChainStepPredecessorUUID AND _Predecessor.ValueChainDocumentItemOrigin = ValueChainPrdcssrDocItmOrigin AND _Predecessor.ValueChainBusinessObject = ValueChainPredecessorBusObj AND _Predecessor.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..1]
;