EHFNDW_MCMPS_BPC

Transparent Table Application Table
24 Fields 1 CDS Views

I_MATLBASEDCOMPOSITIONTP I_MATLBSDBEFOREPRODNCOMPTP

EHFNDW_MCMPS_BPC is an SAP database table in S/4HANA. I_MATLBASEDCOMPOSITIONTP I_MATLBSDBEFOREPRODNCOMPTP. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlBsdBeforeProdnCompDraft view from BASIC Component before production draft

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matlbsdcompuuid ehfnd_cci_mcomp_uuid Chemical Component
activematlbsdcompuuid ehfnd_cci_mcomp_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
matlbsdcompproductiontype ehfnd_cci_mcomp_productiontype Production Type
compchmlcmplncinfouuid ehfnd_cci_mcomp_cci_uuid Component
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
mlticmpprodcompuuid ehfnd_cci_comp_in_mcp_uuid
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_MATLBSDBEFOREPRODNCOMPTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_MCMPS_BPC (
    MANDT,                        -- Client [mandt]
    MATLBSDCOMPUUID,              -- Chemical Component [ehfnd_cci_mcomp_uuid]
    ACTIVEMATLBSDCOMPUUID,        -- Chemical Component [ehfnd_cci_mcomp_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]
    MATLBSDCOMPPRODUCTIONTYPE,    -- Production Type [ehfnd_cci_mcomp_productiontype]
    COMPCHMLCMPLNCINFOUUID,       -- Component [ehfnd_cci_mcomp_cci_uuid]
    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]
    MLTICMPPRODCOMPUUID,          -- ehfnd_cci_comp_in_mcp_uuid
    ACTIVEUUID,                   -- Key [/bobf/uuid]
    HASACTIVEENTITY,              -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, MATLBSDCOMPUUID)
);

Learn More