I_GHSHazardClassCategory

DDL: I_GHSHAZARDCLASSCATEGORY SQL: ICHCLASS Type: view BASIC Package: EHFND_BO_CHM_CFG
4 Fields 1 Data Sources 1 Associations

Hazard Class/Hazard Category for chemicals according to GHS

I_GHSHazardClassCategory is a Basic CDS View (Dimension) that provides data about "Hazard Class/Hazard Category for chemicals according to GHS" in SAP S/4HANA. It reads from 1 data source (ehfndc_chclass) and exposes 4 fields with key field GHSHazardClassCategory. It has 1 association to related views. Part of development package EHFND_BO_CHM_CFG.

Data Sources (1)

SourceAliasJoin Type
ehfndc_chclass ehfndc_chclass from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_GHSHazardClassCategoryText _Text $projection.GHSHazardClassCategory = _Text.GHSHazardClassCategory

Annotations (12)

NameValueLevelField
EndUserText.label Hazard Class/Hazard Category for chemicals according to GHS view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.representativeKey GHSHazardClassCategory view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ICHCLASS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GHSHazardClassCategory Water Hazard Cl.
_Text _Text
GHSSignalWord signalword Signal Word
GHSClassificationIcon symbol Symbol File

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_GHSHazardClassCategory.
-- 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: ICHCLASS

CREATE VIEW I_GHSHazardClassCategory AS
SELECT
  cast( code as ehfnd_classification_code_nc preserving type ) AS GHSHazardClassCategory,
  signalword AS GHSSignalWord,
  symbol AS GHSClassificationIcon
FROM ehfndc_chclass
LEFT OUTER JOIN I_GHSHazardClassCategoryText AS _Text ON GHSHazardClassCategory = _Text.GHSHazardClassCategory  -- association [0..*]
;

Learn More