P_PersonAddress

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 P_PersonAddress.
-- 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: PPERSONADDR

CREATE VIEW P_PersonAddress AS
SELECT
  adrp.client AS client,
  adrp.persnumber AS persnumber,
  adrp.date_from AS date_from,
  adrp.nation AS nation,
  adrp.date_to AS date_to,
  adrp.title AS title,
  adrp.name_first AS name_first,
  adrp.name_last AS name_last,
  adrp.name2 AS name2,
  adrp.namemiddle AS namemiddle,
  adrp.name_last2 AS name_last2,
  adrp.name_text AS name_text,
  adrp.converted AS converted,
  adrp.title_aca1 AS title_aca1,
  adrp.title_aca2 AS title_aca2,
  adrp.prefix1 AS prefix1,
  adrp.prefix2 AS prefix2,
  adrp.title_sppl AS title_sppl,
  adrp.nickname AS nickname,
  adrp.initials AS initials,
  adrp.nameformat AS nameformat,
  adrp.namcountry AS namcountry,
  adrp.profession AS profession,
  adrp.sex AS sex,
  adrp.langu AS langu,
  adrp.pers_group AS pers_group,
  adrp.flaggroups AS flaggroups,
  adrp.sort1 AS sort1,
  adrp.sort2 AS sort2,
  adrp.sort_phn AS sort_phn,
  adrp.addr_comp AS addr_comp,
  adrp.addr_pers AS addr_pers,
  adrp.flperstel AS flperstel,
  adrp.flperscomm AS flperscomm,
  adrp.persorigin AS persorigin,
  adrp.mc_namefir AS mc_namefir,
  adrp.mc_namelas AS mc_namelas,
  adrp.mc_name2 AS mc_name2,
  adrp.langu_crea AS langu_crea,
  adrp.adrp_uuid AS adrp_uuid,
  adrp.uuid_belated AS uuid_belated,
  adrp.id_category AS id_category,
  adrp._dataaging AS _dataaging,
  rtrim( ltrim( concat_with_space( concat_with_space(adrp.name_last, adrp.name_first, 1), adrp.namemiddle, 1), ' '), ' ') as PersonName AS namemiddle1asPersonName
FROM adrp
;