P_BPUsrRole

DDL: P_BPUSRROLE Type: view_entity BASIC Package: S_BUPA_BPU

Business Partner Role - BUM

P_BPUsrRole is a Basic CDS View that provides data about "Business Partner Role - BUM" in SAP S/4HANA. It reads from 2 data sources (but100, P_BPUsrRoleCustomizing) and exposes 6 fields with key fields BusinessPartner, BusinessPartnerRole. Part of development package S_BUPA_BPU.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
but100 but100 from
P_BPUsrRoleCustomizing P_BPUsrRoleCustomizing inner

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Partner Role - BUM view
VDM.private true view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner but100 partner
KEY BusinessPartnerRole P_BPUsrRoleCustomizing BusinessPartnerRole
BusinessPartnerRoleCategory P_BPUsrRoleCustomizing BusinessPartnerRoleCategory
RoleCategoryUsageCode P_BPUsrRoleCustomizing RoleCategoryUsageCode
ValidFrom but100 valid_from
ValidTo but100 valid_to 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business Partner Role - BUM'
@VDM.private: true
@VDM.viewType: #BASIC
define view entity P_BPUsrRole
  as select from but100
    inner join   P_BPUsrRoleCustomizing on P_BPUsrRoleCustomizing.BusinessPartnerRole = but100.rltyp
{
  key but100.partner                                     as BusinessPartner,
  key P_BPUsrRoleCustomizing.BusinessPartnerRole         as BusinessPartnerRole,
      P_BPUsrRoleCustomizing.BusinessPartnerRoleCategory as BusinessPartnerRoleCategory,
      P_BPUsrRoleCustomizing.RoleCategoryUsageCode       as RoleCategoryUsageCode,
      but100.valid_from                                  as ValidFrom,
      but100.valid_to                                    as ValidTo
}
where
  but100.dfval = ''

Learn More