R_BPUSRBUSROLEUNIQUE

CDS View

Business Partner Unique Role

R_BPUSRBUSROLEUNIQUE is a CDS View in S/4HANA. Business Partner Unique Role. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WorkforcePersonTP_3 view_entity inner TRANSACTIONAL Workforce Person Transactional Processing 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business Partner Unique Role'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
//@VDM.private: true

@VDM.viewType: #COMPOSITE
define view entity R_BPUsrBusRoleUnique
  //  as select distinct from but100

  as select distinct from I_BusinessPartner_to_BP_Role as BPRole
    inner join            R_BPUsrRoleCustomizing on  R_BPUsrRoleCustomizing.BusinessPartnerRole     = BPRole.BusinessPartnerRole
                                                 and R_BPUsrRoleCustomizing.BPRoleCategoryUsageCode = 'B' //Business User

{
  key BPRole.BusinessPartner
}
//where

//  but100.dfval = ''

Learn More