A_GHSSignalWordForSafetyInfo

DDL: A_GHSSIGNALWORDFORSAFETYINFO SQL: AGHSSWFORSRI Type: view COMPOSITE Package: EHFND_CNS_CHEMICAL
3 Fields 4 Data Sources

GHS Signal Word for Safety Relevant Info

A_GHSSignalWordForSafetyInfo is a Composite CDS View that provides data about "GHS Signal Word for Safety Relevant Info" in SAP S/4HANA. It reads from 4 data sources (I_ChemicalRevision, I_GHSHazardClassCategory, I_GHSSignalWord, I_GHSSignalWordPriority) and exposes 3 fields with key field ChemicalUUID. Part of development package EHFND_CNS_CHEMICAL.

Data Sources (4)

SourceAliasJoin Type
I_ChemicalRevision ChemicalRevision inner
I_GHSHazardClassCategory GHSHazClassCat inner
I_GHSSignalWord GHSSignalWord inner
I_GHSSignalWordPriority SigWordPrio inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AGHSSWFORSRI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label GHS Signal Word for Safety Relevant Info view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey ChemicalUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ChemicalUUID ChmGHSHazClass ChemicalUUID NodeID
GHSSignalWord I_GHSSignalWord GHSSignalWord Signal Word
GHSSignalWordPriority I_GHSSignalWord GHSSignalWordPriority Workflow priority

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 A_GHSSignalWordForSafetyInfo.
-- 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: AGHSSWFORSRI

CREATE VIEW A_GHSSignalWordForSafetyInfo AS
SELECT
  ChmGHSHazClass.ChemicalUUID AS ChemicalUUID,
  GHSSignalWord.GHSSignalWord AS GHSSignalWord,
  GHSSignalWord.GHSSignalWordPriority AS GHSSignalWordPriority
INNER JOIN I_GHSHazardClassCategory AS GHSHazClassCat ON /* join condition not captured in parsed metadata */
INNER JOIN I_GHSSignalWord AS GHSSignalWord ON /* join condition not captured in parsed metadata */
INNER JOIN I_GHSSignalWordPriority AS SigWordPrio ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChemicalRevision AS ChemicalRevision ON /* join condition not captured in parsed metadata */
;

Learn More