P_PPM_User

DDL: P_PPM_USER SQL: PPPMUSER Type: view BASIC Package: VDM_PPM_OBJECTS_COMMON

User Business Partner connection PPM 6.1 logic

P_PPM_User is a Basic CDS View that provides data about "User Business Partner connection PPM 6.1 logic" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, hrp1001) and exposes 4 fields with key field UserID. It has 2 associations to related views. Part of development package VDM_PPM_OBJECTS_COMMON.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner bupa inner
hrp1001 rel_bupa inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID
[0..1] I_BusinessUserBasic _BusinessUser $projection.BusinessPartnerUUID = _BusinessUser.BusinessPartnerUUID

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PPPMUSER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey UserID view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY UserID rel_user sobid
BusinessPartnerUUID I_BusinessPartner BusinessPartnerUUID
_BusinessPartner _BusinessPartner
_BusinessUser _BusinessUser 
@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'

Learn More