I_EHSSubjectText

DDL: I_EHSSUBJECTTEXT SQL: EHSSUBJTEXT Type: view COMPOSITE
11 Fields 7 Data Sources 1 Associations

Subject text

I_EHSSubjectText is a Composite CDS View that provides data about "Subject text" in SAP S/4HANA. It reads from 7 data sources and exposes 11 fields with key fields EHSSubjectUUID, Language, EHSSubjectText, Language, EHSSubjectText. It has 1 association to related views.

Data Sources (7)

SourceAliasJoin Type
C_ChmlCmplncPrimMatl C_ChmlCmplncPrimMatl union
I_ChemicalBasicInfo ChemicalBasicInfo inner
I_ChemicalNameText ChemicalNameText union
I_ChemicalRevision ChemicalRevision inner
I_ChemicalRoot ChemicalRoot inner
I_EHSChemicalPhysicalPropName I_EHSChemicalPhysicalPropName from
I_ListedSubstanceDefName I_ListedSubstanceDefName union

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName EHSSUBJTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Subject text view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey EHSSubjectUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EHSSubjectUUID EHSChemicalPhysicalPropUUID CCI Property
KEY Language Language Report Text Language
KEY EHSSubjectText EHSPropertyName Subject Name
ChemicalUUIDasEHSSubjectUUID
KEY Language I_ChemicalNameText Language Report Text Language
KEY EHSSubjectText I_ChemicalNameText NameOfChemical Subject Name
KEY Language Language Report Text Language
KEY EHSSubjectText ListedSubstanceName Subject Name
KEY Language Report Text Language
KEY EHSSubjectText ChmlCmplncInfoCombinedName Subject Name
_Language _Language

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_EHSSubjectText.
-- 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: EHSSUBJTEXT

CREATE VIEW I_EHSSubjectText AS
SELECT
  EHSChemicalPhysicalPropUUID AS EHSSubjectUUID,
  Language,
  EHSPropertyName AS EHSSubjectText
FROM I_EHSChemicalPhysicalPropName
INNER JOIN I_ChemicalRoot AS ChemicalRoot ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChemicalRevision AS ChemicalRevision ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChemicalBasicInfo AS ChemicalBasicInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
-- UNION with additional select branch(es): I_ChemicalNameText, I_ListedSubstanceDefName, C_ChmlCmplncPrimMatl
;

Learn More