C_IntcoValueChainMntrDocTP

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_IntcoValueChainMntrDocTP.
-- 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 C_IntcoValueChainMntrDocTP AS
SELECT
  ValueChainStepInstanceUUID,
  ValueChainDocumentItemOrigin,
  ValueChainBusinessObject,
  ValueChainInstanceUUID,
  ValueChainStepBusinessObject,
  IntcoValueChainDocumentStatus,
  _Status.IntcoValueChainDocStsCritlty AS IntcoValueChainDocStsCritlty,
  ValueChainPredecessorStpBusObj,
  ValueChainStepPredecessorUUID,
  _Step.ValueChainStepType AS ValueChainStepType,
  _ValueChainStepType._StepTypeHierarchy.HierarchyLevel AS HierarchyLevel,
  _Step.ValueChainStepInstanceStatus AS ValueChainStepInstanceStatus,
  ValueChainStepInstceStsCritlty,
  _Schedule.ValueChnStpInstceSchedDateTime AS ValueChnStpInstceSchedDateTime,
  _Schedule.ValueChainStpInstceSchedStatus AS ValueChainStpInstceSchedStatus,
  ValChnPrdcssrBusObjIsHidden,
  ValChnBusObjIsHidden,
  IsReversalDocument,
  _StepBusObj.ValChnBusObjAttribCDSName AS ValChnBusObjAttribCDSName,
  _StepBusObj.ValChnBusObjItmAttribCDSName AS ValChnBusObjItmAttribCDSName,
  _StepBusObj.ValChnStpInbItmAttribCDSName AS ValChnStpInbItmAttribCDSName,
  ValueChainBusinessObjectCat,
  ValChainCalcStpChnElmntID,
  _Step.ValChnIsMultiStgePrptyHidden AS ValChnIsMultiStgePrptyHidden,
  ValChainProcessBlockTypeDesc,
  ValueChainStepChainElementID,
  ValChnStpChainElementPlantName,
  ValueChainProcessBlockType,
  ValueChainCategory,
  ValueChainScenarioID,
  _Instance.ValueChainType AS ValueChainType,
  _Instance.ValueChainTypeVersion AS ValueChainTypeVersion,
  virtual SemanticObject : vcm_semantic_object AS virtualSemanticObjectvcm_semantic_object,
  virtual IntcoValChnDocNavgnJSONStr : abap.string AS string,
  virtual Plant : werks_ext AS virtualPlantwerks_ext
FROM C_IntcoValueChainDocumentTP
LEFT OUTER JOIN C_IntcoValChnMntrPrdcssrItmTP AS _PredecessorItem ON _PredecessorItem.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID AND _PredecessorItem.ValueChainBusinessObject = ValueChainBusinessObject  -- association [0..*]
LEFT OUTER JOIN C_IntcoValueChainMntrDocConncn AS _Predecessor ON _Predecessor.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID AND _Predecessor.ValueChainDocumentItemOrigin = ValueChainDocumentItemOrigin AND _Predecessor.ValueChainBusinessObject = ValueChainBusinessObject AND _Predecessor.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..*]
LEFT OUTER JOIN C_ValueChainApplicationLog AS _Log ON _Log.ValueChainInstanceUUID = ValueChainInstanceUUID AND _Log.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID AND _Log.ValueChainBusinessObject = ValueChainBusinessObject  -- association [0..*]
LEFT OUTER JOIN C_ValueChainGraphFlow AS _GraphFlow ON _GraphFlow.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..*]
LEFT OUTER JOIN C_ValChnSwimLaneNetworkGraph AS _SwimLaneGraphFlow ON _SwimLaneGraphFlow.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..*]
;