R_BusinessPartnerUserRoleLite

DDL: R_BUSINESSPARTNERUSERROLELITE Type: view_entity BASIC Package: ODATA_CA_BUM_WF

Business User Role

R_BusinessPartnerUserRoleLite is a Basic 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 2 fields with key fields BusinessPartnerUUID, BusinessPartnerRole. Part of development package ODATA_CA_BUM_WF.

4 data source(s) 2 fields

Data Sources (4)

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

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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 #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID but000 partner_guid
KEY BusinessPartnerRole but100 rltyp 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Business User Role'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]
define view entity R_BusinessPartnerUserRoleLite
  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

{
  key     but000.partner_guid                as BusinessPartnerUUID,
  key     but100.rltyp                       as BusinessPartnerRole
}
where
  but100.dfval = ''
  and bpu_rolecat_whl.rolecat_usage_code = 'B' //Business User

Learn More