P_RespyMgmtBPWithUser

@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

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@ObjectModel.representativeKey: 'BusinessPartner'
define view P_RespyMgmtBPWithUser
  as select 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,
      @Consumption.hidden:true
      User.DataControllerSet,
      @Consumption.hidden:true
      User.DataController1,
      @Consumption.hidden:true
      User.DataController2,
      @Consumption.hidden:true
      User.DataController3,
      @Consumption.hidden:true
      User.DataController4,
      @Consumption.hidden:true
      User.DataController5,
      @Consumption.hidden:true
      User.DataController6,
      @Consumption.hidden:true
      User.DataController7,
      @Consumption.hidden:true
      User.DataController8,
      @Consumption.hidden:true
      User.DataController9,
      @Consumption.hidden:true
      User.DataController10
}
//where

//      BusinessUserRole.ValidTo   >= tstmp_current_utctimestamp()

//  and BusinessUserRole.ValidFrom <= tstmp_current_utctimestamp()