C_ProcMonFlowKPI

DDL: C_PROCMONFLOWKPI SQL: CPOCFLOWKPI Type: view CONSUMPTION
32 Fields 2 Data Sources

Process Observer: KPIs for Process Flow

C_ProcMonFlowKPI is a Consumption CDS View that provides data about "Process Observer: KPIs for Process Flow" in SAP S/4HANA. It reads from 2 data sources (P_ProcMonFlowKPICount, P_ProcMonFlowKPIDuration) and exposes 32 fields with key fields ProcObsvrKPIDefinition, ValuationNumber, ProcObsvrKPIDurnStartTaskUUID, ProcObsvrKPIDurnEndTaskUUID, ProcObsvrKPICntDetmnrTaskUUID.

Data Sources (2)

SourceAliasJoin Type
P_ProcMonFlowKPICount P_ProcMonFlowKPICount union_all
P_ProcMonFlowKPIDuration P_ProcMonFlowKPIDuration from

Annotations (9)

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

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrKPIDefinition ProcObsvrKPIDefinition
KEY ValuationNumber ValuationNumber
KEY ProcObsvrKPIDurnStartTaskUUID ProcObsvrKPIDurnStartTaskUUID
KEY ProcObsvrKPIDurnEndTaskUUID ProcObsvrKPIDurnEndTaskUUID
KEY ProcObsvrKPICntDetmnrTaskUUID ProcObsvrKPICntDetmnrTaskUUID
ProcObsvrKPIDefDesc ProcObsvrKPIDefDesc
ProcObsvrKPICategory ProcObsvrKPICategory
ProcObsvrProcessDefinition ProcObsvrProcessDefinition
ProcObsvrKPICategoryName ProcObsvrKPICategoryName
ProcObsvrKPICount
ProcObsvrKPIDurationInSeconds ProcObsvrKPIDurationInSeconds
DurationUnit DurationUnit Unit
DurationUnitName DurationUnitName
ProcObsvrDurationThreshold ProcObsvrDurationThreshold
ProcObsvrDurationThresholdUnit ProcObsvrDurationThresholdUnit
ProcObsvrDurnThldUnitName ProcObsvrDurnThldUnitName
ProcObsvrThldNotifUTCDateTime ProcObsvrThldNotifUTCDateTime
ProcObsvrThldNotifSystDate ProcObsvrThldNotifSystDate
ProcObsvrThldNotifSystTime ProcObsvrThldNotifSystTime
ProcObsvrCountThreshold ProcObsvrCountThreshold
ProcObsvrStartActivityDef ProcObsvrStartActivityDef
ProcObsvrStartActyDefName ProcObsvrStartActyDefName
ProcObsvrKPIDurnStrtBusObjType ProcObsvrKPIDurnStrtBusObjType
StartSAPBusinessObjectTypeName StartSAPBusinessObjectTypeName
ProcObsvrDurnKPIStartBusObject ProcObsvrDurnKPIStartBusObject Business Object
StartBusinessObjectItem StartBusinessObjectItem
ProcObsvrEndKPIDurnActivityDef ProcObsvrEndKPIDurnActivityDef
ProcObsvrEndActyDefName ProcObsvrEndActyDefName
ProcObsvrKPIDurnEndBusObjType ProcObsvrKPIDurnEndBusObjType
EndSAPBusinessObjectTypeName EndSAPBusinessObjectTypeName
ProcObsvrDurnKPIEndBusObject ProcObsvrDurnKPIEndBusObject
EndBusinessObjectItem EndBusinessObjectItem

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_ProcMonFlowKPI.
-- 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: CPOCFLOWKPI

CREATE VIEW C_ProcMonFlowKPI AS
SELECT
  ProcObsvrKPIDefinition,
  ValuationNumber,
  ProcObsvrKPIDurnStartTaskUUID,
  ProcObsvrKPIDurnEndTaskUUID,
  ProcObsvrKPICntDetmnrTaskUUID,
  ProcObsvrKPIDefDesc,
  ProcObsvrKPICategory,
  ProcObsvrProcessDefinition,
  ProcObsvrKPICategoryName,
  sum(ProcObsvrKPICount) AS ProcObsvrKPICount,
  ProcObsvrKPIDurationInSeconds,
  DurationUnit,
  DurationUnitName,
  ProcObsvrDurationThreshold,
  ProcObsvrDurationThresholdUnit,
  ProcObsvrDurnThldUnitName,
  ProcObsvrThldNotifUTCDateTime,
  ProcObsvrThldNotifSystDate,
  ProcObsvrThldNotifSystTime,
  ProcObsvrCountThreshold,
  ProcObsvrStartActivityDef,
  ProcObsvrStartActyDefName,
  ProcObsvrKPIDurnStrtBusObjType,
  StartSAPBusinessObjectTypeName,
  ProcObsvrDurnKPIStartBusObject,
  StartBusinessObjectItem,
  ProcObsvrEndKPIDurnActivityDef,
  ProcObsvrEndActyDefName,
  ProcObsvrKPIDurnEndBusObjType,
  EndSAPBusinessObjectTypeName,
  ProcObsvrDurnKPIEndBusObject,
  EndBusinessObjectItem
FROM P_ProcMonFlowKPIDuration
-- UNION ALL with additional select branch(es): P_ProcMonFlowKPICount
;

Learn More