C_IntcoValueChainMntrDocItmTP

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_IntcoValueChainMntrDocItmTP.
-- 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_IntcoValueChainMntrDocItmTP AS
SELECT
  ValueChainStepInstanceUUID,
  ValueChainDocumentItemOrigin,
  ValueChainBusinessObject,
  ValueChainBusinessObjectItem,
  ValueChainBusinessObjectCat,
  Item.ValChainProcessBlockTypeDesc AS ValChainProcessBlockTypeDesc,
  _Document._Step.ValueChainStepChainElementID AS ValueChainStepChainElementID,
  _Document.ValChnStpChainElementPlantName AS ValChnStpChainElementPlantName,
  _Document._Step.ValChnIsMultiStgePrptyHidden AS ValChnIsMultiStgePrptyHidden,
  _Document._Step.ValChainCalcStpChnElmntID AS ValChainCalcStpChnElmntID,
  ValueChainInstanceUUID,
  ValueChainItemUUID,
  IsReversalDocument,
  ValueChainStepBusinessObject,
  IntcoValueChainDocItmStatus,
  _Status.IntcoValChnDocItmStsCritlty AS IntcoValChnDocItmStsCritlty,
  _Document._Step.ValueChainStepType AS ValueChainStepType,
  _Document._Step.ValueChainStepInstanceStatus AS ValueChainStepInstanceStatus,
  _Document.ValueChainStepInstceStsCritlty AS ValueChainStepInstceStsCritlty,
  ValueChainPredecessorBusObj,
  ValueChainPrdcssrBusObjItem,
  ValueChainPredecessorStpBusObj,
  _Document._Step.ValueChainStepPredecessorUUID AS ValueChainStepPredecessorUUID,
  _Document._StepBusObj.ValChnBusObjAttribCDSName AS ValChnBusObjAttribCDSName,
  _Document._StepBusObj.ValChnBusObjItmAttribCDSName AS ValChnBusObjItmAttribCDSName,
  _Document._StepBusObj.ValChnStpInbItmAttribCDSName AS ValChnStpInbItmAttribCDSName,
  Product,
  ProductHierarchy,
  ValueChainInitiatingPlant,
  ValueChainDeliveringPlant,
  TransitPlant,
  ShippingPoint,
  ShippingCondition,
  virtual Plant : werks_ext AS virtualPlantwerks_ext,
  virtual ValueChainBusObjDescription : abap.string AS string,
  virtual SemanticObject : vcm_semantic_object AS virtualSemanticObjectvcm_semantic_object
FROM C_IntcoValueChainDocumentItmTP
LEFT OUTER JOIN C_IntcoValChnMntrDocItmHier AS _ProcessStep ON _ProcessStep.ValueChainItemUUID = ValueChainItemUUID  -- association [0..*]
LEFT OUTER JOIN C_ValueChainApplicationLog AS _Log ON _Log.ValueChainInstanceUUID = ValueChainInstanceUUID AND _Log.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID AND _Log.ValueChainBusinessObject = ValueChainBusinessObject AND _Log.ValueChainBusinessObjectItem = ValueChainBusinessObjectItem  -- association [0..*]
LEFT OUTER JOIN C_IntcoValueChainMntrDocItmTP AS _Node ON _Node.ValueChainItemUUID = ValueChainItemUUID  -- association [0..*]
LEFT OUTER JOIN C_IntcoValChnMntrDocItmConncn AS _Connection ON _Connection.ValueChainItemUUID = ValueChainItemUUID  -- 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..*]
;