I_AddrPersnNameDfltRprstn

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_AddrPersnNameDfltRprstn.
-- 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 I_AddrPersnNameDfltRprstn AS
SELECT
  Person.AddressPersonID AS AddressPersonID,
  Person.AddressRepresentationCode AS AddressRepresentationCode,
  Person.FormOfAddress AS FormOfAddress,
  Person.GivenName AS GivenName,
  Person.FamilyName AS FamilyName,
  Person.PersonBirthName AS PersonBirthName,
  Person.PersonMiddleName AS PersonMiddleName,
  Person.SecondFamilyName AS SecondFamilyName,
  Person.AcademicTitle AS AcademicTitle,
  Person.AcademicTitle2 AS AcademicTitle2,
  Person.FamilyNamePrefix AS FamilyNamePrefix,
  Person.FamilyNameSecondPrefix AS FamilyNameSecondPrefix,
  Person.PersonNameSupplementCode AS PersonNameSupplementCode,
  Person.PersonNickname AS PersonNickname,
  Person.NameInitials AS NameInitials,
  Person.PersonFullName AS PersonFullName,
  Person.CorrespondenceLanguage AS CorrespondenceLanguage,
  Person.AddressPersonSearchTerm1 AS AddressPersonSearchTerm1,
  Person.AddressPersonSearchTerm2 AS AddressPersonSearchTerm2,
  Person._AcademicTitle AS _AcademicTitle,
  Person._AcademicTitle2 AS _AcademicTitle2,
  Person._AddressRepresentationCode AS _AddressRepresentationCode,
  Person._FamilyNamePrefix AS _FamilyNamePrefix,
  Person._FamilyNameSecondPrefix AS _FamilyNameSecondPrefix,
  Person._FormOfAddress AS _FormOfAddress,
  Person._NameSupplement AS _NameSupplement
FROM I_AddressPersonName AS Person
LEFT OUTER JOIN I_AddressPersonName AS _DfltRprstnPerson ON AddressPersonID = _DfltRprstnPerson.AddressPersonID AND _DfltRprstnPerson.AddressRepresentationCode is not initial  -- association [0..*]
;