I_ProcMonKPIO2CUNI

DDL: I_PROCMONKPIO2CUNI SQL: IPOCKPIO2CUNI Type: view COMPOSITE

Order-to-Cash: All KPIs

I_ProcMonKPIO2CUNI is a Composite CDS View that provides data about "Order-to-Cash: All KPIs" in SAP S/4HANA. It reads from 1 data source (I_ProcMonKPI) and exposes 25 fields with key fields ProcObsvrProcessUUID, ProcObsvrKPIDefinition, ValuationNumber, ProcObsvrTaskUUID.

Data Sources (1)

SourceAliasJoin Type
I_ProcMonKPI KPI from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPOCKPIO2CUNI view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Order-to-Cash: All KPIs view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID ProcObsvrProcessUUID Process Instance ID
KEY ProcObsvrKPIDefinition ProcObsvrKPIDefinition KPI Definition
KEY ValuationNumber ValuationNumber Valuation ID
KEY ProcObsvrTaskUUID ProcObsvrTaskUUID Task Instance ID
ProcObsvrProcessDefinition ProcObsvrProcessDefinition Process Def. ID
ProcObsvrProcessDefVersion ProcObsvrProcessDefVersion Process Version
StartSAPBusinessObjectType StartSAPBusinessObjectType
StartBusinessObject StartBusinessObject Business Object
StartBusinessObjectItem StartBusinessObjectItem
ProcObsvrProcessStatus ProcObsvrProcessStatus
ProcObsvrFreeDefinedStatus ProcObsvrFreeDefinedStatus
ProcObsvrProcessVariantHash ProcObsvrProcessVariantHash
ProcObsvrProcessVariantLength ProcObsvrProcessVariantLength
ProcObsvrKPICount ProcObsvrKPICount
ProcObsvrKPIDurationInSeconds ProcObsvrKPIDurationInSeconds
DurationUnit DurationUnit Unit
EndUTCDateTime EndUTCDateTime Time Stamp
EndUTCDate EndUTCDate
EndSystDate EndSystDate
EndSystTime EndSystTime
_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_ProcMonKPIO2CUNI.
-- 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: IPOCKPIO2CUNI

CREATE VIEW I_ProcMonKPIO2CUNI AS
SELECT
  ProcObsvrProcessUUID,
  ProcObsvrKPIDefinition,
  ValuationNumber,
  ProcObsvrTaskUUID,
  ProcObsvrProcessDefinition,
  ProcObsvrProcessDefVersion,
  StartSAPBusinessObjectType,
  StartBusinessObject,
  StartBusinessObjectItem,
  ProcObsvrProcessStatus,
  ProcObsvrFreeDefinedStatus,
  ProcObsvrProcessVariantHash,
  ProcObsvrProcessVariantLength,
  ProcObsvrKPICount,
  ProcObsvrKPIDurationInSeconds,
  DurationUnit,
  EndUTCDateTime,
  EndUTCDate,
  EndSystDate,
  EndSystTime
FROM I_ProcMonKPI AS KPI
;