Ehenv_Amns_All

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 Ehenv_Amns_All.
-- 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: EHENVV_AMNALL
-- Parameters: p_def_langu : lang, p_sy_datlo : syst_datlo, p_sy_langu : lang

CREATE VIEW Ehenv_Amns_All AS
SELECT
  plant_id,
  cost_center,
  company_code,
  buss_area,
  type,
  country,
  region,
  loc_status,
  amount_key,
  sourcetype,
  external_src,
  issue_type,
  deviation_id,
  value,
  unit_text,
  value_day,
  value_month,
  value_year,
  value_date,
  value_time,
  data_title,
  data_period AS p_def_langu,
  p_sy_datlo:$parameters.p_sy_datlo AS p_sy_datlo,
  data_period
FROM Ehenv_Mdef_Amns_T
-- UNION with additional select branch(es): Ehenv_Cdef_Amns_T, Ehenv_Sdef_Amns_T, Ehenv_Adef_Amns_T
;