EHFNDW_CCMPS_CMP

Transparent Table Application Table
27 Fields 1 CDS Views

I_CHMLCOMPOSITIONTP I_CHMLCOMPONENTTP

EHFNDW_CCMPS_CMP is an SAP database table in S/4HANA. I_CHMLCOMPOSITIONTP I_CHMLCOMPONENTTP. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SubstBsdCmpstnComponentDraft view from BASIC Draft Substances in compositions

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcompuuid ehfnd_cci_ccomp_uuid Chemical Component
activechmlcompuuid ehfnd_cci_ccomp_uuid Chemical Component
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
hostsubstanceuuid ehfnd_sub_host_uuid Host Substance
chmlcompositionuuid ehfnd_cci_ccmps_uuid Chemical Composition
creationutcdatetime timestampl Time Stamp
createdbyuser uname User Name
lastchangeutcdatetime timestampl Time Stamp
lastchangedbyuser uname User Name
substanceuuid ehfnd_sub_uuid Substance
chmlcomptype ehfnd_cci_ccomp_type_nce Role in Composition
chmlcompqty ehfnd_cci_ccomp_qty Concentration Value
chmlcompqtyastext ehfnd_cci_ccomp_qty_ch Concentration
chmlcompqtyunit ehfnd_unit_code_meins Unit of Measurement
chmlcompoperatorlowerlimit ehfnd_cci_ccomp_lower_operator Operator Lower Limit
chmlcompqtylowerlimit ehfnd_cci_ccomp_lower_limit Lower Limit Value
chmlcompqtylowerlimitastext ehfnd_cci_ccomp_lower_limit_ch Lower Limit
chmlcompoperatorupperlimit ehfnd_cci_ccomp_upper_operator Operator Upper Limit
chmlcompqtyupperlimit ehfnd_cci_ccomp_upper_limit Upper Limit Value
chmlcompqtyupperlimitastext ehfnd_cci_ccomp_upper_limit_ch Upper Limit
chmlcompisremoved ehfnd_cci_ccomp_is_removed Removed Component
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
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_CHMLCOMPOSITIONTP I_CHMLCOMPONENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCMPS_CMP (
    MANDT,                        -- Client [mandt]
    CHMLCOMPUUID,                 -- Chemical Component [ehfnd_cci_ccomp_uuid]
    ACTIVECHMLCOMPUUID,           -- Chemical Component [ehfnd_cci_ccomp_uuid]
    CHMLCMPLNCINFOUUID,           -- Chemical Compliance Information [ehfnd_cci_uuid]
    HOSTSUBSTANCEUUID,            -- Host Substance [ehfnd_sub_host_uuid]
    CHMLCOMPOSITIONUUID,          -- Chemical Composition [ehfnd_cci_ccmps_uuid]
    CREATIONUTCDATETIME,          -- Time Stamp [timestampl]
    CREATEDBYUSER,                -- User Name [uname]
    LASTCHANGEUTCDATETIME,        -- Time Stamp [timestampl]
    LASTCHANGEDBYUSER,            -- User Name [uname]
    SUBSTANCEUUID,                -- Substance [ehfnd_sub_uuid]
    CHMLCOMPTYPE,                 -- Role in Composition [ehfnd_cci_ccomp_type_nce]
    CHMLCOMPQTY,                  -- Concentration Value [ehfnd_cci_ccomp_qty]
    CHMLCOMPQTYASTEXT,            -- Concentration [ehfnd_cci_ccomp_qty_ch]
    CHMLCOMPQTYUNIT,              -- Unit of Measurement [ehfnd_unit_code_meins]
    CHMLCOMPOPERATORLOWERLIMIT,   -- Operator Lower Limit [ehfnd_cci_ccomp_lower_operator]
    CHMLCOMPQTYLOWERLIMIT,        -- Lower Limit Value [ehfnd_cci_ccomp_lower_limit]
    CHMLCOMPQTYLOWERLIMITASTEXT,  -- Lower Limit [ehfnd_cci_ccomp_lower_limit_ch]
    CHMLCOMPOPERATORUPPERLIMIT,   -- Operator Upper Limit [ehfnd_cci_ccomp_upper_operator]
    CHMLCOMPQTYUPPERLIMIT,        -- Upper Limit Value [ehfnd_cci_ccomp_upper_limit]
    CHMLCOMPQTYUPPERLIMITASTEXT,  -- Upper Limit [ehfnd_cci_ccomp_upper_limit_ch]
    CHMLCOMPISREMOVED,            -- Removed Component [ehfnd_cci_ccomp_is_removed]
    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]
    ACTIVEUUID,                   -- Key [/bobf/uuid]
    HASACTIVEENTITY,              -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CHMLCOMPUUID)
);

Learn More