R_BPUSRROLE

CDS View

Business User Role

R_BPUSRROLE is a CDS View in S/4HANA. Business User Role. It contains 9 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 9 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_BPUsrRoleCurrent view_entity from COMPOSITE Business User Role Current (valid today)
R_BPUsrRoleNext view_entity from COMPOSITE Business User Role Next (valid in future)
R_BPUsrRoleNextBase view_entity from COMPOSITE Business User Role Next Base
R_BPUsrRolePrevious view_entity from COMPOSITE Business User Role Previous (valid in past)
R_BPUsrRolePreviousBase view_entity from COMPOSITE Business User Role Previous Base
R_WorkAssignmentTP view_entity inner TRANSACTIONAL Work assignment TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerRole BPUsrRoleForEdit,BusinessPartnerRole 5
KEY BusinessPartnerUUID BusinessPartnerUUID 4
BasicRoleCategory BasicRoleCategory 1
BPIdentificationCategory BPIdentificationCategory 4
BPRoleCategoryUsageCode BPRoleCategoryUsageCode 4
BPUsrRoleValidFromDate BPUsrRoleValidFromDate,StartDate 5
BPUsrRoleValidToDate BPUsrRoleValidToDate,EndDate 5
BusinessPartner BusinessPartner 4
RoleCategory RoleCategory 5 
@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