P_ProcMonActivityBind

DDL: P_PROCMONACTIVITYBIND SQL: PPOCACTYBIND Type: view COMPOSITE
27 Fields 2 Data Sources 3 Associations

P_ProcMonActivityBind is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ProcMonActivityInstance, I_ProcMonTaskToActivity) and exposes 27 fields with key fields ProcObsvrProcessUUID, ProcObsvrActivityUUID, ProcObsvrTaskUUID. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ProcMonActivityInstance Activity from
I_ProcMonTaskToActivity bind left_outer

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProcMonActivityInstance _ProcMonActivity Activity.ProcObsvrProcessUUID = _ProcMonActivity.ProcObsvrProcessUUID and Activity.ProcObsvrActivityUUID = _ProcMonActivity.ProcObsvrActivityUUID
[0..1] I_ProcMonTaskToActivityDef _ActivityTaskAssignment $projection.ProcObsvrProcessDefinition = _ActivityTaskAssignment.ProcObsvrProcessDefinition and $projection.ProcObsvrProcessDefVersion = _ActivityTaskAssignment.ProcObsvrProcessDefVersion and $projection.ProcObsvrActivityDefinition = _ActivityTaskAssignment.ProcObsvrActivityDefinition and $projection.sapbusinessobjecttype = _ActivityTaskAssignment.SAPBusinessObjectType and $projection.procobsvrtasktype = _ActivityTaskAssignment.ProcObsvrTaskType
[0..1] I_ProcMonActivity _ActivityDefinition $projection.ProcObsvrProcessDefinition = _ActivityDefinition.ProcObsvrProcessDefinition and $projection.ProcObsvrProcessDefVersion = _ActivityDefinition.ProcObsvrProcessDefVersion and $projection.ProcObsvrActivityDefinition = _ActivityDefinition.ProcObsvrActivityDefinition

Annotations (6)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID I_ProcMonActivityInstance ProcObsvrProcessUUID Process Instance ID
KEY ProcObsvrActivityUUID I_ProcMonActivityInstance ProcObsvrActivityUUID Activity ID
KEY ProcObsvrTaskUUID I_ProcMonTaskToActivity ProcObsvrTaskUUID Task Instance ID
ProcObsvrProcessDefinition I_ProcMonActivityInstance ProcObsvrProcessDefinition
ProcObsvrProcessDefVersion I_ProcMonActivityInstance ProcObsvrProcessDefVersion
StartSAPBusinessObjectType
StartBusinessObject
StartBusinessObjectItem
ProcObsvrCreationUTCDateTime
ProcObsvrCreationSystDate
ProcObsvrCreationSystTime
ProcObsvrActivityDefinition I_ProcMonActivityInstance ProcObsvrActivityDefinition Activity ID
ProcObsvrTaskType _ProcMonTaskLog ProcObsvrTaskType
SAPBusinessObjectType _ProcMonTaskLog SAPBusinessObjectType
BusinessObject _ProcMonTaskLog BusinessObject Business Object
BusinessObjectItem _ProcMonTaskLog BusinessObjectItem
CreatedByUser _ProcMonTaskLog CreatedByUser User Name
TaskExecutedUTCDateTime _ProcMonTaskLog ProcObsvrCreationUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_ProcMonProcess I_ProcMonActivityInstance _ProcMonProcess
_ProcMonProcessDefinition I_ProcMonActivityInstance _ProcMonProcessDefinition
_ProcMonActivity _ProcMonActivity
_ActivityDefinition _ActivityDefinition
_ProcMonTaskLog _ProcMonTaskLog
_ActivityTaskAssignment _ActivityTaskAssignment
_User _ProcMonTaskLog _User
_ProcMonBusObjType _ProcMonTaskLog _ProcMonBusObjType
_ProcMonTaskType _ProcMonTaskLog _ProcMonTaskType

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_ProcMonActivityBind.
-- 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: PPOCACTYBIND

CREATE VIEW P_ProcMonActivityBind AS
SELECT
  Activity.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  Activity.ProcObsvrActivityUUID AS ProcObsvrActivityUUID,
  bind.ProcObsvrTaskUUID AS ProcObsvrTaskUUID,
  Activity.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  Activity.ProcObsvrProcessDefVersion AS ProcObsvrProcessDefVersion,
  Activity._ProcMonProcess.SAPBusinessObjectType AS StartSAPBusinessObjectType,
  Activity._ProcMonProcess.BusinessObject AS StartBusinessObject,
  Activity._ProcMonProcess.BusinessObjectItem AS StartBusinessObjectItem,
  Activity._ProcMonProcess.ProcObsvrCreationUTCDateTime AS ProcObsvrCreationUTCDateTime,
  Activity._ProcMonProcess.ProcObsvrCreationSystDate AS ProcObsvrCreationSystDate,
  Activity._ProcMonProcess.ProcObsvrCreationSystTime AS ProcObsvrCreationSystTime,
  Activity.ProcObsvrActivityDefinition AS ProcObsvrActivityDefinition,
  _ProcMonTaskLog.ProcObsvrTaskType AS ProcObsvrTaskType,
  _ProcMonTaskLog.SAPBusinessObjectType AS SAPBusinessObjectType,
  _ProcMonTaskLog.BusinessObject AS BusinessObject,
  _ProcMonTaskLog.BusinessObjectItem AS BusinessObjectItem,
  _ProcMonTaskLog.CreatedByUser AS CreatedByUser,
  _ProcMonTaskLog.ProcObsvrCreationUTCDateTime AS TaskExecutedUTCDateTime,
  Activity._ProcMonProcess AS _ProcMonProcess,
  Activity._ProcMonProcessDefinition AS _ProcMonProcessDefinition,
  _ProcMonTaskLog._User AS _User,
  _ProcMonTaskLog._ProcMonBusObjType AS _ProcMonBusObjType,
  _ProcMonTaskLog._ProcMonTaskType AS _ProcMonTaskType
FROM I_ProcMonActivityInstance AS Activity
LEFT OUTER JOIN I_ProcMonTaskToActivity AS bind ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProcMonActivityInstance AS _ProcMonActivity ON Activity.ProcObsvrProcessUUID = _ProcMonActivity.ProcObsvrProcessUUID AND Activity.ProcObsvrActivityUUID = _ProcMonActivity.ProcObsvrActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_ProcMonTaskToActivityDef AS _ActivityTaskAssignment ON ProcObsvrProcessDefinition = _ActivityTaskAssignment.ProcObsvrProcessDefinition AND ProcObsvrProcessDefVersion = _ActivityTaskAssignment.ProcObsvrProcessDefVersion AND ProcObsvrActivityDefinition = _ActivityTaskAssignment.ProcObsvrActivityDefinition AND sapbusinessobjecttype = _ActivityTaskAssignment.SAPBusinessObjectType AND procobsvrtasktype = _ActivityTaskAssignment.ProcObsvrTaskType  -- association [0..1]
LEFT OUTER JOIN I_ProcMonActivity AS _ActivityDefinition ON ProcObsvrProcessDefinition = _ActivityDefinition.ProcObsvrProcessDefinition AND ProcObsvrProcessDefVersion = _ActivityDefinition.ProcObsvrProcessDefVersion AND ProcObsvrActivityDefinition = _ActivityDefinition.ProcObsvrActivityDefinition  -- association [0..1]
;

Learn More