I_BPUsrRole

DDL: I_BPUSRROLE SQL: IBPUROLE Type: view COMPOSITE

Business Partner Role (Business User Management)

I_BPUsrRole is a Composite CDS View that provides data about "Business Partner Role (Business User Management)" in SAP S/4HANA. It reads from 1 data source (P_BPUsrRole) and exposes 7 fields with key fields BusinessPartner, BusinessPartnerRole. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
P_BPUsrRole P_BPUsrRole from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessUser _BusinessUser $projection.BusinessPartner = _BusinessUser.BusinessPartner
[0..1] I_BusinessUserBasic _BusinessUserBasic $projection.BusinessPartner = _BusinessUserBasic.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPUROLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Business Partner Role (Business User Management) view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey BusinessPartnerRole view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY BusinessPartnerRole BusinessPartnerRole
BusinessPartnerRoleCategory BusinessPartnerRoleCategory
ValidFrom ValidFrom
ValidTo ValidTo
_BusinessUser _BusinessUser
_BusinessUserBasic _BusinessUserBasic 
@AbapCatalog.sqlViewName: 'IBPUROLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Business Partner Role (Business User Management)'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'BusinessPartnerRole'
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm : #SESSION_VARIABLE

define view I_BPUsrRole
  as select from P_BPUsrRole
  association [0..1] to I_BusinessUser      as _BusinessUser      on $projection.BusinessPartner = _BusinessUser.BusinessPartner
  association [0..1] to I_BusinessUserBasic as _BusinessUserBasic on $projection.BusinessPartner = _BusinessUserBasic.BusinessPartner
{
      @ObjectModel.foreignKey.association: '_BusinessUserBasic'
  key BusinessPartner,
  key BusinessPartnerRole,
      BusinessPartnerRoleCategory,
      ValidFrom,
      ValidTo,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_BusinessUserBasic'
      _BusinessUser,
      _BusinessUserBasic
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BPUSRROLE"
],
"ASSOCIATED":
[
"I_BUSINESSUSER",
"I_BUSINESSUSERBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More