Ehhss_Exposure_Assessment

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_Exposure_Assessment.
-- 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_EXPASS

CREATE VIEW Ehhss_Exposure_Assessment AS
SELECT
  ehhssd_expas_rt.job AS job,
  ehhssd_expas_rev.split_date AS split_date,
  ehhssd_expas_rev.split_time AS split_time,
  ehhssd_expas_rev.rating_code AS rating_code,
  ehhssd_expas_rev.reglist_key AS reglist_key,
  ehhssd_expas_rev.stadj_value AS stadj_value,
  ehhssd_expas_rev.value_meas AS oel_value,
  ehhssc_conflvl.confid_level AS confid_level
FROM ehhssd_expas_rt
INNER JOIN ehhssd_expas_rev ON /* join condition not captured in parsed metadata */
INNER JOIN ehhssc_conflvl ON /* join condition not captured in parsed metadata */
;