C_ProcMonAggPrc

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_ProcMonAggPrc.
-- 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: CPOCAGGPRC

CREATE VIEW C_ProcMonAggPrc AS
SELECT
  activity.ProcObsvrActivityUUID AS ProcObsvrActivityUUID,
  activity.SuccessorProcObsvrActivityUUID AS SuccessorProcObsvrActivityUUID,
  activity.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  activity.PrdcssrProcObsvrActivityDef AS PrdcssrProcObsvrActivityDef,
  activity.SuccessorProcObsvrActivityDef AS SuccessorProcObsvrActivityDef,
  activity._ActivityDefinition.ProcObsvrIsStartActivity AS ProcObsvrIsStartActivity,
  activity.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  activity._ProcMonProcessDefinition._Text[1:Language=$session.system_language].ProcObsvrProcessDefName AS ProcObsvrProcessDefName,
  activity._ActivityDefinition._Text[1:Language=$session.system_language].ProcObsvrActivityDefName AS ProcObsvrActivityDefName,
  activity.StartBusinessObject AS StartBusinessObject,
  activity.StartSAPBusinessObjectType AS StartSAPBusinessObjectType,
  activity.ProcObsvrProcessVariantHash AS ProcObsvrProcessVariantHash,
  activity.ProcObsvrProcessVariantLength AS ProcObsvrProcessVariantLength,
  activity.ProcObsvrCreationUTCDateTime AS ProcObsvrCreationUTCDateTime,
  activity.ProcObsvrCreationSystDate AS ProcObsvrCreationSystDate,
  activity.ProcObsvrCreationSystTime AS ProcObsvrCreationSystTime,
  activity.ProcObsvrFrmCrtnUTCDateTime AS ProcObsvrFrmCrtnUTCDateTime,
  activity.ProcObsvrFrmCrtnSystDate AS ProcObsvrFrmCrtnSystDate,
  activity.ProcObsvrFrmCrtnSystTime AS ProcObsvrFrmCrtnSystTime,
  activity.ProcObsvrToCrtnUTCDateTime AS ProcObsvrToCrtnUTCDateTime,
  activity.ProcObsvrToCrtnSystDate AS ProcObsvrToCrtnSystDate,
  activity.ProcObsvrToCrtnSystTime AS ProcObsvrToCrtnSystTime,
  _SalesOrder.SalesOrder AS SalesOrder,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.CreatedByUser AS CreatedByUser,
  _SalesOrder.CreationDate AS CreationDate,
  _SalesOrder.CreationTime AS CreationTime,
  _SalesOrder.LastChangeDate AS LastChangeDate,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  _SalesOrder.SalesGroup AS SalesGroup,
  _SalesOrder.SalesOffice AS SalesOffice,
  _SalesOrder.SoldToParty AS SoldToParty,
  _SalesOrder.CustomerGroup AS CustomerGroup,
  activity.ProcObsvrKPIDurationInSeconds AS ProcObsvrKPIDurationInSeconds,
  cast(cast(1 as abap.int8 ) as poc_edge_number) AS ProcObsvrNumberOfEdges
FROM P_ProcMonAggregatedPrcBind AS activity
LEFT OUTER JOIN I_Order2CashSalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = activity.StartBusinessObject  -- association [0..1]
LEFT OUTER JOIN C_ProcMonAggPrcActivity AS _ProcMonAggPrcActivity ON ProcObsvrProcessUUID = _ProcMonAggPrcActivity.ProcObsvrProcessUUID  -- association [1..*]
LEFT OUTER JOIN C_ProcMonE2EChain AS _ProcMonE2EChain ON ProcObsvrProcessDefinition = _ProcMonE2EChain.ProcObsvrProcessDefinition  -- association [1..*]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON salesordertype = _SalesDocumentType.SalesDocumentType  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON salesorganization = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON distributionchannel = _DistributionChannel.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON organizationdivision = _Division.Division  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON soldtoparty = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON salesgroup = _SalesGroup.SalesGroup  -- association [1..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON salesoffice = _SalesOffice.SalesOffice  -- association [1..1]
;