Ehhss_Expas_Of_Risks_By_Loc

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

CREATE VIEW Ehhss_Expas_Of_Risks_By_Loc AS
SELECT
  Ehhss_Exposures_Of_Risks.rsk_root_key AS rsk_root_key,
  Ehhss_Exposures_Of_Risks.rsk_rev_key AS rsk_rev_key,
  Ehhss_Exposures_Of_Risks.cma_key_ref AS cma_key_ref,
  Ehhss_Exposures_Of_Risks.is_simulated AS is_simulated,
  Ehhss_Exposures_Of_Risks.ras_type AS ras_type,
  Ehhss_Exposures_Of_Risks.loc_name AS loc_name,
  Ehhss_Exposures_Of_Risks.plant_id AS plant_id,
  Ehhss_Exposures_Of_Risks.cost_center AS cost_center,
  Ehhss_Exposures_Of_Risks.company_code AS company_code,
  Ehhss_Exposures_Of_Risks.buss_area AS buss_area,
  Ehhss_Exposures_Of_Risks.job AS job,
  Ehhss_Exposures_Of_Risks.rating_code AS rating_code,
  Ehhss_Exposures_Of_Risks.confid_level AS confid_level,
  Ehhss_Exposures_Of_Risks.reglist_key AS reglist_key,
  Ehhss_Exposures_Of_Risks.stadj_value AS stadj_value,
  Ehhss_Exposures_Of_Risks.oel_value AS oel_value,
  COALESCE( Ehhss_Agt_Name.name, Ehfnd_Lisu_Name.Name ) AS agent_name
FROM Ehfnd_Lhr_Locations
INNER JOIN Ehhss_Exposures_Of_Risks ON /* join condition not captured in parsed metadata */
INNER JOIN Ehhss_Risk_Max_Analys_Type ON /* join condition not captured in parsed metadata */
;