I_ChmRskAtEHSLocC

DDL: I_CHMRSKATEHSLOCC SQL: ICHMRISKATLOCC Type: view COMPOSITE
43 Fields 2 Data Sources 3 Associations

Chemical Risk at EHS Location Cube

I_ChmRskAtEHSLocC is a Composite CDS View (Cube) that provides data about "Chemical Risk at EHS Location Cube" in SAP S/4HANA. It reads from 2 data sources (I_ChemicalRoot, I_EHSRiskRoot) and exposes 43 fields with key fields ChemicalUUID, EHSLocationUUID, Hazard. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ChemicalRoot I_ChemicalRoot from
I_EHSRiskRoot I_EHSRiskRoot inner

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_EHSRisk _EHSRisk $projection.EHSRiskUUID = _EHSRisk.EHSRiskUUID
[0..*] I_Chemical _Chemical $projection.ChemicalUUID = _Chemical.ChemicalUUID
[0..*] I_EHSLocation _EHSLocation $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID

Annotations (12)

NameValueLevelField
EndUserText.label Chemical Risk at EHS Location Cube view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
AbapCatalog.sqlViewName ICHMRISKATLOCC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY ChemicalUUID I_ChemicalRoot ChemicalUUID NodeID
_Chemical _Chemical
KEY EHSLocationUUID I_EHSRiskRoot EHSLocationUUID NodeID
_EHSLocation _EHSLocation
KEY Hazard I_EHSRiskRoot Hazard Hazard
_Hazard I_EHSRiskRoot _Hazard
EHSLocationType
_EHSLocationType
Plant
_Plant
CompanyCode
_CompanyCode
BusinessArea
_BusinessArea
CostCenter
Country
_Country
ControllingArea
_ControllingArea
OrganizationalUnit
_OrganizationalUnit
StorageLocation
_StorageLocation
EHSLocationAuthorizationGroup
_EHSLocationAuthGroup
ChemicalType I_ChemicalRoot ChemicalType Chemical Type
_ChemicalType I_ChemicalRoot _ChemicalType
EHSRiskUUID EHSRiskUUID
_EHSRisk _EHSRisk
EHSRiskType
_EHSRiskType
EHSRiskLevel
_EHSRiskLevel
MethodOfUse I_EHSRiskRoot MethodOfUse Method of Use
_EHSMethodOfUse I_EHSRiskRoot _EHSMethodOfUse
OperationalStatus I_EHSRiskRoot OperationalStatus Operational Status
_EHSOperationalStatus I_EHSRiskRoot _EHSOperationalStatus
HazardCategory I_EHSRiskRoot HazardCategory Hazard Category
_HazardCategory I_EHSRiskRoot _HazardCategory
EHSJobUUID I_EHSRiskRoot EHSJobUUID NodeID
_EHSJob I_EHSRiskRoot _EHSJob
EHSRiskAssessmentType
_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 I_ChmRskAtEHSLocC.
-- 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: ICHMRISKATLOCC

CREATE VIEW I_ChmRskAtEHSLocC AS
SELECT
  I_ChemicalRoot.ChemicalUUID AS ChemicalUUID,
  I_EHSRiskRoot.EHSLocationUUID AS EHSLocationUUID,
  I_EHSRiskRoot.Hazard AS Hazard,
  I_EHSRiskRoot._Hazard AS _Hazard,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].EHSLocationType AS EHSLocationType,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationType AS _EHSLocationType,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].Plant AS Plant,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._Plant AS _Plant,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].CompanyCode AS CompanyCode,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._CompanyCode AS _CompanyCode,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].BusinessArea AS BusinessArea,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._BusinessArea AS _BusinessArea,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].CostCenter AS CostCenter,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].Country AS Country,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._Country AS _Country,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].ControllingArea AS ControllingArea,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._ControllingArea AS _ControllingArea,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].OrganizationalUnit AS OrganizationalUnit,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._OrganizationalUnit AS _OrganizationalUnit,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].StorageLocation AS StorageLocation,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._StorageLocation AS _StorageLocation,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
  _EHSLocation[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationAuthGroup AS _EHSLocationAuthGroup,
  I_ChemicalRoot.ChemicalType AS ChemicalType,
  I_ChemicalRoot._ChemicalType AS _ChemicalType,
  EHSRiskUUID,
  _EHSRisk[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSRiskAnalysisStandard._EHSRiskAnalysis.EHSRiskType AS EHSRiskType,
  _EHSRisk[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSRiskAnalysisStandard._EHSRiskAnalysis._EHSRiskType AS _EHSRiskType,
  _EHSRisk[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSRiskAnalysisStandard._EHSRiskAnalysis.EHSRiskLevel AS EHSRiskLevel,
  _EHSRisk[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSRiskAnalysisStandard._EHSRiskAnalysis._EHSRiskLevel AS _EHSRiskLevel,
  I_EHSRiskRoot.MethodOfUse AS MethodOfUse,
  I_EHSRiskRoot._EHSMethodOfUse AS _EHSMethodOfUse,
  I_EHSRiskRoot.OperationalStatus AS OperationalStatus,
  I_EHSRiskRoot._EHSOperationalStatus AS _EHSOperationalStatus,
  I_EHSRiskRoot.HazardCategory AS HazardCategory,
  I_EHSRiskRoot._HazardCategory AS _HazardCategory,
  I_EHSRiskRoot.EHSJobUUID AS EHSJobUUID,
  I_EHSRiskRoot._EHSJob AS _EHSJob,
  _EHSRisk[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSRiskAssessment.EHSRiskAssessmentType AS EHSRiskAssessmentType,
  _EHSRisk[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSRiskAssessment._EHSRiskAssessmentType AS _EHSRiskAssessmentType
FROM I_ChemicalRoot
INNER JOIN I_EHSRiskRoot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSRisk AS _EHSRisk ON EHSRiskUUID = _EHSRisk.EHSRiskUUID  -- association [0..*]
LEFT OUTER JOIN I_Chemical AS _Chemical ON ChemicalUUID = _Chemical.ChemicalUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
;

Learn More