P_BPUsrRole

DDL: P_BPUSRROLE SQL: PBPUROLE Type: view BASIC

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.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
but100 but100 from
P_BPUsrRoleCustomizing P_BPUsrRoleCustomizing inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PBPUROLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Partner Role - BUM view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'PBPUROLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business Partner Role - BUM'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm : #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
define view 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 = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BPUSRROLECUSTOMIZING",
"BUT100"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More