EHFNDV_CCMPS_CMP

26 Fields 3 CDS Views

Generated Table for View

EHFNDV_CCMPS_CMP is an SAP database table in S/4HANA. Generated Table for View. It contains 26 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ChmlComponent view from BASIC Chemical Component
I_SubstBsdCmpstnCompActiveDrft view union_all BASIC Substances as components in compositions
I_SubstBsdCmpstnComponent view from BASIC Substances as components in compositions

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlcompuuid EHFND_CCI_CCOMP_UUID Chemical Component
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
chmlsuplrmatluuid EHFND_CSM_UUID Supplier Raw Material
hostsubstanceuuid EHFND_SUB_HOST_UUID Host Substance
chmlcompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
substanceuuid EHFND_SUB_UUID Substance
chmlcomptype EHFND_CCI_CCOMP_TYPE Role in Composition
chmlcompqty EHFND_CCI_CCOMP_QTY Concentration Value
chmlcompqtyunit EHFND_UNIT_CODE_MEINS Unit of Measurement
chmlcompqtylowerlimit EHFND_CCI_CCOMP_LOWER_LIMIT Lower Limit Value
chmlcompqtyupperlimit EHFND_CCI_CCOMP_UPPER_LIMIT Upper Limit Value
chmlcompoperatorlowerlimit EHFND_CCI_CCOMP_LOWER_OPERATOR Operator Lower Limit
chmlcompoperatorupperlimit EHFND_CCI_CCOMP_UPPER_OPERATOR Operator Upper Limit
chmlcompisremoved EHFND_CCI_CCOMP_IS_REMOVED Removed Component
chmlcompqtyastext EHFND_CCI_CCOMP_QTY_CH Concentration
chmlcompqtylowerlimitastext EHFND_CCI_CCOMP_LOWER_LIMIT_CH Lower Limit
chmlcompqtyupperlimitastext EHFND_CCI_CCOMP_UPPER_LIMIT_CH Upper Limit
polymercompositionintidref EHFND_SUB_PCMPS_INT_ID_REF Internal Number Reference
pctrdscrtidentityismasked EHFND_TS_IDENTITY_IS_MASKED Use Generic Name
pctrdscrtrangeismasked EHFND_TS_RANGE_IS_MASKED Mark Range as Confidential
matlbsdcmpstnsubsttype EHFND_CCI_CCOMP_MBC_SUBST_TYPE Substance Type

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_CCMPS_CMP (
    MANDT,                        -- Client [MANDT]
    CHMLCOMPUUID,                 -- Chemical Component [EHFND_CCI_CCOMP_UUID]
    CREATIONUTCDATETIME,          -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,        -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,            -- User Name [UNAME]
    CHMLCMPLNCINFOUUID,           -- Chemical Compliance Information [EHFND_CCI_UUID]
    CHMLSUPLRMATLUUID,            -- Supplier Raw Material [EHFND_CSM_UUID]
    HOSTSUBSTANCEUUID,            -- Host Substance [EHFND_SUB_HOST_UUID]
    CHMLCOMPOSITIONUUID,          -- Chemical Composition [EHFND_CCI_CCMPS_UUID]
    SUBSTANCEUUID,                -- Substance [EHFND_SUB_UUID]
    CHMLCOMPTYPE,                 -- Role in Composition [EHFND_CCI_CCOMP_TYPE]
    CHMLCOMPQTY,                  -- Concentration Value [EHFND_CCI_CCOMP_QTY]
    CHMLCOMPQTYUNIT,              -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    CHMLCOMPQTYLOWERLIMIT,        -- Lower Limit Value [EHFND_CCI_CCOMP_LOWER_LIMIT]
    CHMLCOMPQTYUPPERLIMIT,        -- Upper Limit Value [EHFND_CCI_CCOMP_UPPER_LIMIT]
    CHMLCOMPOPERATORLOWERLIMIT,   -- Operator Lower Limit [EHFND_CCI_CCOMP_LOWER_OPERATOR]
    CHMLCOMPOPERATORUPPERLIMIT,   -- Operator Upper Limit [EHFND_CCI_CCOMP_UPPER_OPERATOR]
    CHMLCOMPISREMOVED,            -- Removed Component [EHFND_CCI_CCOMP_IS_REMOVED]
    CHMLCOMPQTYASTEXT,            -- Concentration [EHFND_CCI_CCOMP_QTY_CH]
    CHMLCOMPQTYLOWERLIMITASTEXT,  -- Lower Limit [EHFND_CCI_CCOMP_LOWER_LIMIT_CH]
    CHMLCOMPQTYUPPERLIMITASTEXT,  -- Upper Limit [EHFND_CCI_CCOMP_UPPER_LIMIT_CH]
    POLYMERCOMPOSITIONINTIDREF,   -- Internal Number Reference [EHFND_SUB_PCMPS_INT_ID_REF]
    PCTRDSCRTIDENTITYISMASKED,    -- Use Generic Name [EHFND_TS_IDENTITY_IS_MASKED]
    PCTRDSCRTRANGEISMASKED,       -- Mark Range as Confidential [EHFND_TS_RANGE_IS_MASKED]
    MATLBSDCMPSTNSUBSTTYPE,       -- Substance Type [EHFND_CCI_CCOMP_MBC_SUBST_TYPE]
    PRIMARY KEY (MANDT, CHMLCOMPUUID)
);

Learn More