EHFNDW_MCMPS_SCP

Transparent Table Application Table
25 Fields 2 CDS Views

I_MATLBASEDCOMPOSITIONTP I_MATLBSDPRODUCEDSUBSTTP

EHFNDW_MCMPS_SCP is an SAP database table in S/4HANA. I_MATLBASEDCOMPOSITIONTP I_MATLBSDPRODUCEDSUBSTTP. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MatlBsdProducedSubstDraft view from BASIC Draft Produced Subst. in Matl.Bsd.Cmpstn
I_SubstBsdCmpstnCompActiveDrft view from BASIC Substances as components in compositions

Fields (25)

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
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
polymercompositionintidref ehfnd_sub_pcmps_int_id_ref Internal Number Reference
chmlcompisremoved ehfnd_cci_ccomp_is_removed Removed Component
matlbsdcmpstnsubsttype ehfnd_cci_ccomp_mbc_subst_type Substance Type
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_MATLBASEDCOMPOSITIONTP I_MATLBSDPRODUCEDSUBSTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_MCMPS_SCP (
    MANDT,                        -- Client [mandt]
    CHMLCOMPUUID,                 -- Chemical Component [ehfnd_cci_ccomp_uuid]
    ACTIVECHMLCOMPUUID,           -- Chemical Component [ehfnd_cci_ccomp_uuid]
    CHMLCMPLNCINFOUUID,           -- Chemical Compliance Information [ehfnd_cci_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]
    POLYMERCOMPOSITIONINTIDREF,   -- Internal Number Reference [ehfnd_sub_pcmps_int_id_ref]
    CHMLCOMPISREMOVED,            -- Removed Component [ehfnd_cci_ccomp_is_removed]
    MATLBSDCMPSTNSUBSTTYPE,       -- Substance Type [ehfnd_cci_ccomp_mbc_subst_type]
    ACTIVEUUID,                   -- Key [/bobf/uuid]
    HASACTIVEENTITY,              -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CHMLCOMPUUID)
);

Learn More