I_Chemical

DDL: I_CHEMICAL SQL: ICHEMICAL Type: view COMPOSITE Package: EHFND_BO_CHM_IMPL
20 Fields 1 Data Sources 7 Associations

Chemical

I_Chemical is a Composite CDS View (Dimension) that provides data about "Chemical" in SAP S/4HANA. It reads from 1 data source (I_ChemicalRevision) and exposes 20 fields with key fields ChemicalUUID, RevisionEndDate. It has 7 associations to related views. Part of development package EHFND_BO_CHM_IMPL.

Data Sources (1)

SourceAliasJoin Type
I_ChemicalRevision I_ChemicalRevision from

Associations (7)

CardinalityTargetAliasCondition
[0..*] I_EHSRisk _EHSRisk $projection.ChemicalUUID = _EHSRisk.ChemicalUUID
[0..*] I_ChemicalNameText _ChemicalName $projection.ChemicalUUID = _ChemicalName.ChemicalUUID and $projection.ChemicalRevisionUUID = _ChemicalName.ChemicalRevisionUUID
[0..1] I_ChemicalHzdsIngredConcat _ChemicalHzdsIngredConcat I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalHzdsIngredConcat.ChemicalRevisionUUID and I_ChemicalRevision.ChemicalUUID = _ChemicalHzdsIngredConcat.ChemicalUUID and I_ChemicalRevision.RevisionEndDate = _ChemicalHzdsIngredConcat.RevisionEndDate
[0..1] I_ChemicalECDangerCatConcat _ChemicalECDangerCatConcat I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalECDangerCatConcat.ChemicalRevisionUUID and I_ChemicalRevision.ChemicalUUID = _ChemicalECDangerCatConcat.ChemicalUUID and I_ChemicalRevision.RevisionEndDate = _ChemicalECDangerCatConcat.RevisionEndDate
[0..1] I_ChemicalGHSClassConcat _ChemicalGHSClassConcat I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalGHSClassConcat.ChemicalRevisionUUID and I_ChemicalRevision.ChemicalUUID = _ChemicalGHSClassConcat .ChemicalUUID and I_ChemicalRevision.RevisionEndDate = _ChemicalGHSClassConcat .RevisionEndDate
[0..1] I_ChemicalGHSHzrdStmntConcat _ChemicalGHSHzrdStmntConcat I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalGHSHzrdStmntConcat.ChemicalRevisionUUID and I_ChemicalRevision.ChemicalUUID = _ChemicalGHSHzrdStmntConcat.ChemicalUUID and I_ChemicalRevision.RevisionEndDate = _ChemicalGHSHzrdStmntConcat.RevisionEndDate
[0..1] I_ChemicalECRiskPhraseConcat _ChemicalECRiskPhraseConcat I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalECRiskPhraseConcat.ChemicalRevisionUUID and I_ChemicalRevision.ChemicalUUID = _ChemicalECRiskPhraseConcat.ChemicalUUID and I_ChemicalRevision.RevisionEndDate = _ChemicalECRiskPhraseConcat.RevisionEndDate

Annotations (14)

NameValueLevelField
EndUserText.label Chemical view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey ChemicalUUID view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ICHEMICAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ChemicalUUID I_ChemicalRevision ChemicalUUID NodeID
KEY RevisionEndDate I_ChemicalRevision RevisionEndDate Valn End date
ChemicalBasicInfoUUID
RevisionStartDate I_ChemicalRevision RevisionStartDate Rev. Start Date
ChemicalRevisionUUID I_ChemicalRevision ChemicalRevisionUUID UUID
ChemicalStatus I_ChemicalRevision ChemicalStatus Workflow Status
_ChemicalRoot _ChemicalRoot
_ChemicalName _ChemicalName
_ChemicalBasicInfo _ChemicalBasicInfo
_ChemicalMaterial _ChemicalMaterial
_ChemicalHzdsIngredients _ChemicalHzdsIngredients
_ChemicalGHSHazardClass _ChemicalGHSHazardClass
_ChemicalGHSHazardStatement _ChemicalGHSHazardStatement
_ChemicalHazardClassEC _ChemicalHazardClassEC
_ChemicalSafetyRelevantInfo _ChemicalSafetyRelevantInfo
_EHSRisk _EHSRisk
CreationDateTime I_ChemicalRevision CreationDateTime Timestamp
CreatedByUser I_ChemicalRevision CreatedByUser User Name
LastChangeDateTime I_ChemicalRevision LastChangeDateTime Timestamp
LastChangedByUser I_ChemicalRevision LastChangedByUser User Name

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_Chemical.
-- 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: ICHEMICAL

