I_PPM_User

@EndUserText.label: 'User information in table HRP1001'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPPMUSER'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED

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

@ObjectModel.representativeKey: 'UserID'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_PPM_User
                
as select from I_User as user_general
        left outer join P_PPM_User as user_ppm 
                on user_ppm.UserID = user_general.UserID
               
association [0..1]  to I_BusinessPartner                as _BusinessPartner
                    on $projection.BusinessPartnerUUID  =  _BusinessPartner.BusinessPartnerUUID
association [0..1]  to I_BusinessUserBasic              as _BusinessUser
                    on $projection.BusinessPartnerUUID  =  _BusinessUser.BusinessPartnerUUID                    
{
    key user_general.UserID,
    case bintohex(user_general.BusinessPartnerUUID)
        when '00000000000000000000000000000000'
        then user_ppm.BusinessPartnerUUID 
        else user_general.BusinessPartnerUUID
    end as BusinessPartnerUUID,
    _BusinessPartner,
    _BusinessUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USER",
"P_PPM_USER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_BUSINESSUSERBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/