I_CustomerContactOP

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 I_CustomerContactOP.
-- 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: ICUSTCNTCTOP

CREATE VIEW I_CustomerContactOP AS
SELECT
  _CustomerToBusinessPartner.Customer AS Customer,
  Contact.RelationshipNumber AS RelationshipNumber,
  Contact.BusinessPartnerCompany AS BusinessPartnerCompany,
  Contact.BusinessPartnerPerson AS BusinessPartnerPerson,
  Contact.PartnerUUID AS PartnerUUID,
  Contact.ContactPersonFunction AS ContactPersonFunction,
  Contact.ContactPersonDepartment AS ContactPersonDepartment,
  Contact.FirstName AS FirstName,
  Contact.LastName AS LastName,
  concat_with_space(Contact.FirstName, Contact.LastName, 1) AS FullName,
  _CntctPersnFuncValueHelp.ContactPersonFunctionName AS ContactPersonFunctionName,
  _CntctPersnDeptValueHelp.ContactPersonDepartmentName AS ContactPersonDepartmentName,
  Contact.PhoneNumber AS PhoneNumber,
  Contact.EmailAddress AS EmailAddress,
  Contact.MobilePhoneNumber AS MobilePhoneNumber
FROM I_CustomerContact AS Contact
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON PartnerUUID = _CustomerToBusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_ContactPersonFunctionT AS _CntctPersnFuncValueHelp ON ContactPersonFunction = _CntctPersnFuncValueHelp.ContactPersonFunction AND _CntctPersnFuncValueHelp.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ContactPersonDepartmentT AS _CntctPersnDeptValueHelp ON ContactPersonDepartment = _CntctPersnDeptValueHelp.ContactPersonDepartment AND _CntctPersnDeptValueHelp.Language = $session.system_language  -- association [0..1]
;