I_ChemicalRiskReportC

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_ChemicalRiskReportC.
-- 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: ICHMRISKREPORTC

CREATE VIEW I_ChemicalRiskReportC AS
SELECT
  I_ChemicalRevision.ChemicalUUID AS ChemicalUUID,
  I_EHSRiskRoot.EHSLocationUUID AS EHSLocationUUID,
  I_EHSRiskRoot.EHSRiskUUID AS EHSRiskUUID,
  I_ChemicalRevision._ChemicalMaterial.Material AS Material,
  I_ChemicalRevision._ChemicalMaterial._Material AS _Material,
  I_ChemicalRevision._ChemicalHzdsIngredients.ListedSubstanceUUID AS ListedSubstanceUUID,
  I_ChemicalRevision._ChemicalHazardClassEC.ECDangerCategory AS ECDangerCategory,
  I_ChemicalRevision._ChemicalHazardClassEC._ECDangerCategory AS _ECDangerCategory,
  I_ChemicalRevision._ChemicalGHSHazardClass.GHSHazardClassCategory AS GHSHazardClassCategory,
  I_ChemicalRevision._ChemicalGHSHazardClass._GHSHazardClassCategory AS _GHSHazardClassCategory,
  I_ChemicalRevision.ChemicalRevisionUUID AS ChemicalRevisionUUID,
  _EHSLocation.EHSLocationType AS EHSLocationType,
  _EHSLocation._EHSLocationType AS _EHSLocationType,
  _EHSLocation.Plant AS Plant,
  _EHSLocation._Plant AS _Plant,
  _EHSLocation.CompanyCode AS CompanyCode,
  _EHSLocation._CompanyCode AS _CompanyCode,
  _EHSLocation.BusinessArea AS BusinessArea,
  _EHSLocation._BusinessArea AS _BusinessArea,
  _EHSLocation.CostCenter AS CostCenter,
  _EHSLocation.Country AS Country,
  _EHSLocation._Country AS _Country,
  _EHSLocation.ControllingArea AS ControllingArea,
  _EHSLocation._ControllingArea AS _ControllingArea,
  _EHSLocation.OrganizationalUnit AS OrganizationalUnit,
  _EHSLocation._OrganizationalUnit AS _OrganizationalUnit,
  _EHSLocation.StorageLocation AS StorageLocation,
  _EHSLocation._StorageLocation AS _StorageLocation,
  _EHSLocation.EHSLocationAuthorizationGroup AS EHSLocationAuthorizationGroup,
  _EHSLocation._EHSLocationAuthGroup AS _EHSLocationAuthGroup,
  I_ChemicalRevision._ChemicalRoot.ChemicalType AS ChemicalType,
  I_ChemicalRevision._ChemicalRoot._ChemicalType AS _ChemicalType,
  _EHSRisk._EHSRiskAnalysisStandard._EHSRiskAnalysis.EHSRiskType AS EHSRiskType,
  _EHSRisk._EHSRiskAnalysisStandard._EHSRiskAnalysis._EHSRiskType AS _EHSRiskType,
  _EHSRisk._EHSRiskAnalysisStandard._EHSRiskAnalysis.EHSRiskLevel AS EHSRiskLevel,
  _EHSRisk._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.Hazard AS Hazard,
  I_EHSRiskRoot._Hazard AS _Hazard,
  cast ( I_EHSRiskRoot.HazardCategory as ehhss_haz_category_code_nc preserving type ) AS HazardCategory,
  I_EHSRiskRoot._HazardCategory AS _HazardCategory,
  I_EHSRiskRoot.EHSJobUUID AS EHSJobUUID,
  I_EHSRiskRoot._EHSJob AS _EHSJob,
  _EHSRisk._EHSRiskAssessment.EHSRiskAssessmentType AS EHSRiskAssessmentType,
  _EHSRisk._EHSRiskAssessment._EHSRiskAssessmentType AS _EHSRiskAssessmentType
FROM I_ChemicalRevision
INNER JOIN I_EHSRiskRoot ON /* join condition not captured in parsed metadata */
INNER JOIN I_MyEHSLocationExpanded ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrentEHSRisk AS _EHSRisk ON EHSRiskUUID = _EHSRisk.EHSRiskUUID  -- association [0..1]
LEFT OUTER JOIN I_CurrentEHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..1]
LEFT OUTER JOIN I_Chemical AS _Chemical ON ChemicalUUID = _Chemical.ChemicalUUID AND ChemicalRevisionUUID = _Chemical.ChemicalRevisionUUID  -- association [1..1]
LEFT OUTER JOIN I_CurrentChemicalNameText AS _CurrentChemicalNameText ON ChemicalUUID = _CurrentChemicalNameText.ChemicalUUID  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON costcenter = _CostCenter.CostCenter AND controllingarea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_LstdSubstPrimNameTxt AS _LstdSubstPrimNameTxt ON listedsubstanceuuid = _LstdSubstPrimNameTxt.ListedSubstanceUUID  -- association [0..*]
;