I_PPM_CONTACTDATA

CDS View

Contact information for project participants

I_PPM_CONTACTDATA is a CDS View in S/4HANA. Contact information for project participants. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_EnterpriseProjectUserVH view from CONSUMPTION Enterprise Project User Value Help
C_EntProjectUserContactCard view from CONSUMPTION Contact card for UserID participating in a project
C_EntProjRankingBusinessUser view from CONSUMPTION Project Ranking Business User
C_PPM_ProjectMemberContactCard view from CONSUMPTION Contact card for a Person in a Project 
@AbapCatalog.sqlViewName: 'IPPMCONTACTDATA'

//@Search.searchable: true


@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #COMPOSITE
@ObjectModel: {
   semanticKey:       [ 'PersonFullName' ],
   representativeKey: 'BusinessPartnerUUID',
   alternativeKey: [ { id : 'UserID', element: ['UserID'], uniqueness: #UNIQUE },
                     { id : 'BusinessPartner', element: ['BusinessPartner'], uniqueness: #UNIQUE } ],  
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MASTER,
     sizeCategory:    #L
   }
}

@EndUserText.label: 'Contact information for project participants'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
define view I_PPM_ContactData as select from I_BusinessUserBasic as Person
{
        @Semantics.contact.type: #PERSON
        @ObjectModel.text.element: 'PersonFullName'
  key   Person.BusinessPartnerUUID,

        @Semantics.user.id: true
  key   Person.UserID,
        
        @UI.hidden: true        // required for authorizations only

        Person.AuthorizationGroup,      
        
        @UI.hidden: true        // required for authorizations only

        IsBusinessPurposeCompleted,     
        
        @Consumption.hidden:true
        @UI.hidden: true        // required for authorizations only

        DataControllerSet,  
        @Consumption.hidden:true
        @UI.hidden: true        // required for authorizations only

        DataController1, 
        @Consumption.hidden:true 
        @UI.hidden: true        // required for authorizations only

        DataController2, 
        @Consumption.hidden:true 
        @UI.hidden: true        // required for authorizations only

        DataController3,  
        @Consumption.hidden:true
        @UI.hidden: true        // required for authorizations only

        DataController4,  
        @Consumption.hidden:true
        @UI.hidden: true        // required for authorizations only

        DataController5, 
        @Consumption.hidden:true 
        @UI.hidden: true        // required for authorizations only

        DataController6,  
        @Consumption.hidden:true
        @UI.hidden: true        // required for authorizations only

        DataController7,  
        @Consumption.hidden:true
        @UI.hidden: true        // required for authorizations only

        DataController8, 
        @Consumption.hidden:true 
        @UI.hidden: true        // required for authorizations only

        DataController9,  
        @Consumption.hidden:true
        @UI.hidden: true        // required for authorizations only

        DataController10,                                                                                            

        @Semantics.name.fullName: true
        Person.PersonFullName,
        
        Person.FirstName,
        
        Person.LastName, 

        @Semantics:   { eMail: { address: true, type:  [ #PREF, #WORK ] } }
        _WorkplaceAddress.DefaultEmailAddress,

        @Semantics.telephone.type: #CELL
        _WorkplaceAddress.MobilePhoneNumber,    
 
        @Semantics.telephone.type: #WORK
        _WorkplaceAddress.PhoneNumber
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSERBASIC",
"I_WORKPLACEADDRESS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More