C_EHSRiskAtMyLocation

DDL: C_EHSRISKATMYLOCATION SQL: CEHSRSKMYLOC Type: view CONSUMPTION
41 Fields 2 Data Sources

EHS Risk

C_EHSRiskAtMyLocation is a Consumption CDS View that provides data about "EHS Risk" in SAP S/4HANA. It reads from 2 data sources (C_EHSRisk, I_MyEHSLocationExpanded) and exposes 41 fields with key fields EHSRiskUUID, EHSRiskUUIDHex, EHSRiskAssessmentUUIDHex.

Data Sources (2)

SourceAliasJoin Type
C_EHSRisk C_EHSRisk from
I_MyEHSLocationExpanded I_MyEHSLocationExpanded inner

Annotations (17)

NameValueLevelField
EndUserText.label EHS Risk view
VDM.viewType #CONSUMPTION view
ObjectModel.updateEnabled false view
ObjectModel.createEnabled false view
AccessControl.authorizationCheck #CHECK view
UI.headerInfo.typeName Risk view
UI.headerInfo.typeNamePlural Risks view
UI.headerInfo.title.value EHSRiskUUID view
Consumption.semanticObject EHSRisk view
OData.publish true view
AbapCatalog.sqlViewName CEHSRSKMYLOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY EHSRiskUUID C_EHSRisk EHSRiskUUID
_EHSRiskRoot C_EHSRisk _EHSRiskRoot
KEY EHSRiskUUIDHex C_EHSRisk EHSRiskUUIDHex
KEY EHSRiskAssessmentUUIDHex C_EHSRisk EHSRiskAssessmentUUIDHex
Hazard C_EHSRisk Hazard Hazard
_Hazard C_EHSRisk _Hazard
HazardCategory C_EHSRisk HazardCategory Hazard Category
_HazardCategory C_EHSRisk _HazardCategory
EHSAgentUUID C_EHSRisk EHSAgentUUID Agent
_EHSAgent C_EHSRisk _EHSAgent
EHSLocationUUID C_EHSRisk EHSLocationUUID NodeID
_EHSLocation C_EHSRisk _EHSLocation
EHSJobUUID C_EHSRisk EHSJobUUID NodeID
_EHSJob C_EHSRisk _EHSJob
EHSRiskAssessmentUUID C_EHSRisk EHSRiskAssessmentUUID UUID
_EHSRiskAssessment C_EHSRisk _EHSRiskAssessment
EHSRiskLevel C_EHSRisk EHSRiskLevel Risk Level
_EHSRiskLevel C_EHSRisk _EHSRiskLevel
EHSRiskStatus C_EHSRisk EHSRiskStatus
_EHSRiskStatus C_EHSRisk _EHSRiskStatus
OperationalStatus C_EHSRisk OperationalStatus Operational Status
_EHSOperationalStatus C_EHSRisk _EHSOperationalStatus
MethodOfUse C_EHSRisk MethodOfUse Method of Use
_EHSMethodOfUse C_EHSRisk _EHSMethodOfUse
StorageLocation C_EHSRisk StorageLocation StorageLocation
_StorageLocation C_EHSRisk _StorageLocation
EHSLocationAuthorizationGroup C_EHSRisk EHSLocationAuthorizationGroup
_EHSLocationAuthGroup C_EHSRisk _EHSLocationAuthGroup
BusinessArea C_EHSRisk BusinessArea Business Area
_BusinessArea C_EHSRisk _BusinessArea
Plant C_EHSRisk Plant Valuation Area
_Plant C_EHSRisk _Plant
CostCenter C_EHSRisk CostCenter Cost Center
CompanyCode C_EHSRisk CompanyCode Receiver Company Code
_CompanyCode C_EHSRisk _CompanyCode
ControllingArea C_EHSRisk ControllingArea Controlling Area
_ControllingArea C_EHSRisk _ControllingArea
OrganizationalUnit C_EHSRisk OrganizationalUnit Org. Unit ID
_OrganizationalUnit C_EHSRisk _OrganizationalUnit
EHSRiskAssessmentType C_EHSRisk EHSRiskAssessmentType Assessment Type
_EHSRiskAssessmentType C_EHSRisk _EHSRiskAssessmentType

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_EHSRiskAtMyLocation.
-- 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: CEHSRSKMYLOC

CREATE VIEW C_EHSRiskAtMyLocation AS
SELECT
  C_EHSRisk.EHSRiskUUID AS EHSRiskUUID,
  C_EHSRisk._EHSRiskRoot AS _EHSRiskRoot,
  C_EHSRisk.EHSRiskUUIDHex AS EHSRiskUUIDHex,
  C_EHSRisk.EHSRiskAssessmentUUIDHex AS EHSRiskAssessmentUUIDHex,
  C_EHSRisk.Hazard AS Hazard,
  C_EHSRisk._Hazard AS _Hazard,
  C_EHSRisk.HazardCategory AS HazardCategory,
  C_EHSRisk._HazardCategory AS _HazardCategory,
  C_EHSRisk.EHSAgentUUID AS EHSAgentUUID,
  C_EHSRisk._EHSAgent AS _EHSAgent,
  C_EHSRisk.EHSLocationUUID AS EHSLocationUUID,
  C_EHSRisk._EHSLocation AS _EHSLocation,
  C_EHSRisk.EHSJobUUID AS EHSJobUUID,
  C_EHSRisk._EHSJob AS _EHSJob,
  C_EHSRisk.EHSRiskAssessmentUUID AS EHSRiskAssessmentUUID,
  C_EHSRisk._EHSRiskAssessment AS _EHSRiskAssessment,
  C_EHSRisk.EHSRiskLevel AS EHSRiskLevel,
  C_EHSRisk._EHSRiskLevel AS _EHSRiskLevel,
  C_EHSRisk.EHSRiskStatus AS EHSRiskStatus,
  C_EHSRisk._EHSRiskStatus AS _EHSRiskStatus,
  C_EHSRisk.OperationalStatus AS OperationalStatus,
  C_EHSRisk._EHSOperationalStatus AS _EHSOperationalStatus,
  C_EHSRisk.MethodOfUse AS MethodOfUse,
  C_EHSRisk._EHSMethodOfUse AS _EHSMethodOfUse,
  C_EHSRisk.StorageLocation AS StorageLocation,
  C_EHSRisk._StorageLocation AS _StorageLocation,
  C_EHSRisk.EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
  C_EHSRisk._EHSLocationAuthGroup AS _EHSLocationAuthGroup,
  C_EHSRisk.BusinessArea AS BusinessArea,
  C_EHSRisk._BusinessArea AS _BusinessArea,
  C_EHSRisk.Plant AS Plant,
  C_EHSRisk._Plant AS _Plant,
  C_EHSRisk.CostCenter AS CostCenter,
  C_EHSRisk.CompanyCode AS CompanyCode,
  C_EHSRisk._CompanyCode AS _CompanyCode,
  C_EHSRisk.ControllingArea AS ControllingArea,
  C_EHSRisk._ControllingArea AS _ControllingArea,
  C_EHSRisk.OrganizationalUnit AS OrganizationalUnit,
  C_EHSRisk._OrganizationalUnit AS _OrganizationalUnit,
  C_EHSRisk.EHSRiskAssessmentType AS EHSRiskAssessmentType,
  C_EHSRisk._EHSRiskAssessmentType AS _EHSRiskAssessmentType
FROM C_EHSRisk
INNER JOIN I_MyEHSLocationExpanded ON /* join condition not captured in parsed metadata */
;

Learn More