EHFNDV_CCI_PURP

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncPrpsAssgmt view from BASIC Chemical Compliance Purpose Assignment

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY chmlcmplncprpsassgmtuuid EHFND_CCI_PURP_UUID Purpose Assignment
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
cmplncprpsuuid EHFND_CMPLNC_PRPS_UUID Compliance Purpose

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_PURP (
    CLIENT,                    -- Client [MANDT]
    CHMLCMPLNCPRPSASSGMTUUID,  -- Purpose Assignment [EHFND_CCI_PURP_UUID]
    CHMLCMPLNCINFOUUID,        -- Chemical Compliance Information [EHFND_CCI_UUID]
    CREATIONUTCDATETIME,       -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,             -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,     -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,         -- User Name [UNAME]
    CMPLNCPRPSUUID,            -- Compliance Purpose [EHFND_CMPLNC_PRPS_UUID]
    PRIMARY KEY (CLIENT, CHMLCMPLNCPRPSASSGMTUUID)
);