P_UserAddress

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_UserAddress.
-- 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 P_UserAddress AS
SELECT
  usr21.mandt AS mandt,
  usr21.bname AS bname,
  usr21.kostl AS kostl,
  usr21.idadtype AS idadtype,
  usr21.persnumber AS persnumber,
  usr21.addrnumber AS addrnumber,
  usr21.bpperson AS bpperson,
  usr21.techdesc AS techdesc,
  usr21.responsible AS responsible,
  usr02.class AS class
FROM usr02
INNER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS _adrp ON _adrp.persnumber = usr21.persnumber AND _adrp.nation = '' AND _adrp.date_from = '00010101'  -- association [0..1]
LEFT OUTER JOIN adcp AS _adcp ON _adcp.persnumber = usr21.persnumber AND _adcp.addrnumber = usr21.addrnumber AND _adcp.nation = '' AND _adcp.date_from = '00010101'  -- association [0..1]
LEFT OUTER JOIN uscompany AS _uscompany ON _uscompany.addrnumber = usr21.addrnumber OR _uscompany.addrnumber = usr21.template_orgaddr  -- association [0..1]
LEFT OUTER JOIN adrc AS _adrc ON _adrc.addrnumber = usr21.addrnumber AND _adrc.nation = '' AND _adrc.date_from = '00010101'  -- association [0..1]
LEFT OUTER JOIN adr6 AS _adr6 ON _adr6.persnumber = usr21.persnumber AND _adr6.addrnumber = usr21.addrnumber AND _adr6.date_from = '00010101' AND _adr6.flgdefault = 'X'  -- association [0..1]
LEFT OUTER JOIN but000 AS _but000 ON _but000.persnumber = usr21.persnumber AND _but000.partner_guid = usr21.bpperson  -- association [0..1]
;