I_EHSClassifierRoot

DDL: I_EHSCLASSIFIERROOT SQL: IEHSCLSFROOT Type: view BASIC
5 Fields 1 Data Sources

EHS Classifier

I_EHSClassifierRoot is a Basic CDS View that provides data about "EHS Classifier" in SAP S/4HANA. It reads from 1 data source (ehfndd_clsf_rt) and exposes 5 fields with key field EHSClassifierUUID.

Data Sources (1)

SourceAliasJoin Type
ehfndd_clsf_rt ehfndd_clsf_rt from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEHSCLSFROOT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EHS Classifier view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EHSClassifierUUID UUID
EHSLocClassifierID bco_id Compliance Requirement
EHSLocClassifierCentralID bco_key BCO KEY
ClassifierMigrationSource migration_src Migration Source
EHSLocClassifierType Worklist Type

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_EHSClassifierRoot.
-- 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: IEHSCLSFROOT

CREATE VIEW I_EHSClassifierRoot AS
SELECT
  cast( db_key as ehfnd_clsf_key_ref_nc preserving type ) AS EHSClassifierUUID,
  bco_id AS EHSLocClassifierID,
  bco_key AS EHSLocClassifierCentralID,
  migration_src AS ClassifierMigrationSource,
  cast( type as ehfnd_clsf_type_vdm preserving type ) AS EHSLocClassifierType
FROM ehfndd_clsf_rt
;

Learn More