P_RespyMgmtBPWithUser

DDL: P_RESPYMGMTBPWITHUSER SQL: PRSMBPWITHUSR Type: view COMPOSITE

P_RespyMgmtBPWithUser is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_BPUsrRole) and exposes 10 fields with key field BusinessPartner.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_BPUsrRole BusinessUserRole inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRSMBPWITHUSR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey BusinessPartner view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner User BusinessPartner
UserID User UserID
BusinessPartnerUUID User BusinessPartnerUUID
FirstName User FirstName
LastName User LastName
FullName User PersonFullName
BusinessPartnerIsBlocked User BusinessPartnerIsBlocked
IsMarkedForArchiving User IsMarkedForArchiving
IsBusinessPurposeCompleted User IsBusinessPurposeCompleted
AuthorizationGroup User AuthorizationGroup 
@AbapCatalog.sqlViewName: 'PRSMBPWITHUSR'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #COMPOSITE
@VDM.private: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'BusinessPartner'
define view P_RespyMgmtBPWithUser
  as select distinct from I_BusinessUserBasic as User
  inner join I_BPUsrRole as BusinessUserRole on BusinessUserRole.BusinessPartner = User.BusinessPartner

{
      /*
       * Use the view at your own risk.
       * Built for consumption by Responsibility Management only.
       *
       *  Exposes all Business Partner's who have a user (Even the Blocked & Archived ones).
       */
  key User.BusinessPartner   as BusinessPartner,
      User.UserID                     as UserID,
      User.BusinessPartnerUUID        as BusinessPartnerUUID,
      User.FirstName                  as FirstName,
      User.LastName                   as LastName,
      User.PersonFullName             as FullName,

      User.BusinessPartnerIsBlocked   as BusinessPartnerIsBlocked,
      User.IsMarkedForArchiving       as IsMarkedForArchiving,

      User.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,
      User.AuthorizationGroup         as AuthorizationGroup
}
where
      BusinessUserRole.ValidTo >= tstmp_current_utctimestamp()
  and BusinessUserRole.ValidFrom <= tstmp_current_utctimestamp()

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPUSRROLE",
"I_BUSINESSUSERBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More