ESH_N_COMPANY_COMPANY

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_COMPANY.
-- 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_PANY

CREATE VIEW ESH_N_COMPANY_COMPANY AS
SELECT
  rcomp,
  name1,
  cntry,
  langu,
  stret,
  pobox,
  pstlc,
  city,
  curr,
  rform
FROM t880
LEFT OUTER JOIN ESH_N_LAND1_3_LAND1 AS _LAND1_2_T880 ON cntry = _LAND1_2_T880.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_SPRAS_3_SPRAS AS _SPRAS_2_T880 ON langu = _SPRAS_2_T880.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_WAERS_WAERS AS _WAERS_2_T880 ON curr = _WAERS_2_T880.DOMVALUE_L  -- association [0..*]
;