Ehenv_Amns_All_Loc_Filter

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

CREATE VIEW Ehenv_Amns_All_Loc_Filter AS
SELECT
  Ehenv_Location_All.plant_id AS plant_id,
  Ehenv_Location_All.cost_center AS cost_center,
  Ehenv_Location_All.company_code AS company_code,
  Ehenv_Location_All.buss_area AS buss_area,
  Ehenv_Location_All.type AS type,
  Ehenv_Location_All.country AS country,
  Ehenv_Location_All.region AS region,
  Ehenv_Location_All.loc_status AS loc_status,
  amns.db_key AS amount_key,
  amns.value AS value,
  t006a.mseht AS unit_text,
  mdef_root.name AS name,
  mdef_root.title AS data_title,
  mdef_root.mdef_period AS data_period,
  cast( mdef_root.subject_root_key_ref as ehfnd_sbj_key_ref_txt ) AS subject_name,
  amns.deviation_id AS deviation_id,
  amns.external_src AS external_src,
  cast(substring(cast(valuetimestamp as abap.char(17)), 1, 8) as abap.dats) AS value_date,
  substring(cast(valuetimestamp as abap.char(17)), 1, 4) AS value_year,
  substring(cast(valuetimestamp as abap.char(17)), 7, 2) AS value_day,
  cast(substring(cast(valuetimestamp as abap.char(17)), 9, 6) as abap.tims) AS value_time
FROM Ehenv_Location_All
INNER JOIN ehenvd_mdef_root AS mdef_root ON /* join condition not captured in parsed metadata */
INNER JOIN ehfndd_amns_root AS amns ON /* join condition not captured in parsed metadata */
INNER JOIN t006a ON /* join condition not captured in parsed metadata */
INNER JOIN ehenvd_cdef_resh AS cdef_resh ON /* join condition not captured in parsed metadata */
INNER JOIN ehenvd_cdef_root AS cdef_root 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 ehenvd_sdef_root AS sdef_root ON /* join condition not captured in parsed metadata */
INNER JOIN ehenvd_sdef_samp AS sdef_sampling ON /* join condition not captured in parsed metadata */
INNER JOIN ehenvd_sdef_head AS sdef_header ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): Ehenv_Location_All
;