Ehhss_Exposures_Of_Risks

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_Exposures_Of_Risks.
-- 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_RSKS

CREATE VIEW Ehhss_Exposures_Of_Risks AS
SELECT
  ehhssd_rsk_root.db_key AS rsk_root_key,
  Ehhss_Risk_Current_Revision.risk_rev_key AS rsk_rev_key,
  ehhssd_rsk_root.cma_key_ref AS cma_key_ref,
  ehhssd_rsk_root.is_simulated AS is_simulated,
  ehhssd_rsk_root.ras_type AS ras_type,
  Ehhss_Exposure_Assessment.job AS job,
  Ehhss_Exposure_Assessment.rating_code AS rating_code,
  Ehhss_Exposure_Assessment.confid_level AS confid_level,
  Ehhss_Exposure_Assessment.reglist_key AS reglist_key,
  Ehhss_Exposure_Assessment.stadj_value AS stadj_value,
  Ehhss_Exposure_Assessment.oel_value AS oel_value,
  Ehfnd_Loc_Current_Revision.name AS loc_name,
  Ehfnd_Loc_Current_Revision.plant_id AS plant_id,
  Ehfnd_Loc_Current_Revision.cost_center AS cost_center,
  Ehfnd_Loc_Current_Revision.company_code AS company_code,
  Ehfnd_Loc_Current_Revision.buss_area AS buss_area
FROM ehhssd_rsk_root
INNER JOIN Ehhss_Risk_Current_Revision ON /* join condition not captured in parsed metadata */
INNER JOIN Ehfnd_Loc_Current_Revision ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Ehfnd_Chm_Wpcp_Lisu_with_Sub ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ehhssd_abagt_com ON /* join condition not captured in parsed metadata */
INNER JOIN Ehhss_Exposure_Assessment ON /* join condition not captured in parsed metadata */
;