I_CHMLCOMPONENT

CDS View
22 Fields 21 CDS Views

Chemical Component

I_CHMLCOMPONENT is a CDS View in S/4HANA. Chemical Component. It contains 22 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
C_ChmlCompOfSubstBsdCmpstn view from CONSUMPTION Components of Substance Based Composition
C_ChmlCompositionComponentVH view from CONSUMPTION Composition Component
C_CmbndChmlAnlytlCmpstn view inner CONSUMPTION Substance based Analytical Composition
C_CmplRqRsltGHSLblHzdCompVH view from CONSUMPTION Substance indicated as Hazardous Inducing Component
C_CmplRqRsltHzdsIngrdntSubstVH view from CONSUMPTION Substance indicated as Hazardous Ingredient VH
C_CmplRqRsltTradeSecretSubstVH view from CONSUMPTION Substance Indicated as CBI Registration
C_GHSLblSensitizingCompVH view inner CONSUMPTION Substance indicated as Sensitizing Components
C_MatlBsdAfterProdCompSubVH view from CONSUMPTION Substances of Aft Prod Comp of MbC
C_MatlBsdRmngSubstVH view from CONSUMPTION Remaining Substance of MbC
C_MatlBsdSubstInRmngCompVH view from CONSUMPTION Substances in Aft Prod Comp of MbC
C_PCTrdScrtSubstVH view from CONSUMPTION Substance Indicated as CBI
C_RawChmlCompOfSuplrMatlCmpstn view from CONSUMPTION Component of Supplier Material Composition
C_US_AnlytlCmpstnRptblQtyCFR view inner CONSUMPTION Reportable Qunatity from Analytical Composition for 49 CFR
I_ChmlComponentOfReldCmpstn view from COMPOSITE Component of Chemical Composition in Status Released
I_ChmlComponentTP view from TRANSACTIONAL Components for composition
I_ChmlSuplrMatlComponentTP view from TRANSACTIONAL Supplier Material Component
P_ChmlSuplrMatlComponentCntr view from CONSUMPTION
P_CmbndChmlAnlytlCmpstnTotal view inner COMPOSITE
P_NmbrOfChmlCompInCmpst view inner BASIC
R_ProdMatlBsdProducedSubstTP view_entity from TRANSACTIONAL Produced Sub of Mat Bsd Composition - TP
R_SubstanceBasedComponentTP view_entity from TRANSACTIONAL Substance Bsd Composition Component - TP

Fields (22)

KeyField CDS FieldsUsed in Views
KEY ChmlCompUUID ChmlCompUUID 4
KEY SubstanceUUID CompanySubstanceNavgnLink,SubstanceUUID 10
_ChemicalComposition _ChemicalComposition 1
_ChmlCmplncInfo _ChmlCmplncInfo 2
_ComponentType _ComponentType 1
_OperatorLowerLimit _OperatorLowerLimit 1
_OperatorUpperLimit _OperatorUpperLimit 1
_Substance _Substance 2
_UnitOfMeasure _UnitOfMeasure 1
ChmlCmplncInfoUUID ChmlCmplncInfoUUID 4
ChmlCompIsRemoved ChmlCompIsRemoved 1
ChmlCompOperatorLowerLimit ChmlCompOperatorLowerLimit 3
ChmlCompOperatorUpperLimit ChmlCompOperatorUpperLimit,ChmlCompReldUprLimitQtyOptr 7
ChmlCompositionUUID ChmlCompositionUUID 4
ChmlCompQty ChmlCompQty 4
ChmlCompQtyAsText ChmlCompQtyAsText 4
ChmlCompQtyLowerLimit ChmlCompQtyLowerLimit 3
ChmlCompQtyLowerLimitAsText ChmlCompQtyLowerLimitAsText,ChmlCompReldLowrLimitQtyAsText 8
ChmlCompQtyUnit ChmlCompQtyUnit 5
ChmlCompQtyUpperLimit ChmlCompQtyUpperLimit 3
ChmlCompQtyUpperLimitAsText ChmlCompQtyUpperLimitAsText,ChmlCompReldUprLimitQtyAsText 8
ChmlCompType ChmlCompType 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 Component
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHMLCOMPONENT (
    CHMLCOMPUUID,
    SUBSTANCEUUID,
    _CHEMICALCOMPOSITION,
    _CHMLCMPLNCINFO,
    _COMPONENTTYPE,
    _OPERATORLOWERLIMIT,
    _OPERATORUPPERLIMIT,
    _SUBSTANCE,
    _UNITOFMEASURE,
    CHMLCMPLNCINFOUUID,
    CHMLCOMPISREMOVED,
    CHMLCOMPOPERATORLOWERLIMIT,
    CHMLCOMPOPERATORUPPERLIMIT,
    CHMLCOMPOSITIONUUID,
    CHMLCOMPQTY,
    CHMLCOMPQTYASTEXT,
    CHMLCOMPQTYLOWERLIMIT,
    CHMLCOMPQTYLOWERLIMITASTEXT,
    CHMLCOMPQTYUNIT,
    CHMLCOMPQTYUPPERLIMIT,
    CHMLCOMPQTYUPPERLIMITASTEXT,
    CHMLCOMPTYPE,
    PRIMARY KEY (CHMLCOMPUUID, SUBSTANCEUUID)
);

Learn More