I_CHMLCOMPOSITION

CDS View
22 Fields 46 CDS Views

Chemical Composition

I_CHMLCOMPOSITION is a CDS View in S/4HANA. Chemical Composition. It contains 22 fields. 46 CDS views read from this table.

CDS Views using this table (46)

ViewTypeJoinVDMDescription
C_CmbndChmlAnlytlCmpstn view inner CONSUMPTION Substance based Analytical Composition
C_CmplRqRsltGHSLblHzdCompVH view inner CONSUMPTION Substance indicated as Hazardous Inducing Component
C_CmplRqRsltHzdsIngrdntSubstVH view inner CONSUMPTION Substance indicated as Hazardous Ingredient VH
C_CmplRqRsltTradeSecretSubstVH view inner CONSUMPTION Substance Indicated as CBI Registration
C_CmpstnHistory view from CONSUMPTION History of Composition
C_GHSLblSensitizingCompVH view inner CONSUMPTION Substance indicated as Sensitizing Components
C_MatlBsdRmngSubstVH view inner CONSUMPTION Remaining Substance of MbC
C_MatlBsdSubstInRmngCompVH view inner CONSUMPTION Substances in Aft Prod Comp of MbC
C_PCTrdScrtSubstVH view inner CONSUMPTION Substance Indicated as CBI
C_PlmrCompositionVH view inner CONSUMPTION Polymer Composition
C_RawChmlCompOfSuplrMatlCmpstn view inner CONSUMPTION Component of Supplier Material Composition
C_US_AnlytlCmpstnRptblQtyCFR view inner CONSUMPTION Reportable Qunatity from Analytical Composition for 49 CFR
I_ChmlCmplncAnlyts1 view inner COMPOSITE Chemical Compliance Info for Analytics
I_ChmlCmplncAnlyts2 view inner COMPOSITE Dimension Product Assignment
I_ChmlCmplncSuplrMatlAnlyts1 view inner COMPOSITE Dimension Raw Material Composition
I_ChmlCompositionActiveDraft view from COMPOSITE Chemical Composition with active and draft data
I_ChmlCompositionProdCatztn view_entity from BASIC Product Categorization of Composition
I_ChmlCompositionStdVH view from COMPOSITE Chemical Composition
I_ChmlCompositionTP view from TRANSACTIONAL Chemical Composition
I_MatlBasedCompositionActvDrft view from BASIC Chemical Composition with active and draft data
I_MatlBasedCompositionTP view from TRANSACTIONAL Material Based Composition
I_ProdCmplncMlticmpProdCmpstn view_entity from COMPOSITE Multicomponent Product Composition
P_AssociatedAnlytlInProcCmpstn view from CONSUMPTION Associated Analytical Compositon with Status In Process
P_AssociatedAnlytlReldCmpstn view from CONSUMPTION Associated Analytical Compositon with Status Released
P_AssociatedMatlInProcCmpstn view from CONSUMPTION Associated Material-based Compositon with Status In Process
P_AssociatedMatlReldCmpstn view from CONSUMPTION Associated Material-based Compositon with Status Released
P_AssociatedProductComposition view from CONSUMPTION Associated Composition of Product
P_AssociatedSubstLglCmpstn view from CONSUMPTION Assoc. Legal Compositon In Process and Released
P_AssociatedSubstLglProcCmpstn view from CONSUMPTION Associated legal Compositon with Status In Process
P_AssociatedSubstLglReldCmpstn view from CONSUMPTION Associated Legal Compositon with Status Released
P_AssociatedTrdSecret view_entity from CONSUMPTION Assoc. Legal Compositon In Process and Released
P_AssociatedTrdSecretProc view_entity from CONSUMPTION Associated trade secret with status in process
P_AssociatedTrdSecretReld view_entity from CONSUMPTION Associated trade secret with status in process
P_ChmlCmplncInfoCmpstnLastDate view from CONSUMPTION CCI Composition Last Date
P_ChmlCmpstnStatusCriticality view inner COMPOSITE Criticality of Chemical Composition
P_ChmlCompositionCriticality view from CONSUMPTION Criticality of Chemical Composition
P_ChmlCompositionMigrationCast view from COMPOSITE Silent Data Migration for Chemical Composition
P_ChmlCompsCompSumCT view from CONSUMPTION Chemical Component Sum Count
P_CmpstnCompNoReldCmpstn view from COMPOSITE Components Without Released Composition
P_NmbrOfChmlCompInCmpst view from BASIC Returns the number of components in a Chemical Composition
P_PlmrCompositionName view from CONSUMPTION Polymer Composition Name
P_SubstanceAssgdCmpstn view from CONSUMPTION Substance assigned compositions
P_SubstPlmrCmpstnUnique view from COMPOSITE Silent Data Migration for ChmlCmplncInfo
P_UpaDaGdsClfnTechName view from CONSUMPTION Technical Names - Analytical Composition
R_ProdMatlBasedCompositionTP view_entity from TRANSACTIONAL Product Material Based Composition - TP
R_SubstanceBasedCompositionTP view_entity from TRANSACTIONAL Substance Based Composition - TP

Fields (22)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID 10
KEY ChmlCompositionType ChmlCompositionType 5
KEY ChmlCompositionUUID ChmlCompositionUUID 5
KEY ProdCmplncLegalArea ProdCmplncLegalArea 8
_ChmlCmplncInfo _ChmlCmplncInfo 1
_CompositionStatus _CompositionStatus 1
_CompositionType _CompositionType 1
_Substance _Substance 1
ChmlCompositionStatus ChmlCompositionStatus 4
ChmlSuplrMatlUUID ChmlSuplrMatlUUID 2
CreatedByUser CreatedByUser 1
CreationUTCDateTime CreationUTCDateTime 2
LastChangedByUser LastChangedByUser 1
LastChangeUTCDateTime LastChangeDateTime,LastChangeUTCDateTime 2
PolymerCompositionIntID PolymerCompositionIntID 3
PolymerCompositionName PolymerCompositionName 1
ProdCmplncLegalAreaRef ProdCmplncLegalAreaRef 1
ReleaseDateTime ReleaseDateTime 2
ReleasedByUser ReleasedByUser 1
SubstanceUUID SubstanceUUID 3
ValidityEndDateTime ValidityEndDateTime 2
ValidityStartDateTime ValidityStartDateTime 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 Composition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHMLCOMPOSITION (
    CHMLCMPLNCINFOUUID,
    CHMLCOMPOSITIONTYPE,
    CHMLCOMPOSITIONUUID,
    PRODCMPLNCLEGALAREA,
    _CHMLCMPLNCINFO,
    _COMPOSITIONSTATUS,
    _COMPOSITIONTYPE,
    _SUBSTANCE,
    CHMLCOMPOSITIONSTATUS,
    CHMLSUPLRMATLUUID,
    CREATEDBYUSER,
    CREATIONUTCDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGEUTCDATETIME,
    POLYMERCOMPOSITIONINTID,
    POLYMERCOMPOSITIONNAME,
    PRODCMPLNCLEGALAREAREF,
    RELEASEDATETIME,
    RELEASEDBYUSER,
    SUBSTANCEUUID,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CHMLCMPLNCINFOUUID, CHMLCOMPOSITIONTYPE, CHMLCOMPOSITIONUUID, PRODCMPLNCLEGALAREA)
);

Learn More