I_CHEMICALROOT

CDS View
4 Fields 5 CDS Views

Chemical Root

I_CHEMICALROOT is a CDS View in S/4HANA. Chemical Root. It contains 4 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ChemicalDetailsC view from COMPOSITE DEPRECATED: Chemcial Details Cube
I_ChmRskAtEHSLocC view from COMPOSITE Chemical Risk at EHS Location Cube
I_EHSSubject view inner COMPOSITE Subject
I_EHSSubjectText view inner COMPOSITE Subject text
P_HzdsSubstInvtrySubstProposal view inner CONSUMPTION

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ChemicalUUID ChemicalUUID 2
_ChemicalType _ChemicalType 2
ChemicalID EHSSubjectID 1
ChemicalType ChemicalType 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Chemical Root
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHEMICALROOT (
    CHEMICALUUID,
    _CHEMICALTYPE,
    CHEMICALID,
    CHEMICALTYPE,
    PRIMARY KEY (CHEMICALUUID)
);

Learn More