C_Custprojcustomercontact

DDL: C_CUSTPROJCUSTOMERCONTACT SQL: CCUSTOMERCONTACT Type: view CONSUMPTION

Customer contact details for Customer Projects

C_Custprojcustomercontact is a Consumption CDS View that provides data about "Customer contact details for Customer Projects" in SAP S/4HANA. It reads from 3 data sources (I_CustomerContact, I_CustomerProject, I_Customer_to_BusinessPartner) and exposes 31 fields with key fields CustomerProjectUUID, CustomerProject, Customer, BusinessPartnerUUID, CustomerContact. It has 2 associations to related views.

3 data source(s) 31 fields

Data Sources (3)

SourceAliasJoin Type
I_CustomerContact Customercontact inner
I_CustomerProject CustomerProject from
I_Customer_to_BusinessPartner CustomerToBP inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EngagementProject _EngagementProject $projection.CustomerProject = _EngagementProject.EngagementProject
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCUSTOMERCONTACT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer contact details for Customer Projects view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CustomerProjectUUID I_CustomerProject CustomerProjectUUID
KEY CustomerProject I_CustomerProject CustomerProject
KEY Customer I_CustomerProject Customer
KEY BusinessPartnerUUID I_Customer_to_BusinessPartner BusinessPartnerUUID
KEY CustomerContact I_CustomerContact CustomerContact
RelationshipNumber I_CustomerContact RelationshipNumber
BusinessPartnerCompany I_CustomerContact BusinessPartnerCompany
BusinessPartnerPerson I_CustomerContact BusinessPartnerPerson
FirstName I_CustomerContact FirstName
LastName I_CustomerContact LastName
BusinessPartnerName I_CustomerContact BusinessPartnerName
ContactPersonDepartment I_CustomerContact ContactPersonDepartment
ContactPersonFunction I_CustomerContact ContactPersonFunction
InternationalPhoneNumber I_CustomerContact InternationalPhoneNumber
PhoneNumberCountry I_CustomerContact PhoneNumberCountry
PhoneNumber I_CustomerContact PhoneNumber
PhoneNumberExtension I_CustomerContact PhoneNumberExtension
InternationalMobilePhoneNumber I_CustomerContact InternationalMobilePhoneNumber
MobilePhoneCountry I_CustomerContact MobilePhoneCountry
MobilePhoneNumber I_CustomerContact MobilePhoneNumber
MobilePhoneNumberExtension I_CustomerContact MobilePhoneNumberExtension
InternationalFaxNumber I_CustomerContact InternationalFaxNumber
FaxCountry I_CustomerContact FaxCountry
FaxNumber I_CustomerContact FaxNumber
FaxNumberExtension I_CustomerContact FaxNumberExtension
EmailAddress I_CustomerContact EmailAddress
PartnerUUID I_CustomerContact PartnerUUID
PersonUUID I_CustomerContact PersonUUID
_ContactPersonDepartment I_CustomerContact _ContactPersonDepartment
_EngagementProject _EngagementProject
_Customer _Customer 
@AbapCatalog.sqlViewName: 'CCUSTOMERCONTACT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Customer contact details for Customer Projects'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED
define view C_Custprojcustomercontact
  as select from I_CustomerProject             as CustomerProject
    inner join   I_Customer_to_BusinessPartner as CustomerToBP    on CustomerProject.Customer = CustomerToBP.Customer
    inner join   I_CustomerContact             as Customercontact on CustomerToBP.BusinessPartnerUUID = Customercontact.PartnerUUID

  association [1..1] to I_EngagementProject as _EngagementProject on $projection.CustomerProject = _EngagementProject.EngagementProject
  association [0..1] to I_Customer          as _Customer          on $projection.Customer = _Customer.Customer
{

  key CustomerProject.CustomerProjectUUID,
  key CustomerProject.CustomerProject,
  key CustomerProject.Customer,
  key CustomerToBP.BusinessPartnerUUID,
  key Customercontact.CustomerContact,
      Customercontact.RelationshipNumber,
      Customercontact.BusinessPartnerCompany,
      Customercontact.BusinessPartnerPerson,
      Customercontact.FirstName,
      Customercontact.LastName,
      Customercontact.BusinessPartnerName,
      Customercontact.ContactPersonDepartment,
      Customercontact.ContactPersonFunction,
      Customercontact.InternationalPhoneNumber,
      Customercontact.PhoneNumberCountry,
      Customercontact.PhoneNumber,
      Customercontact.PhoneNumberExtension,
      Customercontact.InternationalMobilePhoneNumber,
      Customercontact.MobilePhoneCountry,
      Customercontact.MobilePhoneNumber,
      Customercontact.MobilePhoneNumberExtension,
      Customercontact.InternationalFaxNumber,
      Customercontact.FaxCountry,
      Customercontact.FaxNumber,
      Customercontact.FaxNumberExtension,
      Customercontact.EmailAddress,
      Customercontact.PartnerUUID,
      Customercontact.PersonUUID,


      Customercontact._ContactPersonDepartment,
      _EngagementProject,
      _Customer

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMERCONTACT",
"I_CUSTOMERPROJECT",
"I_CUSTOMER_TO_BUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_CONTACTPERSONDEPARTMENT",
"I_CUSTOMER",
"I_ENGAGEMENTPROJECT"
],
"BASE":
[
"I_CUSTOMERCONTACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More