C_ProcMonFlow

DDL: C_PROCMONFLOW SQL: CPOCFLOW Type: view CONSUMPTION
29 Fields 2 Data Sources 7 Associations 3 Fiori Apps

Process Observer: Process Flow

C_ProcMonFlow is a Consumption CDS View that provides data about "Process Observer: Process Flow" in SAP S/4HANA. It reads from 2 data sources (I_ProcMonActivity, I_ProcMonSequence) and exposes 29 fields with key fields ProcObsvrProcessUUID, ProcObsvrActivityDefinition, ProcObsvrTaskUUID, SuccessorProcObsvrActivity. It has 7 associations to related views. It is used in 3 Fiori applications: Business Process Activities, Order-to-Cash Performance, Order-to-Cash Performance Monitor - Time Series.

Data Sources (2)

SourceAliasJoin Type
I_ProcMonActivity Activity from
I_ProcMonSequence Sequence left_outer

Associations (7)

CardinalityTargetAliasCondition
[0..*] C_ProcMonPhase _ProcMonPhase Process.ProcObsvrProcessUUID = _ProcMonPhase.ProcObsvrProcessUUID and Activity.ProcObsvrProcessDefinition = _ProcMonPhase.ProcObsvrProcessDefinition
[0..*] C_ProcMonFlowActivity _ProcMonFlowActivity _ProcMonFlowActivity.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID
[0..*] C_ProcMonFlowKPI _ProcMonFlowKPI _ProcMonFlowKPI.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID
[0..*] C_ProcMonFlowProcess _ProcMonFlowProcess _ProcMonFlowProcess.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID
[0..*] C_ProcMonFlowAggKPI _ProcMonFlowAggKPI _ProcMonFlowAggKPI.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID
[0..*] C_ProcMonFlowTask _ProcMonFlowTask _ProcMonFlowTask.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID
[0..*] C_ProcMonFederation _ProcMonFederation _ProcMonFederation.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPOCFLOW view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Process Observer: Process Flow view
VDM.viewType #CONSUMPTION view
OData.publish true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fiori Apps (3)

App IDApp NameTypeDescription
F1609 Business Process Activities Analytical The business process activities app provides a graphical overview of the chain of connected process steps (activities) and corresponding business objects, viewed from a business perspective. It focuses on a specific start business object for the process flow, for example, sales order, displays activities and process performance KPIs, like totals and lead times.
F2005 Order-to-Cash Performance Analytical Order-to-Cash Performance allows to analyze and drill-down order to cash process performance KPIs like totals and lead times by sales order dimensions like sales organization, distribution channel, division, customer, material for a preconfigured period of time (default last 28 days).
F2006 Order-to-Cash Performance Monitor - Time Series Analytical Order-to-Cash Performance Monitor allows to analyze and drilldown order to cash process performance KPIs like totals and lead times by sales order dimensions like sales organization, distribution channel, division, customer, material for a preconfigured period of time (default last 28 days) for the last 365 days.

Business Process Activities

Business Role: Order-to-Cash Process Manager

This app helps you, as a manager or owner of your company’s order-to-cash process, to get a comprehensive overview of the performance and conformity of all the sales order processes in your company. It provides key figures with respect to the duration of certain process steps in the order-to-cash process as well as to the number of occurrences of important events that have been triggered during process execution. With the help of these key figures you can easily determine the health status of your sales process and find potential areas of improvement at a glance.

Order-to-Cash Performance

Business Role: Order-to-Cash Process Manager

This app helps you, as a manager or owner of your company’s order-to-cash process, to get a comprehensive overview of the performance and conformity of all the sales order processes in your company. It provides key figures with respect to the duration of certain process steps in the order-to-cash process as well as to the number of occurrences of important events that have been triggered during process execution. With the help of these key figures you can easily determine the health status of your sales process and find potential areas of improvement at a glance.

Order-to-Cash Performance Monitor - Time Series

Business Role: Order-to-Cash Process Manager

