P_QltyBPWithUser

/*
 * Use the view at your own risk.
 * Built for consumption by Quality Management only.
 *
 *  Exposes all Business Partners having a user (incl. blocked & archived).
 */

@AbapCatalog.sqlViewName: 'PQLTYBPWITHUSER'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    representativeKey: 'BusinessPartner',
    usageType: {
        dataClass: #MASTER,
        sizeCategory: #XL,
        serviceQuality: #C }
}

define view P_QltyBPWithUser
  as select from P_QltyBPEmployee as Partner
    inner join   I_User           as User on User.BusinessPartnerUUID = Partner.BusinessPartnerUUID
  // Attention: Join field BusinessPartnerUUID is added via view extension X_FND_User to view I_User

  // (+ an append to the SQL view IUSER of DDL I_User), it is not part of the view definition of I_User itself!

  // This was taken over from Responsibility Managment (see P_RespyMgmtBPWithUser)

{

  key Partner.BusinessPartner            as BusinessPartner,
      User.UserID                        as UserID,
      Partner.BusinessPartnerCategory    as BusinessPartnerCategory,
      Partner.BusinessPartnerRole        as BusinessPartnerRole,
      Partner.BusinessPartnerUUID        as BusinessPartnerUUID,
      Partner.FirstName                  as FirstName,
      Partner.LastName                   as LastName,
      Partner.BusinessPartnerFullName    as FullName,

      Partner.BusinessPartnerIsBlocked   as BusinessPartnerIsBlocked,
      Partner.IsMarkedForArchiving       as IsMarkedForArchiving,

      Partner.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,
      Partner.AuthorizationGroup         as AuthorizationGroup,
      // Added 10(+1) adoption

      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      Partner.DataController10

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