I_PPM_ContactData

DDL: I_PPM_CONTACTDATA SQL: IPPMCONTACTDATA Type: view COMPOSITE

Contact information for project participants

I_PPM_ContactData is a Composite CDS View that provides data about "Contact information for project participants" in SAP S/4HANA. It reads from 1 data source (I_BusinessUserBasic) and exposes 21 fields with key fields BusinessPartnerUUID, UserID.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessUserBasic Person from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPPMCONTACTDATA view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey BusinessPartnerUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Contact information for project participants view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID I_BusinessUserBasic BusinessPartnerUUID
KEY UserID I_BusinessUserBasic UserID
AuthorizationGroup I_BusinessUserBasic AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
PersonFullName I_BusinessUserBasic PersonFullName
FirstName I_BusinessUserBasic FirstName
LastName I_BusinessUserBasic LastName
DefaultEmailAddress _WorkplaceAddress DefaultEmailAddress
MobilePhoneNumber _WorkplaceAddress MobilePhoneNumber
PhoneNumber _WorkplaceAddress PhoneNumber 
@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