I_ProcMonKPI

DDL: I_PROCMONKPI SQL: IPOCKPIALL Type: view BASIC
20 Fields 1 Data Sources 5 Associations

Process Observer: All KPIs

I_ProcMonKPI is a Basic CDS View that provides data about "Process Observer: All KPIs" in SAP S/4HANA. It reads from 1 data source (poc_d_kpi_log2) and exposes 20 fields with key fields ProcObsvrProcessUUID, ProcObsvrKPIDefinition, ValuationNumber, ProcObsvrTaskUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
poc_d_kpi_log2 KPI from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_ProcMonProcessDefinition _ProcMonProcessDefinition $projection.ProcObsvrKPIDefinition = _ProcMonProcessDefinition.ProcObsvrProcessDefinition
[0..1] I_ProcMonKPIDefinition _ProcMonKPIDefinition $projection.ProcObsvrProcessDefinition = _ProcMonKPIDefinition.ProcObsvrProcessDefinition and $projection.ProcObsvrProcessDefVersion = _ProcMonKPIDefinition.ProcObsvrProcessDefVersion and $projection.ProcObsvrKPIDefinition = _ProcMonKPIDefinition.ProcObsvrKPIDefinition
[0..1] I_ProcMonProcessStatus _ProcObsvrProcessStatus $projection.ProcObsvrProcessStatus = _ProcObsvrProcessStatus.ProcObsvrProcessStatus
[0..1] I_ProcMonFreeDefinedStatus _ProcMonFreeDefinedStatus $projection.ProcObsvrProcessDefinition = _ProcMonFreeDefinedStatus.ProcObsvrProcessDefinition and $projection.ProcObsvrFreeDefinedStatus = _ProcMonFreeDefinedStatus.ProcObsvrFreeDefinedStatus
[0..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = $projection.DurationUnit

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPOCKPIALL view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Observer: All KPIs view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID process_id Process Instance ID
KEY ProcObsvrKPIDefinition poc_d_kpi_log2 kpi_type_id KPI Definition
KEY ValuationNumber valuation_id Valuation ID
KEY ProcObsvrTaskUUID start_ba_id Task Instance ID
ProcObsvrProcessDefinition poc_d_kpi_log2 process_type_id Process Def. ID
ProcObsvrProcessDefVersion poc_d_kpi_log2 process_version Process Version
StartSAPBusinessObjectType Instance SAPBusinessObjectType
StartBusinessObject Instance BusinessObject Business Object
StartBusinessObjectItem Instance BusinessObjectItem
ProcObsvrProcessStatus Instance ProcObsvrProcessStatus
ProcObsvrFreeDefinedStatus Instance ProcObsvrFreeDefinedStatus
ProcObsvrProcessVariantHash Instance ProcObsvrProcessVariantHash
ProcObsvrProcessVariantLength Instance ProcObsvrProcessVariantLength
end_ba_idthenstart_dateendasEndSystDate
end_ba_idthenstart_timeendasEndSystTime
_UnitOfMeasure _UnitOfMeasure
_ProcMonProcessDefinition _ProcMonProcessDefinition
_ProcObsvrProcessStatus _ProcObsvrProcessStatus
_ProcMonFreeDefinedStatus _ProcMonFreeDefinedStatus
_ProcMonKPIDefinition _ProcMonKPIDefinition

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 I_ProcMonKPI.
-- 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: IPOCKPIALL

CREATE VIEW I_ProcMonKPI AS
SELECT
  process_id AS ProcObsvrProcessUUID,
  KPI.kpi_type_id AS ProcObsvrKPIDefinition,
  valuation_id AS ValuationNumber,
  start_ba_id AS ProcObsvrTaskUUID,
  KPI.process_type_id AS ProcObsvrProcessDefinition,
  KPI.process_version AS ProcObsvrProcessDefVersion,
  Instance.SAPBusinessObjectType AS StartSAPBusinessObjectType,
  Instance.BusinessObject AS StartBusinessObject,
  Instance.BusinessObjectItem AS StartBusinessObjectItem,
  Instance.ProcObsvrProcessStatus AS ProcObsvrProcessStatus,
  Instance.ProcObsvrFreeDefinedStatus AS ProcObsvrFreeDefinedStatus,
  Instance.ProcObsvrProcessVariantHash AS ProcObsvrProcessVariantHash,
  Instance.ProcObsvrProcessVariantLength AS ProcObsvrProcessVariantLength,
  case when KPI.end_ba_id > ' ' then end_date when KPI.end_ba_id <= ' ' then start_date end as EndSystDate AS end_ba_idthenstart_dateendasEndSystDate,
  case when KPI.end_ba_id > ' ' then end_time when KPI.end_ba_id <= ' ' then start_time end as EndSystTime AS end_ba_idthenstart_timeendasEndSystTime
FROM poc_d_kpi_log2 AS KPI
LEFT OUTER JOIN I_ProcMonProcessDefinition AS _ProcMonProcessDefinition ON ProcObsvrKPIDefinition = _ProcMonProcessDefinition.ProcObsvrProcessDefinition  -- association [0..1]
LEFT OUTER JOIN I_ProcMonKPIDefinition AS _ProcMonKPIDefinition ON ProcObsvrProcessDefinition = _ProcMonKPIDefinition.ProcObsvrProcessDefinition AND ProcObsvrProcessDefVersion = _ProcMonKPIDefinition.ProcObsvrProcessDefVersion AND ProcObsvrKPIDefinition = _ProcMonKPIDefinition.ProcObsvrKPIDefinition  -- association [0..1]
LEFT OUTER JOIN I_ProcMonProcessStatus AS _ProcObsvrProcessStatus ON ProcObsvrProcessStatus = _ProcObsvrProcessStatus.ProcObsvrProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_ProcMonFreeDefinedStatus AS _ProcMonFreeDefinedStatus ON ProcObsvrProcessDefinition = _ProcMonFreeDefinedStatus.ProcObsvrProcessDefinition AND ProcObsvrFreeDefinedStatus = _ProcMonFreeDefinedStatus.ProcObsvrFreeDefinedStatus  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = DurationUnit  -- association [0..1]
;

Learn More