R_BPUsrRoleNext

DDL: R_BPUSRROLENEXT Type: view_entity COMPOSITE

Business User Role Next (valid in future)

R_BPUsrRoleNext is a Composite CDS View that provides data about "Business User Role Next (valid in future)" in SAP S/4HANA. It reads from 2 data sources (R_BPUsrRole, R_BPUsrRoleNextBase) and exposes 8 fields with key field BusinessPartnerUUID. It has 1 association to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
R_BPUsrRole R_BPUsrRole from
R_BPUsrRoleNextBase R_BPUsrRoleNextBase inner

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 Next (valid in future) 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
RoleCategory R_BPUsrRole RoleCategory
BPRoleCategoryUsageCode R_BPUsrRole BPRoleCategoryUsageCode
BPIdentificationCategory R_BPUsrRole BPIdentificationCategory
BPUsrRoleValidFromDate R_BPUsrRole BPUsrRoleValidFromDate
BPUsrRoleValidToDate R_BPUsrRole BPUsrRoleValidToDate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED /*#CHECK*/
@EndUserText.label: 'Business User Role Next (valid in future)'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
define view entity R_BPUsrRoleNext
  as select from           R_BPUsrRole
    inner join             R_BPUsrRoleNextBase on  R_BPUsrRoleNextBase.BusinessPartnerUUID        = R_BPUsrRole.BusinessPartnerUUID
                                               and R_BPUsrRoleNextBase.BPUsrRoleValidFromDate = R_BPUsrRole.BPUsrRoleValidFromDate
    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,
      R_BPUsrRole.BusinessPartner,
      R_BPUsrRole.BusinessPartnerRole,
      R_BPUsrRole.RoleCategory,
      R_BPUsrRole.BPRoleCategoryUsageCode,
      R_BPUsrRole.BPIdentificationCategory,
      R_BPUsrRole.BPUsrRoleValidFromDate,
      R_BPUsrRole.BPUsrRoleValidToDate,
      case
      when R_BPUsrRoleText.BusinessPartnerRoleShortName is not initial
      then R_BPUsrRoleText.BusinessPartnerRoleShortName
      else _RoleText.BusinessPartnerRoleShortName
      end as BusinessPartnerRoleShortName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERROLETEXT",
"R_BPUSRROLE",
"R_BPUSRROLENEXTBASE",
"R_BPUSRROLETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More