SEPM_I_ContactPerson

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 SEPM_I_ContactPerson.
-- 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: SEPM_ICONTACTP

CREATE VIEW SEPM_I_ContactPerson AS
SELECT
  snwd_bpa_contact.node_key AS ContactPersonUUID,
  snwd_bpa_contact.contact_id AS ContactPerson,
  cast( snwd_bpa_contact.parent_key as sepm_bp_uuid preserving type ) AS BusinessPartnerUUID,
  snwd_bpa_contact.first_name AS FirstName,
  snwd_bpa_contact.middle_name AS MiddleName,
  snwd_bpa_contact.last_name AS LastName,
  snwd_bpa_contact.login_name AS SystemUser,
  snwd_bpa_contact.initials AS Initials,
  snwd_bpa_contact.sex AS GenderCode,
  snwd_bpa_contact.address_guid AS AddressUUID,
  snwd_bpa_contact.phone_number AS PhoneNumber,
  snwd_bpa_contact.fax_number AS FaxNumber,
  snwd_bpa_contact.email_address AS EmailAddress,
  snwd_bpa_contact.language AS PreferredLanguage,
  snwd_bpa_contact.date_of_birth AS BirthDate,
  snwd_bpa_contact.mobile_number AS MobilePhoneNumber,
  cast( concat_with_space( snwd_bpa_contact.first_name , snwd_bpa_contact.last_name, 1 ) as sepm_full_name preserving type ) AS FullName
FROM snwd_bpa_contact
LEFT OUTER JOIN SEPM_I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [1..1]
LEFT OUTER JOIN SEPM_I_Language AS _PreferredLanguage ON PreferredLanguage = _PreferredLanguage.Language  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Address AS _Address ON AddressUUID = _Address.AddressUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_GenderCode AS _GenderCode ON GenderCode = _GenderCode.GenderCode  -- association [0..1]
;