EHFNDV_MCMPS_RPS

24 Fields 1 CDS Views

Generated Table for View

EHFNDV_MCMPS_RPS is an SAP database table in S/4HANA. Generated Table for View. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlBsdCmpstnReplacedSubst view from BASIC Substances replaced by a substitute substance

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY substancereplacementuuid EHFND_CCI_MCMPS_RPS_UUID Replaced Substance
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
legaldeviationuuid EHFND_CCI_MCMPS_LEG_DVN_UUID Legal Deviation UUID
replacedsubstanceuuid EHFND_SUB_UUID Substance
chmlcompisdeleted EHFND_CCI_CCOMP_IS_DELETED Deleted Component
substitutesubstanceuuid 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
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
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_MCMPS_RPS (
    MANDT,                        -- Client [MANDT]
    SUBSTANCEREPLACEMENTUUID,     -- Replaced Substance [EHFND_CCI_MCMPS_RPS_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]
    LEGALDEVIATIONUUID,           -- Legal Deviation UUID [EHFND_CCI_MCMPS_LEG_DVN_UUID]
    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]
    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]
    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]
    MATLBSDCMPSTNSUBSTTYPE,       -- Substance Type [EHFND_CCI_CCOMP_MBC_SUBST_TYPE]
    PRIMARY KEY (MANDT, SUBSTANCEREPLACEMENTUUID)
);

Learn More