Ehhss_Expas_Distinct_By_Loc

DDL: EHHSS_EXPAS_DISTINCT_BY_LOC SQL: EHHSSV_EXP_DSBL Type: view

Distinct Exposure Assessments by Loc

Ehhss_Expas_Distinct_By_Loc is a CDS View that provides data about "Distinct Exposure Assessments by Loc" in SAP S/4HANA.

Parameters (3)

NameTypeDefault
p_def_langu lang
p_sy_datlo syst_datlo
p_sy_langu lang

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName EHHSSV_EXP_DSBL view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Distinct Exposure Assessments by Loc view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
is_simulated Ehhss_Expas_Of_Risks_By_Loc is_simulated Simulated
ras_type Ehhss_Expas_Of_Risks_By_Loc ras_type Assess. Type
loc_name Ehhss_Expas_Of_Risks_By_Loc loc_name
plant_id Ehhss_Expas_Of_Risks_By_Loc plant_id Plant ID
cost_center Ehhss_Expas_Of_Risks_By_Loc cost_center Posted Cost Center
company_code Ehhss_Expas_Of_Risks_By_Loc company_code Company Code
buss_area Ehhss_Expas_Of_Risks_By_Loc buss_area Business Area
job Ehhss_Expas_Of_Risks_By_Loc job Undefined range (can be used for patch levels)
rating_code Ehhss_Expas_Of_Risks_By_Loc rating_code Exposure Rating Code
confid_level Ehhss_Expas_Of_Risks_By_Loc confid_level Confidence Rating
reglist_key Ehhss_Expas_Of_Risks_By_Loc reglist_key NodeID
stadj_value Ehhss_Expas_Of_Risks_By_Loc stadj_value Stat. Value
oel_value Ehhss_Expas_Of_Risks_By_Loc oel_value
agent_name Ehhss_Expas_Of_Risks_By_Loc agent_name Agent Name

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_Distinct_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_DSBL
-- Parameters: p_def_langu : lang, p_sy_datlo : syst_datlo, p_sy_langu : lang

CREATE VIEW Ehhss_Expas_Distinct_By_Loc AS
SELECT
  Ehhss_Expas_Of_Risks_By_Loc.is_simulated AS is_simulated,
  Ehhss_Expas_Of_Risks_By_Loc.ras_type AS ras_type,
  Ehhss_Expas_Of_Risks_By_Loc.loc_name AS loc_name,
  Ehhss_Expas_Of_Risks_By_Loc.plant_id AS plant_id,
  Ehhss_Expas_Of_Risks_By_Loc.cost_center AS cost_center,
  Ehhss_Expas_Of_Risks_By_Loc.company_code AS company_code,
  Ehhss_Expas_Of_Risks_By_Loc.buss_area AS buss_area,
  Ehhss_Expas_Of_Risks_By_Loc.job AS job,
  Ehhss_Expas_Of_Risks_By_Loc.rating_code AS rating_code,
  Ehhss_Expas_Of_Risks_By_Loc.confid_level AS confid_level,
  Ehhss_Expas_Of_Risks_By_Loc.reglist_key AS reglist_key,
  Ehhss_Expas_Of_Risks_By_Loc.stadj_value AS stadj_value,
  Ehhss_Expas_Of_Risks_By_Loc.oel_value AS oel_value,
  Ehhss_Expas_Of_Risks_By_Loc.agent_name AS agent_name
;