I_MSTRPROJISSUECHANGREQ

CDS View

Master Project KPI for Issue and Change Request

I_MSTRPROJISSUECHANGREQ is a CDS View in S/4HANA. Master Project KPI for Issue and Change Request. It contains 2 fields.

Fields (2)

KeyField CDS FieldsUsed in Views
ChangeRequest ChangeRequest 1
Issue Issue 1
@AbapCatalog.sqlViewName: 'IMSTRPROJISSCREQ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Master Project KPI for Issue and Change Request'

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_Mstrprojissuechangreq
  as select from I_IssueChangeReq as IssueChangeReq
{
  key IssueChangeReq.MasterProject,
      IssueChangeReq.MasterProjectUUID,
      IssueChangeReq.MasterProjectType,
      IssueChangeReq.MasterProjectOrganization,
      IssueChangeReq.MasterProjectIsConfidential,
      sum(IssueChangeReq.Issue)         as Issue,
      sum(IssueChangeReq.ChangeRequest) as ChangeRequest
}
group by
  IssueChangeReq.MasterProject,
  IssueChangeReq.MasterProjectUUID,
  IssueChangeReq.MasterProjectType,
  IssueChangeReq.MasterProjectOrganization,
  IssueChangeReq.MasterProjectIsConfidential