ESH_N_COMPANY_ADDRESS_ADDRESS

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 ESH_N_COMPANY_ADDRESS_ADDRESS.
-- 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: ESH_L_COMPA_RESS

CREATE VIEW ESH_N_COMPANY_ADDRESS_ADDRESS AS
SELECT
  addrnumber,
  date_from,
  nation,
  date_to,
  title,
  name1,
  name2,
  city1,
  post_code1,
  po_box,
  street,
  house_num1,
  country,
  region
FROM adrc
LEFT OUTER JOIN ESH_N_COMPANY_ADDRESS_ION_TEXT AS _TO_REGION_TEXT ON country = _TO_REGION_TEXT.land1 AND region = _TO_REGION_TEXT.bland  -- association [0..1]
LEFT OUTER JOIN adr6 AS _TO_COMPANY_STD_EMAIL ON addrnumber = _TO_COMPANY_STD_EMAIL.addrnumber AND _TO_COMPANY_STD_EMAIL.persnumber = ' ' AND _TO_COMPANY_STD_EMAIL.flgdefault = 'X'  -- association [0..1]
LEFT OUTER JOIN adr3 AS _TO_COMPANY_STD_FAX ON addrnumber = _TO_COMPANY_STD_FAX.addrnumber AND _TO_COMPANY_STD_FAX.persnumber = ' ' AND _TO_COMPANY_STD_FAX.flgdefault = 'X'  -- association [0..1]
LEFT OUTER JOIN adr2 AS _TO_COMPANY_STD_MOBILE ON addrnumber = _TO_COMPANY_STD_MOBILE.addrnumber AND _TO_COMPANY_STD_MOBILE.persnumber = ' ' AND _TO_COMPANY_STD_MOBILE.r3_user = '3'  -- association [0..1]
LEFT OUTER JOIN adr2 AS _TO_COMPANY_STD_PHONE ON addrnumber = _TO_COMPANY_STD_PHONE.addrnumber AND _TO_COMPANY_STD_PHONE.persnumber = ' ' AND _TO_COMPANY_STD_PHONE.r3_user = '1'  -- association [0..1]
LEFT OUTER JOIN t005t AS _TO_T005T ON country = _TO_T005T.land1  -- association [0..*]
LEFT OUTER JOIN ESH_N_AD_TITLE_AD_TITLE AS _COMPANY_ADDRESS2AD_TITLE ON title = _COMPANY_ADDRESS2AD_TITLE.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_LAND1_LAND1 AS _COMPANY_ADDRESS2LAND1 ON country = _COMPANY_ADDRESS2LAND1.DOMVALUE_L  -- association [0..*]
;