R_BPUSRROLECOUNT_2

CDS View

Business User Role Count

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

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BPUsr000SDM view_entity inner COMPOSITE SDM View for BPU000
R_WorkforcePerson_2 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_2
  as select distinct from R_BPUsrRoleLite_2
{
  key BusinessPartner,
      count( * ) as TotalNumberOfBPRole
}
//where

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

group by
  BusinessPartner

Learn More