R_BPUsrRoleCurrent

DDL: R_BPUSRROLECURRENT Type: view_entity COMPOSITE

Business User Role Current (valid today)

R_BPUsrRoleCurrent is a Composite CDS View that provides data about "Business User Role Current (valid today)" in SAP S/4HANA. It reads from 1 data source (R_BPUsrRole) and exposes 8 fields with key field BusinessPartnerUUID. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
R_BPUsrRole R_BPUsrRole from

Associations (1)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business User Role Current (valid today) 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 (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID R_BPUsrRole BusinessPartnerUUID
BusinessPartner R_BPUsrRole BusinessPartner
BusinessPartnerRole R_BPUsrRole BusinessPartnerRole
BPUsrRoleValidFromDate R_BPUsrRole BPUsrRoleValidFromDate
BPUsrRoleValidToDate R_BPUsrRole BPUsrRoleValidToDate
RoleCategory R_BPUsrRole RoleCategory
BPIdentificationCategory R_BPUsrRole BPIdentificationCategory
BPRoleCategoryUsageCode R_BPUsrRole BPRoleCategoryUsageCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED /*#CHECK*/
@EndUserText.label: 'Business User Role Current (valid today)'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
define view entity R_BPUsrRoleCurrent
  as select from           R_BPUsrRole
    left outer to one join R_BPUsrRoleText on  R_BPUsrRoleText.RoleCategory = R_BPUsrRole.RoleCategory
                                           and R_BPUsrRoleText.Language     = $session.system_language
  association [0..1] to I_BusinessPartnerRoleText as _RoleText on  $projection.BusinessPartnerRole = _RoleText.BusinessPartnerRole
                                                               and _RoleText.Language              = $session.system_language

{
  key R_BPUsrRole.BusinessPartnerUUID      as BusinessPartnerUUID,
      R_BPUsrRole.BusinessPartner          as BusinessPartner,
      R_BPUsrRole.BusinessPartnerRole      as BusinessPartnerRole,
      R_BPUsrRole.BPUsrRoleValidFromDate   as BPUsrRoleValidFromDate,
      R_BPUsrRole.BPUsrRoleValidToDate     as BPUsrRoleValidToDate,

      R_BPUsrRole.RoleCategory             as RoleCategory,
      R_BPUsrRole.BPIdentificationCategory as BPIdentificationCategory,
      R_BPUsrRole.BPRoleCategoryUsageCode  as BPRoleCategoryUsageCode,
      case
        when R_BPUsrRoleText.BusinessPartnerRoleShortName is not initial
        then R_BPUsrRoleText.BusinessPartnerRoleShortName
        else _RoleText.BusinessPartnerRoleShortName
        end                                as BusinessPartnerRoleShortName
}
where
      R_BPUsrRole.BPUsrRoleValidFromDate <= $session.system_date
  and R_BPUsrRole.BPUsrRoleValidToDate   >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERROLETEXT",
"R_BPUSRROLE",
"R_BPUSRROLETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More