I_ProcMonTaskToActivity

DDL: I_PROCMONTASKTOACTIVITY SQL: IPOCTSK2ACTY Type: view BASIC
11 Fields 1 Data Sources 3 Associations

Process Observer: Task to Activity

I_ProcMonTaskToActivity is a Basic CDS View that provides data about "Process Observer: Task to Activity" in SAP S/4HANA. It reads from 1 data source (poc_d_prc_bind) and exposes 11 fields with key fields ProcObsvrTaskUUID, ProcObsvrProcessUUID, ProcObsvrActivityUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
poc_d_prc_bind bind from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProcMonProcess _ProcMonProcess bind.process_id = _ProcMonProcess.ProcObsvrProcessUUID
[0..1] I_ProcMonActivityInstance _ProcMonActivity bind.process_id = _ProcMonActivity.ProcObsvrProcessUUID and bind.process_step_id = _ProcMonActivity.ProcObsvrActivityUUID
[0..1] I_ProcMonTaskLog _ProcMonTaskLog bind.ba_id = _ProcMonTaskLog.ProcObsvrTaskUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPOCTSK2ACTY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Observer: Task to Activity view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrTaskUUID ba_id Task Instance ID
KEY ProcObsvrProcessUUID process_id Process Instance ID
KEY ProcObsvrActivityUUID process_step_id Activity ID
ProcObsvrIsStartActivity process_start Process Start
SAPBusinessObjectType _ProcMonTaskLog SAPBusinessObjectType
ProcObsvrTaskType _ProcMonTaskLog ProcObsvrTaskType
ProcObsvrProcessDefinition _ProcMonProcess ProcObsvrProcessDefinition
ProcObsvrProcessDefVersion _ProcMonProcess ProcObsvrProcessDefVersion
_ProcMonProcess _ProcMonProcess
_ProcMonActivity _ProcMonActivity
_ProcMonTaskLog _ProcMonTaskLog

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_ProcMonTaskToActivity.
-- 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: IPOCTSK2ACTY

CREATE VIEW I_ProcMonTaskToActivity AS
SELECT
  ba_id AS ProcObsvrTaskUUID,
  process_id AS ProcObsvrProcessUUID,
  process_step_id AS ProcObsvrActivityUUID,
  process_start AS ProcObsvrIsStartActivity,
  _ProcMonTaskLog.SAPBusinessObjectType AS SAPBusinessObjectType,
  _ProcMonTaskLog.ProcObsvrTaskType AS ProcObsvrTaskType,
  _ProcMonProcess.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  _ProcMonProcess.ProcObsvrProcessDefVersion AS ProcObsvrProcessDefVersion
FROM poc_d_prc_bind AS bind
LEFT OUTER JOIN I_ProcMonProcess AS _ProcMonProcess ON bind.process_id = _ProcMonProcess.ProcObsvrProcessUUID  -- association [0..1]
LEFT OUTER JOIN I_ProcMonActivityInstance AS _ProcMonActivity ON bind.process_id = _ProcMonActivity.ProcObsvrProcessUUID AND bind.process_step_id = _ProcMonActivity.ProcObsvrActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_ProcMonTaskLog AS _ProcMonTaskLog ON bind.ba_id = _ProcMonTaskLog.ProcObsvrTaskUUID  -- association [0..1]
;

Learn More