R_BPUSRROLECOUNT

CDS View

Business User Role Count

R_BPUSRROLECOUNT is a CDS View in S/4HANA. Business User Role Count. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WorkforcePerson view_entity inner COMPOSITE Workforce Person data 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business User Role Count'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
  }
define view entity R_BPUsrRoleCount
  as select distinct from R_BusinessPartnerUserRoleLite
  //R_BPUsrRole

{
  key BusinessPartnerUUID,
      count( * ) as TotalNumberOfBPRole
}
//where

//  R_BPUsrRole.BPRoleCategoryUsageCode = 'B' //Business User

group by
  BusinessPartnerUUID

Learn More