P_Activitylist

DDL: P_ACTIVITYLIST SQL: PACTLIST Type: view BASIC Package: VDM_CPM_WS

Activity List for master Project

P_Activitylist is a Basic CDS View that provides data about "Activity List for master Project" in SAP S/4HANA. It reads from 4 data sources (/iam/d_act_date, /iam/d_act_root, P_PICMStatus, P_RootNode) and exposes 11 fields. It has 1 association to related views. Part of development package VDM_CPM_WS.

4 data source(s) 11 fields

Data Sources (4)

SourceAliasJoin Type
/iam/d_act_date ActivityDate inner
/iam/d_act_root ActivityList inner
P_PICMStatus IssueStatuses inner
P_RootNode P_RootNode from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MasterProject _MasterProject $projection.MasterProjectUUID = _MasterProject.ProjectUUID

Annotations (6)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID P_RootNode id
MasterProject _MasterProject MasterProject
issue_id P_RootNode issue_id
application P_RootNode application
activity_id /iam/d_act_root activity_id
act_category /iam/d_act_root act_category
act_type /iam/d_act_root act_type
act_template /iam/d_act_root act_template
date_time /iam/d_act_date date_time
ActivityEndDate
_MasterProject _MasterProject 
@AbapCatalog.sqlViewName: 'PACTLIST'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC

define view P_Activitylist as select from P_RootNode
inner join   P_PICMStatus     as IssueStatuses on P_RootNode.application    = IssueStatuses.application and
                                                  P_RootNode.issue_category = IssueStatuses.category and
                                                  P_RootNode.issue_type     = IssueStatuses.type and
                                                  P_RootNode.stat_cd        = IssueStatuses.stacd
inner join /iam/d_act_root as ActivityList on P_RootNode.db_key             = ActivityList.par_issue_uuid
inner join /iam/d_act_date as ActivityDate on ActivityList.db_key           = ActivityDate.parent_key
association [0..*] to I_MasterProject as _MasterProject on $projection.MasterProjectUUID = _MasterProject.ProjectUUID
{
  P_RootNode.id as MasterProjectUUID,
  _MasterProject.MasterProject,
  P_RootNode.issue_id,
  P_RootNode.application,
  ActivityList.activity_id,
  ActivityList.act_category,
  ActivityList.act_type,
  ActivityList.act_template,
  ActivityDate.date_time,
  substring( cast( ActivityDate.date_time as abap.char(17) ), 1, 8) as ActivityEndDate,

  _MasterProject
}
where P_RootNode.application = 'ICM' and
      P_RootNode.archiving_status <> '02' and // Exclude Archived Objects

      ( IssueStatuses.iam_status = '60' or IssueStatuses.iam_status = '05' ) and // Show only New or In Process Issues/Change Requests

      IssueStatuses.exclude_in_list = '' and // Fliter issues based on exclude functionality

      ActivityDate.role_cd = 'P02' and // End date of activity

//      ActivityDate.date_time < TSTMP_CURRENT_UTCTIMESTAMP() and

      ( ActivityList.cea_status = '' or ActivityList.cea_status = '1' or ActivityList.cea_status = '2' )  // New and In Process

Learn More