ESH_N_COMPANY_CODE_OMPANY_CODE

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_CODE_OMPANY_CODE.
-- 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_CODE

CREATE VIEW ESH_N_COMPANY_CODE_OMPANY_CODE AS
SELECT
  bukrs,
  butxt,
  ort01,
  land1,
  waers,
  ktopl,
  periv,
  rcomp,
  kkber
FROM t001
LEFT OUTER JOIN ESH_N_PROFIT_CENTER_CEPC_BUKRS AS _COMPANY_CODE2CEPC_BUKRS ON bukrs = _COMPANY_CODE2CEPC_BUKRS.BUKRS  -- association [0..*]
LEFT OUTER JOIN ESH_N_COMPANY_COMPANY AS _COMPANY_CODE2COMPANY ON rcomp = _COMPANY_CODE2COMPANY.RCOMP  -- association [1..1]
LEFT OUTER JOIN ESH_N_KKBER_KKBER AS _KKBER_2_T001 ON kkber = _KKBER_2_T001.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_KTOPL_KTOPL AS _KTOPL_2_T001 ON ktopl = _KTOPL_2_T001.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_LAND1_3_LAND1 AS _LAND1_2_T001 ON land1 = _LAND1_2_T001.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_PERIV_PERIV AS _PERIV_2_T001 ON periv = _PERIV_2_T001.DOMVALUE_L  -- association [0..*]
;