P_ProcMonFlowKPICount

DDL: P_PROCMONFLOWKPICOUNT SQL: PPOCFLOWKPIC Type: view CONSUMPTION Package: BS_POC_CDS
33 Fields 1 Data Sources 2 Associations

Process Observer: Count KPIs for Process Flow

P_ProcMonFlowKPICount is a Consumption CDS View that provides data about "Process Observer: Count KPIs for Process Flow" in SAP S/4HANA. It reads from 1 data source (I_ProcMonKPI) and exposes 33 fields with key fields ProcObsvrProcessUUID, ProcObsvrKPIDefinition, ValuationNumber, ProcObsvrKPIDurnStartTaskUUID, ProcObsvrKPIDurnEndTaskUUID. It has 2 associations to related views. Part of development package BS_POC_CDS.

Data Sources (1)

SourceAliasJoin Type
I_ProcMonKPI KPI_log from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProcMonTaskLog _ProcMonTaskLog _ProcMonTaskLog.ProcObsvrTaskUUID = KPI_log.ProcObsvrTaskUUID
[0..1] P_ProcMonActivityBind _ActivityBind _ActivityBind.ProcObsvrProcessUUID = KPI_log.ProcObsvrProcessUUID and _ActivityBind.ProcObsvrTaskUUID = KPI_log.ProcObsvrTaskUUID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPOCFLOWKPIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Observer: Count KPIs for Process Flow view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID I_ProcMonKPI ProcObsvrProcessUUID Process Instance ID
KEY ProcObsvrKPIDefinition I_ProcMonKPI ProcObsvrKPIDefinition KPI Definition
KEY ValuationNumber I_ProcMonKPI ValuationNumber Valuation ID
KEY ProcObsvrKPIDurnStartTaskUUID
KEY ProcObsvrKPIDurnEndTaskUUID
KEY ProcObsvrKPICntDetmnrTaskUUID
ProcObsvrKPIDefDesc
ProcObsvrKPICategory I_ProcMonKPI ProcObsvrKPICategory
ProcObsvrProcessDefinition I_ProcMonKPI ProcObsvrProcessDefinition Process Def. ID
ProcObsvrKPICategoryName
ProcObsvrKPICount I_ProcMonKPI ProcObsvrKPICount
ProcObsvrKPIDurationInSeconds I_ProcMonKPI ProcObsvrKPIDurationInSeconds
DurationUnit I_ProcMonKPI DurationUnit Unit
DurationUnitName
ProcObsvrDurationThreshold ThresholdLog ProcObsvrDurationThreshold
ProcObsvrDurationThresholdUnit ThresholdLog ProcObsvrDurationThresholdUnit
ProcObsvrDurnThldUnitName
ProcObsvrThldNotifUTCDateTime ThresholdLog ProcObsvrThldNotifUTCDateTime
ProcObsvrThldNotifSystDate ThresholdLog ProcObsvrThldNotifSystDate
ProcObsvrThldNotifSystTime ThresholdLog ProcObsvrThldNotifSystTime
ProcObsvrCountThreshold ThresholdLog ProcObsvrCountThreshold
ProcObsvrStartActivityDef _ActivityBind ProcObsvrActivityDefinition
ProcObsvrStartActyDefName
ProcObsvrKPIDurnStrtBusObjType _ProcMonTaskLog SAPBusinessObjectType
StartSAPBusinessObjectTypeName
ProcObsvrDurnKPIStartBusObject _ProcMonTaskLog BusinessObject Business Object
StartBusinessObjectItem _ProcMonTaskLog BusinessObjectItem
ProcObsvrEndKPIDurnActivityDef
ProcObsvrEndActyDefName
ProcObsvrKPIDurnEndBusObjType
EndSAPBusinessObjectTypeName
ProcObsvrDurnKPIEndBusObject
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 P_ProcMonFlowKPICount.
-- 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: PPOCFLOWKPIC

CREATE VIEW P_ProcMonFlowKPICount AS
SELECT
  KPI_log.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  KPI_log.ProcObsvrKPIDefinition AS ProcObsvrKPIDefinition,
  KPI_log.ValuationNumber AS ValuationNumber,
  ' ' AS ProcObsvrKPIDurnStartTaskUUID,
  ' ' AS ProcObsvrKPIDurnEndTaskUUID,
  ' ' AS ProcObsvrKPICntDetmnrTaskUUID,
  _ProcMonKPIDefinition._Text[1:Language=$session.system_language].ProcObsvrKPIDefDesc AS ProcObsvrKPIDefDesc,
  KPI_log.ProcObsvrKPICategory AS ProcObsvrKPICategory,
  KPI_log.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  _ProcMonKPIDefinition._ProcMonKPICategory._Text[1:Language=$session.system_language].ProcObsvrKPICategoryName AS ProcObsvrKPICategoryName,
  KPI_log.ProcObsvrKPICount AS ProcObsvrKPICount,
  KPI_log.ProcObsvrKPIDurationInSeconds AS ProcObsvrKPIDurationInSeconds,
  KPI_log.DurationUnit AS DurationUnit,
  '' AS DurationUnitName,
  ThresholdLog.ProcObsvrDurationThreshold AS ProcObsvrDurationThreshold,
  ThresholdLog.ProcObsvrDurationThresholdUnit AS ProcObsvrDurationThresholdUnit,
  '' AS ProcObsvrDurnThldUnitName,
  ThresholdLog.ProcObsvrThldNotifUTCDateTime AS ProcObsvrThldNotifUTCDateTime,
  ThresholdLog.ProcObsvrThldNotifSystDate AS ProcObsvrThldNotifSystDate,
  ThresholdLog.ProcObsvrThldNotifSystTime AS ProcObsvrThldNotifSystTime,
  ThresholdLog.ProcObsvrCountThreshold AS ProcObsvrCountThreshold,
  _ActivityBind.ProcObsvrActivityDefinition AS ProcObsvrStartActivityDef,
  _ActivityBind._ActivityDefinition._Text[1:Language=$session.system_language].ProcObsvrActivityDefName AS ProcObsvrStartActyDefName,
  _ProcMonTaskLog.SAPBusinessObjectType AS ProcObsvrKPIDurnStrtBusObjType,
  _ProcMonTaskLog._ProcMonBusObjType._Text[1:Language=$session.system_language].SAPBusinessObjectTypeName AS StartSAPBusinessObjectTypeName,
  _ProcMonTaskLog.BusinessObject AS ProcObsvrDurnKPIStartBusObject,
  _ProcMonTaskLog.BusinessObjectItem AS StartBusinessObjectItem,
  '' AS ProcObsvrEndKPIDurnActivityDef,
  '' AS ProcObsvrEndActyDefName,
  '' AS ProcObsvrKPIDurnEndBusObjType,
  '' AS EndSAPBusinessObjectTypeName,
  '' AS ProcObsvrDurnKPIEndBusObject,
  '' AS EndBusinessObjectItem
FROM I_ProcMonKPI AS KPI_log
LEFT OUTER JOIN I_ProcMonTaskLog AS _ProcMonTaskLog ON _ProcMonTaskLog.ProcObsvrTaskUUID = KPI_log.ProcObsvrTaskUUID  -- association [0..1]
LEFT OUTER JOIN P_ProcMonActivityBind AS _ActivityBind ON _ActivityBind.ProcObsvrProcessUUID = KPI_log.ProcObsvrProcessUUID AND _ActivityBind.ProcObsvrTaskUUID = KPI_log.ProcObsvrTaskUUID  -- association [0..1]
;

Learn More