C_Custprojcustomercontact

DDL: C_CUSTPROJCUSTOMERCONTACT SQL: CCUSTOMERCONTACT Type: view CONSUMPTION
31 Fields 3 Data Sources 2 Associations

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.

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 Engmnt Project ID
KEY Customer I_CustomerProject Customer Sold-to Party
KEY BusinessPartnerUUID I_Customer_to_BusinessPartner BusinessPartnerUUID UUID
KEY CustomerContact I_CustomerContact CustomerContact
RelationshipNumber I_CustomerContact RelationshipNumber BP Rel. Number
BusinessPartnerCompany I_CustomerContact BusinessPartnerCompany Busn. Partner
BusinessPartnerPerson I_CustomerContact BusinessPartnerPerson Busn. Partner
FirstName I_CustomerContact FirstName First Name
LastName I_CustomerContact LastName Last Name
BusinessPartnerName I_CustomerContact BusinessPartnerName Extracted Customer Name
ContactPersonDepartment I_CustomerContact ContactPersonDepartment Department
ContactPersonFunction I_CustomerContact ContactPersonFunction Function
InternationalPhoneNumber I_CustomerContact InternationalPhoneNumber Telephone no.
PhoneNumberCountry I_CustomerContact PhoneNumberCountry
PhoneNumber I_CustomerContact PhoneNumber Telephone no.
PhoneNumberExtension I_CustomerContact PhoneNumberExtension Extension
InternationalMobilePhoneNumber I_CustomerContact InternationalMobilePhoneNumber
MobilePhoneCountry I_CustomerContact MobilePhoneCountry Country/Region
MobilePhoneNumber I_CustomerContact MobilePhoneNumber Telephone
MobilePhoneNumberExtension I_CustomerContact MobilePhoneNumberExtension
InternationalFaxNumber I_CustomerContact InternationalFaxNumber Fax Number
FaxCountry I_CustomerContact FaxCountry Country/Region
FaxNumber I_CustomerContact FaxNumber Fax Number
FaxNumberExtension I_CustomerContact FaxNumberExtension Extension
EmailAddress I_CustomerContact EmailAddress E-Mail Address
PartnerUUID I_CustomerContact PartnerUUID
PersonUUID I_CustomerContact PersonUUID BP GUID
_ContactPersonDepartment I_CustomerContact _ContactPersonDepartment
_EngagementProject _EngagementProject
_Customer _Customer

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_Custprojcustomercontact.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCUSTOMERCONTACT

CREATE VIEW C_Custprojcustomercontact AS
SELECT
  CustomerProject.CustomerProjectUUID AS CustomerProjectUUID,
  CustomerProject.CustomerProject AS CustomerProject,
  CustomerProject.Customer AS Customer,
  CustomerToBP.BusinessPartnerUUID AS BusinessPartnerUUID,
  Customercontact.CustomerContact AS CustomerContact,
  Customercontact.RelationshipNumber AS RelationshipNumber,
  Customercontact.BusinessPartnerCompany AS BusinessPartnerCompany,
  Customercontact.BusinessPartnerPerson AS BusinessPartnerPerson,
  Customercontact.FirstName AS FirstName,
  Customercontact.LastName AS LastName,
  Customercontact.BusinessPartnerName AS BusinessPartnerName,
  Customercontact.ContactPersonDepartment AS ContactPersonDepartment,
  Customercontact.ContactPersonFunction AS ContactPersonFunction,
  Customercontact.InternationalPhoneNumber AS InternationalPhoneNumber,
  Customercontact.PhoneNumberCountry AS PhoneNumberCountry,
  Customercontact.PhoneNumber AS PhoneNumber,
  Customercontact.PhoneNumberExtension AS PhoneNumberExtension,
  Customercontact.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  Customercontact.MobilePhoneCountry AS MobilePhoneCountry,
  Customercontact.MobilePhoneNumber AS MobilePhoneNumber,
  Customercontact.MobilePhoneNumberExtension AS MobilePhoneNumberExtension,
  Customercontact.InternationalFaxNumber AS InternationalFaxNumber,
  Customercontact.FaxCountry AS FaxCountry,
  Customercontact.FaxNumber AS FaxNumber,
  Customercontact.FaxNumberExtension AS FaxNumberExtension,
  Customercontact.EmailAddress AS EmailAddress,
  Customercontact.PartnerUUID AS PartnerUUID,
  Customercontact.PersonUUID AS PersonUUID,
  Customercontact._ContactPersonDepartment AS _ContactPersonDepartment
FROM I_CustomerProject AS CustomerProject
INNER JOIN I_Customer_to_BusinessPartner AS CustomerToBP ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerContact AS Customercontact ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON CustomerProject = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;

Learn More