EHFNDW_MCMPS

Transparent Table Application Table
16 Fields 1 CDS Views

I_MATLBASEDCOMPOSITIONTP I_MATLBASEDCOMPOSITIONTP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlBasedCompositionDraft view from BASIC Chemical Composition Draft Data

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcompositionuuid ehfnd_cci_ccmps_uuid Chemical Composition
activechmlcompositionuuid ehfnd_cci_ccmps_uuid Chemical Composition
creationutcdatetime ehfnd_bo_crea_date_time Created On
createdbyuser ehfnd_bo_crea_uname Created By
lastchangeutcdatetime ehfnd_bo_lchg_date_time Last Changed On
lastchangedbyuser ehfnd_bo_lchg_uname Last Changed By
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
chmlcompositiontype ehfnd_cci_ccmps_type Legal Area
chmlcompositionstatus ehfnd_cci_ccmps_status Processing Status
releasedbyuser ehfnd_release_user Released By
validitystartdatetime ehfnd_valid_from_tstmp Valid From
validityenddatetime ehfnd_valid_to_tstmp Valid To
prodcmplnclegalarea ehfnd_legal_area Legal Area
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_MATLBASEDCOMPOSITIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_MCMPS (
    MANDT,                      -- Client [mandt]
    CHMLCOMPOSITIONUUID,        -- Chemical Composition [ehfnd_cci_ccmps_uuid]
    ACTIVECHMLCOMPOSITIONUUID,  -- Chemical Composition [ehfnd_cci_ccmps_uuid]
    CREATIONUTCDATETIME,        -- Created On [ehfnd_bo_crea_date_time]
    CREATEDBYUSER,              -- Created By [ehfnd_bo_crea_uname]
    LASTCHANGEUTCDATETIME,      -- Last Changed On [ehfnd_bo_lchg_date_time]
    LASTCHANGEDBYUSER,          -- Last Changed By [ehfnd_bo_lchg_uname]
    CHMLCMPLNCINFOUUID,         -- Chemical Compliance Information [ehfnd_cci_uuid]
    CHMLCOMPOSITIONTYPE,        -- Legal Area [ehfnd_cci_ccmps_type]
    CHMLCOMPOSITIONSTATUS,      -- Processing Status [ehfnd_cci_ccmps_status]
    RELEASEDBYUSER,             -- Released By [ehfnd_release_user]
    VALIDITYSTARTDATETIME,      -- Valid From [ehfnd_valid_from_tstmp]
    VALIDITYENDDATETIME,        -- Valid To [ehfnd_valid_to_tstmp]
    PRODCMPLNCLEGALAREA,        -- Legal Area [ehfnd_legal_area]
    ACTIVEUUID,                 -- Key [/bobf/uuid]
    HASACTIVEENTITY,            -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, CHMLCOMPOSITIONUUID)
);

Learn More