SEPM_I_PartyAddress

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_PartyAddress.
-- 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_IPARTYADDR

CREATE VIEW SEPM_I_PartyAddress AS
SELECT
  SEPM_I_BusinessPartner.AddressUUID AS PartyAddressUUID,
  cast ( SEPM_I_BusinessPartner.BusinessPartnerRole as sepm_party_role preserving type ) AS PartyRole,
  cast ( SEPM_I_BusinessPartner.CompanyName as snwd_party_name ) AS PartyName,
  cast( SEPM_I_BusinessPartner.BusinessPartner as snwd_party_id preserving type ) AS Party,
  SEPM_I_BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  cast ( hextobin('00000000000000000000000000000000') as snwd_node_key preserving type ) AS ContactPersonUUID,
  SEPM_I_BusinessPartner.BusinessPartner AS BusinessPartner
FROM SEPM_I_BusinessPartner
LEFT OUTER JOIN SEPM_I_Address AS _Address ON PartyAddressUUID = _Address.AddressUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ContactPerson AS _ContactPerson ON ContactPersonUUID = _ContactPerson.ContactPersonUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PartyRole AS _PartyRole ON PartyRole = _PartyRole.PartyRole  -- association [0..1]
-- UNION ALL with additional select branch(es): SEPM_I_ContactPerson
;