P_PPM_USER

CDS View

P_PPM_USER is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPM_User view left_outer BASIC User information in table HRP1001 
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PPPMUSER'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.representativeKey: 'UserID'

define view P_PPM_User
                
as select distinct from hrp1001 as rel_user
        inner join hrp1001 as rel_bupa 
                on rel_user.objid = rel_bupa.objid
        inner join I_BusinessPartner as bupa 
                on bupa.BusinessPartner = rel_bupa.sobid
               
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 rel_user.sobid as UserID,
    bupa.BusinessPartnerUUID,
    _BusinessPartner,
    _BusinessUser
}
 //Central Person to User Relation

where rel_user.plvar = '01' and rel_user.otype = 'CP' and rel_user.rsign = 'B' and rel_user.relat = '208' 
  and rel_user.sclas = 'US' and rel_user.endda = '99991231'
//Central Person to Business Partner Relation

and rel_bupa.plvar = '01' and rel_bupa.otype = 'CP' and rel_bupa.rsign = 'B' and rel_bupa.relat = '207'
and rel_bupa.sclas = 'BP' and rel_bupa.endda = '99991231'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"HRP1001"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_BUSINESSUSERBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More