This app helps you, as a manager or owner of your company’s order-to-cash process, to get a comprehensive overview of the performance and conformity of all the sales order processes in your company. It provides key figures with respect to the duration of certain process steps in the order-to-cash process as well as to the number of occurrences of important events that have been triggered during process execution. With the help of these key figures you can easily determine the health status of your sales process and find potential areas of improvement at a glance.

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID Process ProcObsvrProcessUUID
KEY ProcObsvrActivityDefinition I_ProcMonActivity ProcObsvrActivityDefinition Activity ID
KEY ProcObsvrTaskUUID agg LastExecutedTaskUUID
KEY SuccessorProcObsvrActivity I_ProcMonSequence SuccessorProcObsvrActivity Next Activity
ProcObsvrProcessDefinition I_ProcMonActivity ProcObsvrProcessDefinition Process Def. ID
ProcObsvrProcessDefVersion I_ProcMonActivity ProcObsvrProcessDefVersion Process Version
ProcObsvrProcessDefName
ProcObsvrIsStartActivity I_ProcMonActivity ProcObsvrIsStartActivity Process Start
ProcObsvrIsEndActivity I_ProcMonActivity ProcObsvrIsEndActivity
ProcObsvrActivityDefName
ProcObsvrNmbrOfExecutedActy NoOfActivityExecutions
ProcObsvrActivityUUID actInst ProcObsvrActivityUUID
BusinessObject actInst BusinessObject Business Object
SAPBusinessObjectType actInst SAPBusinessObjectType
SAPBusinessObjectTypeName
BusinessObjectItem actInst BusinessObjectItem
CreatedByUser actInst CreatedByUser User Name
PersonFullName
ProcObsvrCreationUTCDateTime _ProcMonActivity ProcObsvrCreationUTCDateTime
ProcObsvrCreationSystDate _ProcMonActivity ProcObsvrCreationSystDate
ProcObsvrCreationSystTime _ProcMonActivity ProcObsvrCreationSystTime
ProcObsvrPhase I_ProcMonActivity ProcObsvrPhase Step
_ProcMonPhase _ProcMonPhase
_ProcMonFlowActivity _ProcMonFlowActivity
_ProcMonFlowProcess _ProcMonFlowProcess
_ProcMonFlowKPI _ProcMonFlowKPI
_ProcMonFlowAggKPI _ProcMonFlowAggKPI
_ProcMonFlowTask _ProcMonFlowTask
_ProcMonFederation _ProcMonFederation

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_ProcMonFlow.
-- 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: CPOCFLOW

CREATE VIEW C_ProcMonFlow AS
SELECT
  Process.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  Activity.ProcObsvrActivityDefinition AS ProcObsvrActivityDefinition,
  agg.LastExecutedTaskUUID AS ProcObsvrTaskUUID,
  Sequence.SuccessorProcObsvrActivity AS SuccessorProcObsvrActivity,
  Activity.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  Activity.ProcObsvrProcessDefVersion AS ProcObsvrProcessDefVersion,
  _ProcMonProcessDefinition._Text[1:Language=$session.system_language].ProcObsvrProcessDefName AS ProcObsvrProcessDefName,
  Activity.ProcObsvrIsStartActivity AS ProcObsvrIsStartActivity,
  Activity.ProcObsvrIsEndActivity AS ProcObsvrIsEndActivity,
  Activity._Text[1:Language=$session.system_language].ProcObsvrActivityDefName AS ProcObsvrActivityDefName,
  NoOfActivityExecutions AS ProcObsvrNmbrOfExecutedActy,
  actInst.ProcObsvrActivityUUID AS ProcObsvrActivityUUID,
  actInst.BusinessObject AS BusinessObject,
  actInst.SAPBusinessObjectType AS SAPBusinessObjectType,
  actInst._ProcMonBusObjType._Text[1:Language=$session.system_language].SAPBusinessObjectTypeName AS SAPBusinessObjectTypeName,
  actInst.BusinessObjectItem AS BusinessObjectItem,
  actInst.CreatedByUser AS CreatedByUser,
  actInst._User.UserDescription AS PersonFullName,
  _ProcMonActivity.ProcObsvrCreationUTCDateTime AS ProcObsvrCreationUTCDateTime,
  _ProcMonActivity.ProcObsvrCreationSystDate AS ProcObsvrCreationSystDate,
  _ProcMonActivity.ProcObsvrCreationSystTime AS ProcObsvrCreationSystTime,
  Activity.ProcObsvrPhase AS ProcObsvrPhase
FROM I_ProcMonActivity AS Activity
LEFT OUTER JOIN I_ProcMonSequence AS Sequence ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ProcMonPhase AS _ProcMonPhase ON Process.ProcObsvrProcessUUID = _ProcMonPhase.ProcObsvrProcessUUID AND Activity.ProcObsvrProcessDefinition = _ProcMonPhase.ProcObsvrProcessDefinition  -- association [0..*]
LEFT OUTER JOIN C_ProcMonFlowActivity AS _ProcMonFlowActivity ON _ProcMonFlowActivity.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonFlowKPI AS _ProcMonFlowKPI ON _ProcMonFlowKPI.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonFlowProcess AS _ProcMonFlowProcess ON _ProcMonFlowProcess.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonFlowAggKPI AS _ProcMonFlowAggKPI ON _ProcMonFlowAggKPI.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonFlowTask AS _ProcMonFlowTask ON _ProcMonFlowTask.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID  -- association [0..*]
LEFT OUTER JOIN C_ProcMonFederation AS _ProcMonFederation ON _ProcMonFederation.ProcObsvrProcessUUID = Process.ProcObsvrProcessUUID  -- association [0..*]
;

Learn More