P_Customerprojectcontacts

DDL: P_CUSTOMERPROJECTCONTACTS SQL: PCUSTPRJCONTACTS Type: view CONSUMPTION

P_Customerprojectcontacts is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (C_Custprojcustomercontact, I_EngagementProjectRole) and exposes 19 fields.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
C_Custprojcustomercontact Custprojcustomercontact union
I_EngagementProjectRole EngagementProjectRole from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PCUSTPRJCONTACTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
CustomerProject I_EngagementProjectRole EngagementProject
CustomerProjectUUID I_EngagementProjectRole EngagementProjectUUID
PersonnelNumber I_EngagementProjectRole EmploymentInternalID
BusinessUser
EmployeeFullName
EngagementProjectRoleName
EmployeeImageURL
DefaultEmailAddress
NormalizedPhoneNumber
CustomerProjectasCustomerProject
CustomerProjectUUID C_Custprojcustomercontact CustomerProjectUUID
PersonnelNumber C_Custprojcustomercontact CustomerContact
BusinessUser
EmployeeFullName C_Custprojcustomercontact BusinessPartnerName
EngagementProjectRoleName
EmployeeImageURL
DefaultEmailAddress C_Custprojcustomercontact EmailAddress
NormalizedPhoneNumber C_Custprojcustomercontact PhoneNumber
MblNormalizedPhoneNumber C_Custprojcustomercontact MobilePhoneNumber 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PCUSTPRJCONTACTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_Customerprojectcontacts
  with parameters
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from I_EngagementProjectRole as EngagementProjectRole

{

  EngagementProjectRole.EngagementProject                                                                                             as CustomerProject,

  EngagementProjectRole.EngagementProjectUUID                                                                                         as CustomerProjectUUID,
  EngagementProjectRole.EmploymentInternalID                                                                                          as PersonnelNumber,
  EngagementProjectRole._PersonWorkAgreement._WorkforcePerson.UserID                                                                  as BusinessUser,
  EngagementProjectRole._PersonWorkAgreement._WorkforcePerson.PersonFullName                                                          as EmployeeFullName,
  EngagementProjectRole._Text[1:Language = $parameters.P_Language].EngagementProjectRoleName                                          as EngagementProjectRoleName,
  EngagementProjectRole._PersonWorkAgreement._WorkforcePersonImageURL.WorkforcePersonImageURL                                         as EmployeeImageURL,
  EngagementProjectRole._PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.DefaultEmailAddress                                   as DefaultEmailAddress,
  EngagementProjectRole._PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.NormalizedPhoneNumber                                 as NormalizedPhoneNumber,
  EngagementProjectRole._PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.MblNormalizedPhoneNumber                              as MblNormalizedPhoneNumber

}
union select from C_Custprojcustomercontact as Custprojcustomercontact
{

  Custprojcustomercontact.CustomerProject     as CustomerProject,
  Custprojcustomercontact.CustomerProjectUUID as CustomerProjectUUID,
  Custprojcustomercontact.CustomerContact     as PersonnelNumber,
  ''                                          as BusinessUser,
  Custprojcustomercontact.BusinessPartnerName as EmployeeFullName,
  'customer'                                  as EngagementProjectRoleName,
  ''                                          as EmployeeImageURL,
  Custprojcustomercontact.EmailAddress        as DefaultEmailAddress,
  Custprojcustomercontact.PhoneNumber         as NormalizedPhoneNumber,
  Custprojcustomercontact.MobilePhoneNumber   as MblNormalizedPhoneNumber


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CUSTPROJCUSTOMERCONTACT",
"I_ENGAGEMENTPROJECTROLE",
"I_ENGMTPROJECTROLETEXT",
"I_PERSNWRKAGREEMENTDET",
"I_WORKFORCEPERSONDET",
"I_WORKFORCEPERSONIMAGEURL",
"I_WORKPLACEADDRESS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More