C_EHSRskAssmt2RiskTP

DDL: C_EHSRSKASSMT2RISKTP Type: view_entity CONSUMPTION
41 Fields 1 Data Sources 2 Associations

Risk Assessment V2 Risk

C_EHSRskAssmt2RiskTP is a Consumption CDS View that provides data about "Risk Assessment V2 Risk" in SAP S/4HANA. It reads from 1 data source (R_EHSRskAssmt2RiskTP) and exposes 41 fields with key field EHSRiskAssessmentRiskUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_EHSRskAssmt2RiskTP R_EHSRskAssmt2RiskTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_EHSRskAssmt2RiskTP _CurrentAssmtRevisionHistory $projection.EHSRisk2Id = _CurrentAssmtRevisionHistory.EHSRisk2Id and _CurrentAssmtRevisionHistory.EHSRiskIsCurrentRevision <> 'X' and $projection.EHSRiskAssessmentUUID = _CurrentAssmtRevisionHistory.EHSRiskAssessmentUUID
[0..*] C_EHSRskAssmt2RiskTP _PreviousAssmtRevisionHistory $projection.EHSRisk2Id = _PreviousAssmtRevisionHistory.EHSRisk2Id and $projection.EHSRiskAssessmentUUID <> _PreviousAssmtRevisionHistory.EHSRiskAssessmentUUID and $projection.ehsriskassessmentrevision > _PreviousAssmtRevisionHistory.EHSRiskAssessmentRevision

Annotations (9)

NameValueLevelField
EndUserText.label Risk Assessment V2 Risk view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey EHSRiskAssessmentRiskUUID view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY EHSRiskAssessmentRiskUUID EHSRiskAssessmentRiskUUID UUID
EHSRiskAssessmentUUID EHSRiskAssessmentUUID UUID
EHSRisk2Id EHSRisk2Id
EHSRiskStatus EHSRiskStatus
EHSRiskReleaseDateTime EHSRiskReleaseDateTime
OperationalStatus OperationalStatus Operational Status
OperationalStatusNamelocalized
EHSRiskRevision EHSRiskRevision Revision
EHSRiskNote EHSRiskNote
EHSRiskAssessmentRevision _RiskAssessment EHSRiskAssessmentRevision Revision
EHSRiskAssessmentType EHSRiskAssessmentType Assessment Type
EHSRiskExposureFreqIsEnabled
EHSRiskLevel EHSRiskLevel Risk Level
EHSRiskLevelReasonNote EHSRiskLevelReasonNote
EHSRiskLevelNamelocalized
EHSRiskLevelCriticality _RiskLevel EHSRiskLevelCriticality
virtualEHSRiskValueehhss_risk_value
EHSRiskSeverity EHSRiskSeverity Severity
EHSRiskLikelihood EHSRiskLikelihood Likelihood
EHSRiskExposureFrequency EHSRiskExposureFrequency Exposure
Hazard Hazard Hazard
HazardNamelocalized
HazardCategory HazardCategory Hazard Category
EHSRiskIsCurrentRevision EHSRiskIsCurrentRevision
HazardCategoryNamelocalized
EHSRiskSeverityNamelocalized
EHSRiskLikelihoodNamelocalized
EHSRiskExposureFrequencyNamelocalized
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncInternalName _ChmlCmplncInfo ChmlCmplncInternalName Internal Name
EHSRiskType EHSRiskType
int2 Number of Controls
MethodOfUse MethodOfUse Method of Use
MethodOfUseNamelocalized
EHSRiskAssessmentJobStepUUID EHSRiskAssessmentJobStepUUID UUID
EHSRiskRevisionRemarkText EHSRiskRevisionRemarkText
_Hazard _Hazard
_HazardCategory _HazardCategory
_OperationalStatus _OperationalStatus
_CurrentAssmtRevisionHistory _CurrentAssmtRevisionHistory
_PreviousAssmtRevisionHistory _PreviousAssmtRevisionHistory

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 C_EHSRskAssmt2RiskTP.
-- 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 C_EHSRskAssmt2RiskTP AS
SELECT
  EHSRiskAssessmentRiskUUID,
  EHSRiskAssessmentUUID,
  EHSRisk2Id,
  EHSRiskStatus,
  EHSRiskReleaseDateTime,
  OperationalStatus,
  _OperationalStatus._Text.OperationalStatusName : localized AS OperationalStatusNamelocalized,
  EHSRiskRevision,
  EHSRiskNote,
  _RiskAssessment.EHSRiskAssessmentRevision AS EHSRiskAssessmentRevision,
  EHSRiskAssessmentType,
  _RiskAssessment._RiskAssessmentType.EHSRiskExposureFreqIsEnabled AS EHSRiskExposureFreqIsEnabled,
  EHSRiskLevel,
  EHSRiskLevelReasonNote,
  _RiskLevel._Text.EHSRiskLevelName : localized AS EHSRiskLevelNamelocalized,
  _RiskLevel.EHSRiskLevelCriticality AS EHSRiskLevelCriticality,
  virtual EHSRiskValue : ehhss_risk_value AS virtualEHSRiskValueehhss_risk_value,
  EHSRiskSeverity,
  EHSRiskLikelihood,
  EHSRiskExposureFrequency,
  Hazard,
  _Hazard._Text.HazardName : localized AS HazardNamelocalized,
  HazardCategory,
  EHSRiskIsCurrentRevision,
  _HazardCategory._Text.HazardCategoryName : localized AS HazardCategoryNamelocalized,
  _RiskSeverity._Text.EHSRiskSeverityName : localized AS EHSRiskSeverityNamelocalized,
  _RiskLikelihood._Text.EHSRiskLikelihoodName : localized AS EHSRiskLikelihoodNamelocalized,
  _RiskExposureFrequency._Text.EHSRiskExposureFrequencyName : localized AS EHSRiskExposureFrequencyNamelocalized,
  ChmlCmplncInfoUUID,
  _ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  EHSRiskType,
  virtual NumberOfControlsForEHSRisk : abap.int2 AS int2,
  MethodOfUse,
  _EHSMethodOfUse._Text.MethodOfUseName : localized AS MethodOfUseNamelocalized,
  EHSRiskAssessmentJobStepUUID,
  EHSRiskRevisionRemarkText
FROM R_EHSRskAssmt2RiskTP
LEFT OUTER JOIN C_EHSRskAssmt2RiskTP AS _CurrentAssmtRevisionHistory ON EHSRisk2Id = _CurrentAssmtRevisionHistory.EHSRisk2Id AND _CurrentAssmtRevisionHistory.EHSRiskIsCurrentRevision <> 'X' AND EHSRiskAssessmentUUID = _CurrentAssmtRevisionHistory.EHSRiskAssessmentUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSRskAssmt2RiskTP AS _PreviousAssmtRevisionHistory ON EHSRisk2Id = _PreviousAssmtRevisionHistory.EHSRisk2Id AND EHSRiskAssessmentUUID <> _PreviousAssmtRevisionHistory.EHSRiskAssessmentUUID AND ehsriskassessmentrevision > _PreviousAssmtRevisionHistory.EHSRiskAssessmentRevision  -- association [0..*]
;

Learn More