I_AddressPersonName_2

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_AddressPersonName_2.
-- 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_AddressPersonName_2 AS
SELECT
  Person.persnumber AS AddressPersonID,
  Person.nation AS AddressRepresentationCode,
  PersAddress.addrnumber AS AddressID,
  Person.title AS FormOfAddress,
  Person.name_first AS GivenName,
  Person.name_last AS FamilyName,
  Person.name2 AS PersonBirthName,
  Person.namemiddle AS PersonMiddleName,
  Person.name_last2 AS SecondFamilyName,
  Person.title_aca1 AS AcademicTitle,
  Person.title_aca2 AS AcademicTitle2,
  Person.prefix1 AS FamilyNamePrefix,
  Person.prefix2 AS FamilyNameSecondPrefix,
  Person.title_sppl AS PersonNameSupplementCode,
  Person.nickname AS PersonNickname,
  Person.initials AS NameInitials,
  Person.name_text AS PersonFullName,
  Person.langu AS CorrespondenceLanguage,
  Person.sort1 AS AddressPersonSearchTerm1,
  Person.sort2 AS AddressPersonSearchTerm2,
  Person.nameformat AS PersonFullNameFormattingCode,
  Person.namcountry AS PersonFullNameFormattingCntry
RIGHT OUTER JOIN adrp AS Person ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_NameSupplement AS _NameSupplement ON PersonNameSupplementCode = _NameSupplement.PersonNameSupplementCode  -- association [0..1]
LEFT OUTER JOIN I_FamilyNamePrefix AS _FamilyNamePrefix ON FamilyNamePrefix = _FamilyNamePrefix.FamilyNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_FamilyNamePrefix AS _FamilyNameSecondPrefix ON FamilyNameSecondPrefix = _FamilyNameSecondPrefix.FamilyNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle ON AcademicTitle = _AcademicTitle.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle2 ON AcademicTitle2 = _AcademicTitle2.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_AddressRepresentation AS _AddressRepresentationCode ON AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode  -- association [0..1]
;