P_PROCMONAGGREGATEDPRCACTIVITY

DDL: P_PROCMONAGGREGATEDPRCACTIVITY SQL: PPOCAGGRPRCACTIV Type: view CONSUMPTION Package: BS_POC_CDS
15 Fields 1 Data Sources

Process Observer: Aggregated Process with Activity

P_PROCMONAGGREGATEDPRCACTIVITY is a Consumption CDS View that provides data about "Process Observer: Aggregated Process with Activity" in SAP S/4HANA. It reads from 1 data source (I_ProcMonActivityInstance) and exposes 15 fields with key fields ProcObsvrProcessUUID, ProcObsvrActivityUUID. Part of development package BS_POC_CDS.

Data Sources (1)

SourceAliasJoin Type
I_ProcMonActivityInstance activity from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPOCAGGRPRCACTIV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID I_ProcMonActivityInstance ProcObsvrProcessUUID Process Instance ID
KEY ProcObsvrActivityUUID I_ProcMonActivityInstance ProcObsvrActivityUUID Activity ID
ProcObsvrActivityDefinition I_ProcMonActivityInstance ProcObsvrActivityDefinition Activity ID
ProcObsvrProcessDefinition I_ProcMonActivityInstance ProcObsvrProcessDefinition
ProcObsvrProcessDefVersion I_ProcMonActivityInstance ProcObsvrProcessDefVersion
StartBusinessObject _ProcMonProcess BusinessObject Business Object
StartSAPBusinessObjectType _ProcMonProcess SAPBusinessObjectType
ProcObsvrProcessVariantHash _ProcMonProcess ProcObsvrProcessVariantHash
ProcObsvrProcessVariantLength _ProcMonProcess ProcObsvrProcessVariantLength
ProcObsvrCreationUTCDateTime _ProcMonProcess ProcObsvrCreationUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ProcObsvrCreationSystDate _ProcMonProcess ProcObsvrCreationSystDate Executed Date
ProcObsvrCreationSystTime _ProcMonProcess ProcObsvrCreationSystTime Time
_ProcMonProcess _ProcMonProcess
_ProcMonProcessDefinition _ProcMonProcessDefinition
_ActivityDefinition _ActivityDefinition

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_PROCMONAGGREGATEDPRCACTIVITY.
-- 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: PPOCAGGRPRCACTIV

CREATE VIEW P_PROCMONAGGREGATEDPRCACTIVITY AS
SELECT
  activity.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  activity.ProcObsvrActivityUUID AS ProcObsvrActivityUUID,
  activity.ProcObsvrActivityDefinition AS ProcObsvrActivityDefinition,
  activity.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  activity.ProcObsvrProcessDefVersion AS ProcObsvrProcessDefVersion,
  _ProcMonProcess.BusinessObject AS StartBusinessObject,
  _ProcMonProcess.SAPBusinessObjectType AS StartSAPBusinessObjectType,
  _ProcMonProcess.ProcObsvrProcessVariantHash AS ProcObsvrProcessVariantHash,
  _ProcMonProcess.ProcObsvrProcessVariantLength AS ProcObsvrProcessVariantLength,
  _ProcMonProcess.ProcObsvrCreationUTCDateTime AS ProcObsvrCreationUTCDateTime,
  _ProcMonProcess.ProcObsvrCreationSystDate AS ProcObsvrCreationSystDate,
  _ProcMonProcess.ProcObsvrCreationSystTime AS ProcObsvrCreationSystTime
FROM I_ProcMonActivityInstance AS activity
;

Learn More