EHFNDW_MCMPS_DVN

Transparent Table Application Table
12 Fields 1 CDS Views

I_MATLBASEDCOMPOSITIONTP I_MATLBSDCMPSTNLGLDEVIATIONTP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlBsdCmpstnLglDvtnDrft view from BASIC Draft Legal Deviations

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY legaldeviationuuid ehfnd_cci_mcmps_leg_dvn_uuid Legal Deviation UUID
activelegaldeviationuuid ehfnd_cci_mcmps_leg_dvn_uuid Legal Deviation UUID
chmlcompositionuuid ehfnd_cci_ccmps_uuid Chemical Composition
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
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
legaldeviation ehfnd_cci_mcmps_leg_dvn Legal Deviation
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_MATLBSDCMPSTNLGLDEVIATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_MCMPS_DVN (
    MANDT,                     -- Client [mandt]
    LEGALDEVIATIONUUID,        -- Legal Deviation UUID [ehfnd_cci_mcmps_leg_dvn_uuid]
    ACTIVELEGALDEVIATIONUUID,  -- Legal Deviation UUID [ehfnd_cci_mcmps_leg_dvn_uuid]
    CHMLCOMPOSITIONUUID,       -- Chemical Composition [ehfnd_cci_ccmps_uuid]
    CHMLCMPLNCINFOUUID,        -- Chemical Compliance Information [ehfnd_cci_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]
    LEGALDEVIATION,            -- Legal Deviation [ehfnd_cci_mcmps_leg_dvn]
    ACTIVEUUID,                -- Key [/bobf/uuid]
    HASACTIVEENTITY,           -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, LEGALDEVIATIONUUID)
);

Learn More