I_ACTIVITIESDUEINNEXTWEEK

CDS View

PICM:Issue or Change Request Activity Count Due In Next Week

I_ACTIVITIESDUEINNEXTWEEK is a CDS View in S/4HANA. PICM:Issue or Change Request Activity Count Due In Next Week. It contains 1 fields.

1 fields

Fields (1)

KeyField CDS FieldsUsed in Views
NmbrOfActiesDueInNextWeek NmbrOfActiesDueInNextWeek 1 
@AbapCatalog.sqlViewName: 'IACTDUE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'PICM:Issue or Change Request Activity Count Due In Next Week'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL 
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED 
define view I_ActivitiesDueInNextWeek
  as select from P_Activitylist
  association[1..1] to I_MasterProject as _MasterProject on $projection.MasterProjectUUID = _MasterProject.ProjectUUID
{
  P_Activitylist.MasterProjectUUID,

  count(* ) as NmbrOfActiesDueInNextWeek,
  //ActivitiesDueInNextWeek,

 _MasterProject.MasterProject,
 _MasterProject.MasterProjectIsConfidential,
 _MasterProject.MasterProjectType,
 _MasterProject.MasterProjectOrganization
  
}
where
      P_Activitylist.ActivityEndDate <  DATS_ADD_DAYS(
    cast(
      substring(
        cast(
          TSTMP_CURRENT_UTCTIMESTAMP() as abap.char(
            17
          )
        ), 1, 8
      ) as abap.dats
    ), 7, 'FAIL'
  )
  and P_Activitylist.ActivityEndDate >= substring(
    cast(
      TSTMP_CURRENT_UTCTIMESTAMP() as abap.char(
        17
      )
    ), 1, 8
  )
group by
  P_Activitylist.MasterProjectUUID,
  _MasterProject.MasterProject,
 _MasterProject.MasterProjectIsConfidential,
 _MasterProject.MasterProjectType,
 _MasterProject.MasterProjectOrganization

Learn More