C_IntcoValueChainMntrHdrTP

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_IntcoValueChainMntrHdrTP.
-- 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_IntcoValueChainMntrHdrTP AS
SELECT
  ValueChainInstanceUUID,
  ValueChainInstanceStartDate,
  ValueChainInstanceStrtDateTime,
  ValueChainType,
  ValueChainTypeVersion,
  ValueChainInstanceStatus,
  ValueChainInstanceStsCritlty,
  ValueChainBusinessObject,
  ValChnBusObjForSrch,
  ValueChainStepBusinessObject,
  FinancialChain,
  ValueChainIsFinChainHidden,
  ReceivingPlant,
  DeliveringPlant,
  virtual SemanticObject : vcm_semantic_object AS virtualSemanticObjectvcm_semantic_object,
  virtual IntcoValChnDocNavgnJSONStr : abap.string AS string,
  virtual DeliveryDocument : vbeln_vl AS virtualDeliveryDocumentvbeln_vl,
  virtual BillingDocument : vbeln_vf AS virtualBillingDocumentvbeln_vf,
  virtual DeliveryCreationDate : erdat AS virtualDeliveryCreationDateerdat,
  virtual Product : productnumber AS virtualProductproductnumber,
  virtual ProductHierarchy : prodh_d AS virtualProductHierarchyprodh_d,
  virtual OverallGoodsMovementStatus : wbstk AS virtualOverallGoodsMovementStatuswbstk,
  virtual ShippingPoint : vstel AS virtualShippingPointvstel,
  virtual ActualGoodsMovementDate : wadat_ist AS virtualActualGoodsMovementDatewadat_ist,
  virtual PlannedGoodsIssueDate : wadak_plan AS virtualPlannedGoodsIssueDatewadak_plan,
  virtual DeliveryDate : lfdat_v AS virtualDeliveryDatelfdat_v,
  virtual ShipToParty : kunnr AS virtualShipToPartykunnr,
  virtual ShipToCountry : land1 AS virtualShipToCountryland1,
  virtual SoldToParty : kunag AS virtualSoldToPartykunag,
  virtual SalesOrganization : vkorg AS virtualSalesOrganizationvkorg,
  virtual DistributionChannel : vtweg AS virtualDistributionChannelvtweg,
  virtual ShippingCondition : vsbed AS virtualShippingConditionvsbed,
  virtual SalesOrderDate : audat AS virtualSalesOrderDateaudat,
  virtual PurchasingOrganization : ekorg_ll AS virtualPurchasingOrganizationekorg_ll,
  virtual Supplier : md_supplier AS virtualSuppliermd_supplier,
  virtual PurchaseOrderDate : bedat AS virtualPurchaseOrderDatebedat,
  virtual TransitPlant : werks_ext AS virtualTransitPlantwerks_ext,
  virtual SystemMessageClass : arbgb AS virtualSystemMessageClassarbgb,
  virtual SystemMessageNumber : msgnr AS virtualSystemMessageNumbermsgnr,
  DocumentCreatedByUser,
  CreatedByUserFullName
FROM C_IntcoValueChainInstanceTP
LEFT OUTER JOIN C_IntcoValueChainMntrDocConncn AS _Connection ON _Connection.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..*]
LEFT OUTER JOIN C_IntcoValueChainMntrProcStep AS _Step ON _Step.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..*]
LEFT OUTER JOIN C_ValueChainMessage AS _Message ON _Message.ValueChainInstanceUUID = ValueChainInstanceUUID  -- 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..*]
LEFT OUTER JOIN C_ValChnFinancialChainStepFltr AS _FinancialChainStep ON _FinancialChainStep.FinancialChain = FinancialChain AND( _FinancialChainStep.Plant != DeliveringPlant AND _FinancialChainStep.Plant != ReceivingPlant )  -- association [0..*]
LEFT OUTER JOIN C_IntcoValueChainStepMessage AS _StepMessage ON _StepMessage.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [1..*]
;