R_BPUsrRole

DDL: R_BPUSRROLE Type: view_entity COMPOSITE

Business User Role

R_BPUsrRole is a Composite CDS View that provides data about "Business User Role" in SAP S/4HANA. It reads from 4 data sources (bpu_rolecat_whl, but000, but100, tb003) and exposes 10 fields with key fields BusinessPartnerUUID, BusinessPartnerRole. It has 1 association to related views.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
bpu_rolecat_whl bpu_rolecat_whl inner
but000 but000 from
but100 but100 inner
tb003 tb003 inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerRoleText _RoleText _RoleText.BusinessPartnerRole = $projection.BusinessPartnerRole and _RoleText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business User Role view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID but000 partner_guid
KEY BusinessPartnerRole but100 rltyp
BusinessPartner but100 partner
RoleCategory tb003 rolecategory
BPRoleCategoryUsageCode bpu_rolecat_whl rolecat_usage_code
BPIdentificationCategory bpu_rolecat_whl idcategory
BasicRoleCategory bpu_rolecat_whl basic_rolecategory
datsendasBPUsrRoleValidFromDate
datsendasBPUsrRoleValidToDate
_RoleText _RoleText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED /*#CHECK*/
@EndUserText.label: 'Business User Role'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
define view entity R_BPUsrRole
  as select from but000
    inner join   but100          on but100.partner = but000.partner
    inner join   tb003           on tb003.role = but100.rltyp
    inner join   bpu_rolecat_whl on  bpu_rolecat_whl.rolecategory                 = tb003.rolecategory
                                 and bpu_rolecat_whl.hcm_integration_code         = '1' //Dependent from HCM Integration Switch

                                 and bpu_rolecat_whl.solution_characteristic_code = '2' //Cloud & OnPremise

  association [0..1] to I_BusinessPartnerRoleText as _RoleText on  _RoleText.BusinessPartnerRole = $projection.BusinessPartnerRole
                                                               and _RoleText.Language            = $session.system_language
{
  key     but000.partner_guid                as BusinessPartnerUUID,
  key     but100.rltyp                       as BusinessPartnerRole,
          but100.partner                     as BusinessPartner,
          tb003.rolecategory                 as RoleCategory,
          bpu_rolecat_whl.rolecat_usage_code as BPRoleCategoryUsageCode,
          bpu_rolecat_whl.idcategory         as BPIdentificationCategory,
          bpu_rolecat_whl.basic_rolecategory as BasicRoleCategory,
          case
          when but100.valid_from < 19010101000000
          then  '19010101'
          else  cast( left( cast( but100.valid_from as abap.char( 17 ) ), 8 ) as abap.dats )
          end                                as BPUsrRoleValidFromDate,

          case
          when but100.valid_to  < 19010101235959
          then  '19010101'
          else  cast( left( cast( but100.valid_to as abap.char( 17 ) ), 8 ) as abap.dats )
          end                                as BPUsrRoleValidToDate,
          _RoleText
}
where
  but100.dfval = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BPU_ROLECAT_WHL",
"BUT000",
"BUT100",
"TB003"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERROLETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More