C_EHSJobHzdAnlysRiskTP

DDL: C_EHSJOBHZDANLYSRISKTP Type: view_entity CONSUMPTION
43 Fields 1 Data Sources 2 Associations

Job Hazard Analysis Risk

C_EHSJobHzdAnlysRiskTP is a Consumption CDS View that provides data about "Job Hazard Analysis Risk" in SAP S/4HANA. It reads from 1 data source (R_EHSRskAssmt2RiskTP) and exposes 43 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_EHSJobHzdAnlysRiskTP _CurrentAssmtRevisionHistory $projection.EHSRisk2Id = _CurrentAssmtRevisionHistory.EHSRisk2Id and _CurrentAssmtRevisionHistory.EHSRiskIsCurrentRevision <> 'X' and $projection.EHSRiskAssessmentUUID = _CurrentAssmtRevisionHistory.EHSRiskAssessmentUUID
[0..*] C_EHSJobHzdAnlysRiskTP _PreviousAssmtRevisionHistory $projection.EHSRisk2Id = _PreviousAssmtRevisionHistory.EHSRisk2Id and $projection.EHSRiskAssessmentUUID <> _PreviousAssmtRevisionHistory.EHSRiskAssessmentUUID and $projection.ehsriskassessmentrevision > _PreviousAssmtRevisionHistory.EHSRiskAssessmentRevision

Annotations (9)

NameValueLevelField
EndUserText.label Job Hazard Analysis 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 (43)

KeyFieldSource TableSource FieldDescription
KEY EHSRiskAssessmentRiskUUID EHSRiskAssessmentRiskUUID UUID
EHSRiskAssessmentUUID EHSRiskAssessmentUUID UUID
EHSRisk2Id EHSRisk2Id
EHSRiskStatus EHSRiskStatus
EHSRiskReleaseDateTime EHSRiskReleaseDateTime
OperationalStatus OperationalStatus Operational Status
OperationalStatusNamelocalized
EHSRiskRevision EHSRiskRevision Revision
EHSRiskAssessmentRevision _RiskAssessment EHSRiskAssessmentRevision Revision
EHSRiskNote EHSRiskNote
EHSRiskAssessmentType EHSRiskAssessmentType Assessment Type
EHSRiskExposureFreqIsEnabled
EHSRiskLevel EHSRiskLevel Risk Level
EHSRiskLevelCriticality _RiskLevel EHSRiskLevelCriticality
EHSRiskLevelNamelocalized
EHSRiskLevelReasonNote EHSRiskLevelReasonNote
EHSRiskSeverity EHSRiskSeverity Severity
EHSRiskSeverityNamelocalized
EHSRiskLikelihood EHSRiskLikelihood Likelihood
EHSRiskLikelihoodNamelocalized
EHSRiskExposureFrequency EHSRiskExposureFrequency Exposure
EHSRiskExposureFrequencyNamelocalized
Hazard Hazard Hazard
HazardNamelocalized
HazardCategory HazardCategory Hazard Category
HazardCategoryNamelocalized
EHSRiskIsCurrentRevision EHSRiskIsCurrentRevision
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ChmlCmplncInternalName _ChmlCmplncInfo ChmlCmplncInternalName Internal Name
MethodOfUse MethodOfUse Method of Use
MethodOfUseNamelocalized
EHSRiskAssessmentJobStepUUID EHSRiskAssessmentJobStepUUID UUID
EHSJobStepName
EHSRiskAssessmentJobStepSqnc
EHSRiskType EHSRiskType
virtualEHSRiskValueehhss_risk_value
int2 Number of Controls
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_EHSJobHzdAnlysRiskTP.
-- 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_EHSJobHzdAnlysRiskTP AS
SELECT
  EHSRiskAssessmentRiskUUID,
  EHSRiskAssessmentUUID,
  EHSRisk2Id,
  EHSRiskStatus,
  EHSRiskReleaseDateTime,
  OperationalStatus,
  _OperationalStatus._Text.OperationalStatusName : localized AS OperationalStatusNamelocalized,
  EHSRiskRevision,
  _RiskAssessment.EHSRiskAssessmentRevision AS EHSRiskAssessmentRevision,
  EHSRiskNote,
  EHSRiskAssessmentType,
  _RiskAssessment._RiskAssessmentType.EHSRiskExposureFreqIsEnabled AS EHSRiskExposureFreqIsEnabled,
  EHSRiskLevel,
  _RiskLevel.EHSRiskLevelCriticality AS EHSRiskLevelCriticality,
  _RiskLevel._Text.EHSRiskLevelName : localized AS EHSRiskLevelNamelocalized,
  EHSRiskLevelReasonNote,
  EHSRiskSeverity,
  _RiskSeverity._Text.EHSRiskSeverityName : localized AS EHSRiskSeverityNamelocalized,
  EHSRiskLikelihood,
  _RiskLikelihood._Text.EHSRiskLikelihoodName : localized AS EHSRiskLikelihoodNamelocalized,
  EHSRiskExposureFrequency,
  _RiskExposureFrequency._Text.EHSRiskExposureFrequencyName : localized AS EHSRiskExposureFrequencyNamelocalized,
  Hazard,
  _Hazard._Text.HazardName : localized AS HazardNamelocalized,
  HazardCategory,
  _HazardCategory._Text.HazardCategoryName : localized AS HazardCategoryNamelocalized,
  EHSRiskIsCurrentRevision,
  ChmlCmplncInfoUUID,
  _ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  MethodOfUse,
  _EHSMethodOfUse._Text.MethodOfUseName : localized AS MethodOfUseNamelocalized,
  EHSRiskAssessmentJobStepUUID,
  _RiskAssessment._JobInfo._JobStep[1: EHSRiskAssessmentJobStepUUID = ehsriskassessmentjobstepuuid ].EHSJobStepName AS EHSJobStepName,
  _RiskAssessment._JobInfo._JobStep[1: EHSRiskAssessmentJobStepUUID = ehsriskassessmentjobstepuuid ].EHSRiskAssessmentJobStepSqnc AS EHSRiskAssessmentJobStepSqnc,
  EHSRiskType,
  virtual EHSRiskValue : ehhss_risk_value AS virtualEHSRiskValueehhss_risk_value,
  virtual NumberOfControlsForEHSRisk : abap.int2 AS int2,
  EHSRiskRevisionRemarkText
FROM R_EHSRskAssmt2RiskTP
LEFT OUTER JOIN C_EHSJobHzdAnlysRiskTP AS _CurrentAssmtRevisionHistory ON EHSRisk2Id = _CurrentAssmtRevisionHistory.EHSRisk2Id AND _CurrentAssmtRevisionHistory.EHSRiskIsCurrentRevision <> 'X' AND EHSRiskAssessmentUUID = _CurrentAssmtRevisionHistory.EHSRiskAssessmentUUID  -- association [0..*]
LEFT OUTER JOIN C_EHSJobHzdAnlysRiskTP AS _PreviousAssmtRevisionHistory ON EHSRisk2Id = _PreviousAssmtRevisionHistory.EHSRisk2Id AND EHSRiskAssessmentUUID <> _PreviousAssmtRevisionHistory.EHSRiskAssessmentUUID AND ehsriskassessmentrevision > _PreviousAssmtRevisionHistory.EHSRiskAssessmentRevision  -- association [0..*]
;

Learn More