EHFNDV_CCI_MAT

9 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncMatlAssgmt view from BASIC Chemical Compliance Material Assignment

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY chmlcmplncmatlassgmtuuid EHFND_CCI_MAT_UUID Product Assignment
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
material EHFND_MAT_ID Product
matlassgmtisprimary EHFND_CCI_CCOMP_IS_PRIMARY Preferred Name

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_CCI_MAT (
    CLIENT,                    -- Client [MANDT]
    CHMLCMPLNCMATLASSGMTUUID,  -- Product Assignment [EHFND_CCI_MAT_UUID]
    CREATIONUTCDATETIME,       -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,             -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,     -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,         -- User Name [UNAME]
    CHMLCMPLNCINFOUUID,        -- Chemical Compliance Information [EHFND_CCI_UUID]
    MATERIAL,                  -- Product [EHFND_MAT_ID]
    MATLASSGMTISPRIMARY,       -- Preferred Name [EHFND_CCI_CCOMP_IS_PRIMARY]
    PRIMARY KEY (CLIENT, CHMLCMPLNCMATLASSGMTUUID)
);

Learn More