C_ProcMonAggPrcActivity

DDL: C_PROCMONAGGPRCACTIVITY SQL: CPOCAGGPRCSTEP Type: view CONSUMPTION
36 Fields 1 Data Sources 1 Associations

Process Observer: Activities Aggr. View

C_ProcMonAggPrcActivity is a Consumption CDS View that provides data about "Process Observer: Activities Aggr. View" in SAP S/4HANA. It reads from 1 data source (P_PROCMONAGGREGATEDPRCACTIVITY) and exposes 36 fields with key fields ProcObsvrProcessUUID, ProcObsvrActivityUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_PROCMONAGGREGATEDPRCACTIVITY activity from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Order2CashSalesOrder _SalesOrder _SalesOrder.SalesOrder = activity.StartBusinessObject

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPOCAGGPRCSTEP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
EndUserText.label Process Observer: Activities Aggr. View view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory XL view
ObjectModel.usageType.dataClass CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ProcObsvrProcessUUID P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrProcessUUID
KEY ProcObsvrActivityUUID P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrActivityUUID
ProcObsvrActivityDefinition P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrActivityDefinition
ProcObsvrIsStartActivity
ProcObsvrProcessDefinition P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrProcessDefinition
ProcObsvrActivityDefName
StartBusinessObject StartBusinessObject Business Object
StartSAPBusinessObjectType StartSAPBusinessObjectType
ProcObsvrProcessVariantHash P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrProcessVariantHash
ProcObsvrProcessVariantLength P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrProcessVariantLength
ProcObsvrCreationUTCDateTime P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrCreationUTCDateTime
ProcObsvrCreationSystDate P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrCreationSystDate
ProcObsvrCreationSystTime P_PROCMONAGGREGATEDPRCACTIVITY ProcObsvrCreationSystTime
SalesOrder _SalesOrder SalesOrder SD Document
SalesOrderType _SalesOrder SalesOrderType Sales Order Type
CreatedByUser _SalesOrder CreatedByUser User Name
CreationDate _SalesOrder CreationDate Time Stamp
CreationTime _SalesOrder CreationTime Time of Change
LastChangeDate _SalesOrder LastChangeDate Time Stamp
SalesOrganization _SalesOrder SalesOrganization Sales Organization
DistributionChannel _SalesOrder DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesOrder OrganizationDivision Org. Division
SalesGroup _SalesOrder SalesGroup Sales Group
SalesOffice _SalesOrder SalesOffice Sales Office
SoldToParty _SalesOrder SoldToParty Sold-to Party
CustomerGroup _SalesOrder CustomerGroup Customer Group
ProcObsvrNmbrOfExecutedActy
_SalesOrder _SalesOrder
_SalesOrganization _SalesOrder _SalesOrganization
_SalesOrderType _SalesOrder _SalesOrderType
_DistributionChannel _SalesOrder _DistributionChannel
_OrganizationDivision _SalesOrder _OrganizationDivision
_SalesGroup _SalesOrder _SalesGroup
_SalesOffice _SalesOrder _SalesOffice
_SoldToParty _SalesOrder _SoldToParty
_CustomerGroup _SalesOrder _CustomerGroup

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 C_ProcMonAggPrcActivity.
-- 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: CPOCAGGPRCSTEP

CREATE VIEW C_ProcMonAggPrcActivity AS
SELECT
  activity.ProcObsvrProcessUUID AS ProcObsvrProcessUUID,
  activity.ProcObsvrActivityUUID AS ProcObsvrActivityUUID,
  activity.ProcObsvrActivityDefinition AS ProcObsvrActivityDefinition,
  activity._ActivityDefinition.ProcObsvrIsStartActivity AS ProcObsvrIsStartActivity,
  activity.ProcObsvrProcessDefinition AS ProcObsvrProcessDefinition,
  activity._ActivityDefinition._Text[1:Language=$session.system_language].ProcObsvrActivityDefName AS ProcObsvrActivityDefName,
  StartBusinessObject,
  StartSAPBusinessObjectType,
  activity.ProcObsvrProcessVariantHash AS ProcObsvrProcessVariantHash,
  activity.ProcObsvrProcessVariantLength AS ProcObsvrProcessVariantLength,
  activity.ProcObsvrCreationUTCDateTime AS ProcObsvrCreationUTCDateTime,
  activity.ProcObsvrCreationSystDate AS ProcObsvrCreationSystDate,
  activity.ProcObsvrCreationSystTime AS ProcObsvrCreationSystTime,
  _SalesOrder.SalesOrder AS SalesOrder,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.CreatedByUser AS CreatedByUser,
  _SalesOrder.CreationDate AS CreationDate,
  _SalesOrder.CreationTime AS CreationTime,
  _SalesOrder.LastChangeDate AS LastChangeDate,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  _SalesOrder.SalesGroup AS SalesGroup,
  _SalesOrder.SalesOffice AS SalesOffice,
  _SalesOrder.SoldToParty AS SoldToParty,
  _SalesOrder.CustomerGroup AS CustomerGroup,
  cast( 1 as poc_number_executed_activity ) AS ProcObsvrNmbrOfExecutedActy,
  _SalesOrder._SalesOrganization AS _SalesOrganization,
  _SalesOrder._SalesOrderType AS _SalesOrderType,
  _SalesOrder._DistributionChannel AS _DistributionChannel,
  _SalesOrder._OrganizationDivision AS _OrganizationDivision,
  _SalesOrder._SalesGroup AS _SalesGroup,
  _SalesOrder._SalesOffice AS _SalesOffice,
  _SalesOrder._SoldToParty AS _SoldToParty,
  _SalesOrder._CustomerGroup AS _CustomerGroup
FROM P_PROCMONAGGREGATEDPRCACTIVITY AS activity
LEFT OUTER JOIN I_Order2CashSalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = activity.StartBusinessObject  -- association [0..1]
;

Learn More