C_SDDocumentPartnerCard

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_SDDocumentPartnerCard.
-- 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.

CREATE VIEW C_SDDocumentPartnerCard AS
SELECT
  SDPartner.SDDocument AS SDDocument,
  SDPartner.SDDocumentItem AS SDDocumentItem,
  cast(SDPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  SDPartner._PartnerFunction._Text[1: Language = $session.system_language].PartnerFunctionName AS PartnerFunctionName,
  SDPartner.Customer AS Customer,
  SDPartner.Personnel AS Personnel,
  SDPartner.ContactPerson AS ContactPerson,
  SDPartner.AddressID AS AddressID,
  SDPartner.AddressPersonID AS AddressPersonID,
  SDPartner.AddressObjectType AS AddressObjectType,
  SDPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  case when SDPartner.ContactPerson != '0000000000' then coalesce(SDPartner._DfltAddrRprstn.AddresseeFullName, cast(substring(replace(concat(_ContactPerson.FirstName, concat(' &', _ContactPerson.LastName)), '&', ''),1,80) as ad_namtext ) ) when SDPartner.Personnel != '00000000' then coalesce(SDPartner._DfltAddrRprstn.AddresseeFullName, coalesce(_WorkAssignment.PersonFullName, _WorkAssignment._BusinessPartner.LastName)) else SDPartner._DfltAddrRprstn.AddresseeFullName end as FullName AS AddresseeFullNameendasFullName,
  case AddressID when '' then _WorkAssignment._WorkplaceAddress.DefaultEmailAddress else _CurrentDfltEmailAddress.EmailAddress end as EmailAddress AS EmailAddressendasEmailAddress,
  SDPartner._PartnerFunction AS _PartnerFunction,
  cast ( '' as ad_line_s ) AS FormattedPostalAddressDesc
FROM I_SDDocumentCompletePartners AS SDPartner
LEFT OUTER JOIN I_WorkAssignment AS _WorkAssignment ON Personnel = _WorkAssignment.WorkAssignment  -- association [1]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr ON AddressID = _CurrentDfltLandlinePhoneNmbr.AddressID AND AddressPersonID = _CurrentDfltLandlinePhoneNmbr.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _CurrentDfltEmailAddress ON AddressID = _CurrentDfltEmailAddress.AddressID AND AddressPersonID = _CurrentDfltEmailAddress.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber ON AddressID = _CurrentDfltMobilePhoneNumber.AddressID AND AddressPersonID = _CurrentDfltMobilePhoneNumber.AddressPersonID  -- association [0..1]
;