EHFNDW_MCMPS_RPS

Transparent Table Application Table
27 Fields 1 CDS Views

I_MATLBASEDCOMPOSITIONTP I_MATLBSDCMPSTNREPLACEDSUBSTTP

EHFNDW_MCMPS_RPS is an SAP database table in S/4HANA. I_MATLBASEDCOMPOSITIONTP I_MATLBSDCMPSTNREPLACEDSUBSTTP. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlBsdReplacedSubstDraft view from BASIC Draft Replaced Substances

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY substancereplacementuuid ehfnd_cci_mcmps_rps_uuid Replaced Substance
activesubstancereplacementuuid ehfnd_cci_mcmps_rps_uuid Replaced Substance
legaldeviationuuid ehfnd_cci_mcmps_leg_dvn_uuid Legal Deviation UUID
chmlcompositionuuid ehfnd_cci_ccmps_uuid Chemical Composition
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
creationutcdatetime timestampl Time Stamp
createdbyuser uname User Name
lastchangeutcdatetime timestampl Time Stamp
lastchangedbyuser uname User Name
replacedsubstanceuuid ehfnd_sub_uuid Substance
chmlcompisdeleted ehfnd_cci_ccomp_is_deleted Deleted Component
substitutesubstanceuuid 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
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_MATLBSDCMPSTNREPLACEDSUBSTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_MCMPS_RPS (
    MANDT,                           -- Client [mandt]
    SUBSTANCEREPLACEMENTUUID,        -- Replaced Substance [ehfnd_cci_mcmps_rps_uuid]
    ACTIVESUBSTANCEREPLACEMENTUUID,  -- Replaced Substance [ehfnd_cci_mcmps_rps_uuid]
    LEGALDEVIATIONUUID,              -- Legal Deviation UUID [ehfnd_cci_mcmps_leg_dvn_uuid]
    CHMLCOMPOSITIONUUID,             -- Chemical Composition [ehfnd_cci_ccmps_uuid]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [ehfnd_cci_uuid]
    CREATIONUTCDATETIME,             -- Time Stamp [timestampl]
    CREATEDBYUSER,                   -- User Name [uname]
    LASTCHANGEUTCDATETIME,           -- Time Stamp [timestampl]
    LASTCHANGEDBYUSER,               -- User Name [uname]
    REPLACEDSUBSTANCEUUID,           -- Substance [ehfnd_sub_uuid]
    CHMLCOMPISDELETED,               -- Deleted Component [ehfnd_cci_ccomp_is_deleted]
    SUBSTITUTESUBSTANCEUUID,         -- 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]
    MATLBSDCMPSTNSUBSTTYPE,          -- Substance Type [ehfnd_cci_ccomp_mbc_subst_type]
    ACTIVEUUID,                      -- Key [/bobf/uuid]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, SUBSTANCEREPLACEMENTUUID)
);

Learn More