I_EHSRiskMatrixExposureFrqcy

DDL: I_EHSRISKMATRIXEXPOSUREFRQCY Type: view_entity BASIC Package: EHHSS_BO_RAS2_CFG
6 Fields 1 Data Sources 2 Associations

Risk Matrix Exposure Frequency

I_EHSRiskMatrixExposureFrqcy is a Basic CDS View that provides data about "Risk Matrix Exposure Frequency" in SAP S/4HANA. It reads from 1 data source (ehhssc_rmxexp) and exposes 6 fields with key fields EHSRiskMatrix, EHSRiskExposureFrequency. It has 2 associations to related views. Part of development package EHHSS_BO_RAS2_CFG.

Data Sources (1)

SourceAliasJoin Type
ehhssc_rmxexp ehhssc_rmxexp from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_EHSRiskMatrixExposureFrqcyT _Text $projection.EHSRiskExposureFrequency = _Text.EHSRiskExposureFrequency and $projection.EHSRiskMatrix = _Text.EHSRiskMatrix
[0..1] I_EHSRiskMatrix _EHSRiskMatrix $projection.EHSRiskMatrix = _EHSRiskMatrix.EHSRiskMatrix

Annotations (8)

NameValueLevelField
EndUserText.label Risk Matrix Exposure Frequency view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.representativeKey EHSRiskExposureFrequency view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EHSRiskMatrix ehsriskmatrix
KEY EHSRiskExposureFrequency ehsriskexposurefrequency Exposure
EHSRiskExposureFrqcyDcmlValue ehsriskexposurefrqcydcmlvalue
EHSRiskExposureFrqcySortNumber ehsriskexposurefrqcysortnumber
_Text _Text
_EHSRiskMatrix _EHSRiskMatrix

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 I_EHSRiskMatrixExposureFrqcy.
-- 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.

CREATE VIEW I_EHSRiskMatrixExposureFrqcy AS
SELECT
  EHSRiskMatrix,
  EHSRiskExposureFrequency,
  EHSRiskExposureFrqcyDcmlValue,
  EHSRiskExposureFrqcySortNumber
FROM ehhssc_rmxexp
LEFT OUTER JOIN I_EHSRiskMatrixExposureFrqcyT AS _Text ON EHSRiskExposureFrequency = _Text.EHSRiskExposureFrequency AND EHSRiskMatrix = _Text.EHSRiskMatrix  -- association [0..*]
LEFT OUTER JOIN I_EHSRiskMatrix AS _EHSRiskMatrix ON EHSRiskMatrix = _EHSRiskMatrix.EHSRiskMatrix  -- association [0..1]
;

Learn More