CREATE VIEW I_Chemical AS
SELECT
  I_ChemicalRevision.ChemicalUUID AS ChemicalUUID,
  I_ChemicalRevision.RevisionEndDate AS RevisionEndDate,
  I_ChemicalRevision._ChemicalBasicInfo.ChemicalBasicInfoUUID AS ChemicalBasicInfoUUID,
  I_ChemicalRevision.RevisionStartDate AS RevisionStartDate,
  I_ChemicalRevision.ChemicalRevisionUUID AS ChemicalRevisionUUID,
  I_ChemicalRevision.ChemicalStatus AS ChemicalStatus,
  I_ChemicalRevision.CreationDateTime AS CreationDateTime,
  I_ChemicalRevision.CreatedByUser AS CreatedByUser,
  I_ChemicalRevision.LastChangeDateTime AS LastChangeDateTime,
  I_ChemicalRevision.LastChangedByUser AS LastChangedByUser
FROM I_ChemicalRevision
LEFT OUTER JOIN I_EHSRisk AS _EHSRisk ON ChemicalUUID = _EHSRisk.ChemicalUUID  -- association [0..*]
LEFT OUTER JOIN I_ChemicalNameText AS _ChemicalName ON ChemicalUUID = _ChemicalName.ChemicalUUID AND ChemicalRevisionUUID = _ChemicalName.ChemicalRevisionUUID  -- association [0..*]
LEFT OUTER JOIN I_ChemicalHzdsIngredConcat AS _ChemicalHzdsIngredConcat ON I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalHzdsIngredConcat.ChemicalRevisionUUID AND I_ChemicalRevision.ChemicalUUID = _ChemicalHzdsIngredConcat.ChemicalUUID AND I_ChemicalRevision.RevisionEndDate = _ChemicalHzdsIngredConcat.RevisionEndDate  -- association [0..1]
LEFT OUTER JOIN I_ChemicalECDangerCatConcat AS _ChemicalECDangerCatConcat ON I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalECDangerCatConcat.ChemicalRevisionUUID AND I_ChemicalRevision.ChemicalUUID = _ChemicalECDangerCatConcat.ChemicalUUID AND I_ChemicalRevision.RevisionEndDate = _ChemicalECDangerCatConcat.RevisionEndDate  -- association [0..1]
LEFT OUTER JOIN I_ChemicalGHSClassConcat AS _ChemicalGHSClassConcat ON I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalGHSClassConcat.ChemicalRevisionUUID AND I_ChemicalRevision.ChemicalUUID = _ChemicalGHSClassConcat .ChemicalUUID AND I_ChemicalRevision.RevisionEndDate = _ChemicalGHSClassConcat .RevisionEndDate  -- association [0..1]
LEFT OUTER JOIN I_ChemicalGHSHzrdStmntConcat AS _ChemicalGHSHzrdStmntConcat ON I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalGHSHzrdStmntConcat.ChemicalRevisionUUID AND I_ChemicalRevision.ChemicalUUID = _ChemicalGHSHzrdStmntConcat.ChemicalUUID AND I_ChemicalRevision.RevisionEndDate = _ChemicalGHSHzrdStmntConcat.RevisionEndDate  -- association [0..1]
LEFT OUTER JOIN I_ChemicalECRiskPhraseConcat AS _ChemicalECRiskPhraseConcat ON I_ChemicalRevision.ChemicalRevisionUUID = _ChemicalECRiskPhraseConcat.ChemicalRevisionUUID AND I_ChemicalRevision.ChemicalUUID = _ChemicalECRiskPhraseConcat.ChemicalUUID AND I_ChemicalRevision.RevisionEndDate = _ChemicalECRiskPhraseConcat.RevisionEndDate  -- association [0..1]
;

Learn More