Ehenv_Adef_Amns_At_Location

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

CREATE VIEW Ehenv_Adef_Amns_At_Location AS
SELECT
  Ehfnd_Loc_Curr_Rev_All.plant_id AS plant_id,
  Ehfnd_Loc_Curr_Rev_All.cost_center AS cost_center,
  Ehfnd_Loc_Curr_Rev_All.company_code AS company_code,
  Ehfnd_Loc_Curr_Rev_All.buss_area AS buss_area,
  Ehfnd_Loc_Curr_Rev_All.type AS type,
  Ehfnd_Loc_Curr_Rev_All.country AS country,
  Ehfnd_Loc_Curr_Rev_All.region AS region,
  Ehfnd_Loc_Curr_Rev_All.status AS loc_status,
  Ehenv_Amns_Ext.amount_key AS amount_key,
  Ehenv_Amns_Ext.sourcetype AS sourcetype,
  Ehenv_Amns_Ext.external_src AS external_src,
  Ehenv_Amns_Ext.deviation_id AS deviation_id,
  Ehenv_Amns_Ext.value AS value,
  Ehenv_Amns_Ext.unit_text AS unit_text,
  Adef_root.title AS data_title,
  Adef_root.usage_period AS data_period
FROM Ehenv_Amns_Ext
INNER JOIN ehenvd_scen_root AS Scen_root ON /* join condition not captured in parsed metadata */
INNER JOIN ehenvd_scen_aggr AS Scen_adef ON /* join condition not captured in parsed metadata */
INNER JOIN ehenvd_adef_root AS Adef_root ON /* join condition not captured in parsed metadata */
INNER JOIN Ehfnd_Lhr_Locations ON /* join condition not captured in parsed metadata */
INNER JOIN Ehfnd_Loc_Curr_Rev_All ON /* join condition not captured in parsed metadata */
;