C_SalesDocumentContactPerson

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_SalesDocumentContactPerson.
-- 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: CSDOCSCNTCTPERSN

CREATE VIEW C_SalesDocumentContactPerson AS
SELECT
  cast(SDDocumentContactPerson.SDDocument as vbeln_va preserving type) AS SalesDocument,
  SDDocumentContactPerson.PartnerFunction AS PartnerFunction,
  SDDocumentContactPerson.ContactPerson AS ContactPerson,
  ContactPerson.BusinessPartnerPerson AS BusinessPartnerPerson,
  ContactPerson._BusinessPartnerPerson.BusinessPartnerFullName AS BusinessPartnerFullName,
  ContactPerson._ContactPersonFunction._Text[1: Language = $session.system_language].ContactPersonFunctionName AS ContactPersonFunctionName,
  ContactPerson.EmailAddress AS EmailAddress,
  ContactPerson.MobilePhoneNumber AS MobilePhoneNumber,
  ContactPerson.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  ContactPerson.InternationalPhoneNumber AS InternationalPhoneNumber
FROM I_SDDocumentContactPerson AS SDDocumentContactPerson
INNER JOIN I_SalesDocumentBasic AS SalesDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerContact AS ContactPerson ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunction = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerPerson ON _BusinessPartnerPerson.BusinessPartner = BusinessPartnerPerson  -- association [1..1]
;