Ehenv_Mdef_Amns_T

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

CREATE VIEW Ehenv_Mdef_Amns_T AS
SELECT
  mdef_amns.plant_id AS plant_id,
  mdef_amns.cost_center AS cost_center,
  mdef_amns.company_code AS company_code,
  mdef_amns.buss_area AS buss_area,
  mdef_amns.type AS type,
  mdef_amns.country AS country,
  mdef_amns.region AS region,
  mdef_amns.loc_status AS loc_status,
  mdef_amns.amount_key AS amount_key,
  mdef_amns.sourcetype AS sourcetype,
  mdef_amns.external_src AS external_src,
  mdef_amns.issue_type AS issue_type,
  mdef_amns.deviation_id AS deviation_id,
  mdef_amns.value AS value,
  mdef_amns.unit_text AS unit_text,
  mdef_amns.value_date AS value_date,
  substring(cast(mdef_amns.valuetimestamp as abap.char(17)), 1, 4) AS value_year,
  substring(cast(mdef_amns.valuetimestamp as abap.char(17)), 5, 2) AS value_month,
  substring(cast(mdef_amns.valuetimestamp as abap.char(17)), 7, 2) AS value_day,
  cast(substring(cast(mdef_amns.valuetimestamp as abap.char(17)), 9, 6) as abap.tims) AS value_time,
  mdef_amns.data_title AS data_title,
  mdef_amns.data_period AS data_period
FROM Ehenv_Mdef_Amns
LEFT OUTER JOIN dd07t AS IType_txt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS DType_txt ON /* join condition not captured in parsed metadata */
;