EHFNDD_CCIDFRVAL

Transparent Table Application Table

Chemical Compliance Identifier Value

EHFNDD_CCIDFRVAL is an SAP database table in S/4HANA. Chemical Compliance Identifier Value. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncIdfrValue view_entity from BASIC Chemical Compliance Identifier Value

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY chmlcmplncidfrvalueuuid EHFND_CCIDFR_VALUE_UUID Identifier Value UUID
chmlcmplncidfruuid EHFND_CCIDFR_UUID Identifier UUID
creationutcdatetime ABP_CREATION_TSTMPL Created On
createdbyuser ABP_CREATION_USER Created By
lastchangeutcdatetime ABP_LASTCHANGE_TSTMPL Changed On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By
chmlcmplncidfrparenttype EHFND_CCIDFR_PARENT_TYPE Parent Type
chmlcmplncidfrtype EHFND_CCIDFR_TYPE Type
chmlcmplncidfrcategory EHFND_CCIDFR_CATEGORY Identifier Category
language EHFND_LANGU Language
prodcmplnclegalarea EHFND_LEGAL_AREA Legal Area
chmlcmplncidfrsequencenumber EHFND_CCIDFR_SEQ_NUM Sequence Number of an Identifier
chmlcmplncidfrvalue EHFND_CCIDFR_VALUE Identifier Value

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.

-- Chemical Compliance Identifier Value
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_CCIDFRVAL (
    CLIENT,                        -- Client [MANDT]
    CHMLCMPLNCIDFRVALUEUUID,       -- Identifier Value UUID [EHFND_CCIDFR_VALUE_UUID]
    CHMLCMPLNCIDFRUUID,            -- Identifier UUID [EHFND_CCIDFR_UUID]
    CREATIONUTCDATETIME,           -- Created On [ABP_CREATION_TSTMPL]
    CREATEDBYUSER,                 -- Created By [ABP_CREATION_USER]
    LASTCHANGEUTCDATETIME,         -- Changed On [ABP_LASTCHANGE_TSTMPL]
    LASTCHANGEDBYUSER,             -- Changed By [ABP_LASTCHANGE_USER]
    CHMLCMPLNCIDFRPARENTTYPE,      -- Parent Type [EHFND_CCIDFR_PARENT_TYPE]
    CHMLCMPLNCIDFRTYPE,            -- Type [EHFND_CCIDFR_TYPE]
    CHMLCMPLNCIDFRCATEGORY,        -- Identifier Category [EHFND_CCIDFR_CATEGORY]
    LANGUAGE,                      -- Language [EHFND_LANGU]
    PRODCMPLNCLEGALAREA,           -- Legal Area [EHFND_LEGAL_AREA]
    CHMLCMPLNCIDFRSEQUENCENUMBER,  -- Sequence Number of an Identifier [EHFND_CCIDFR_SEQ_NUM]
    CHMLCMPLNCIDFRVALUE,           -- Identifier Value [EHFND_CCIDFR_VALUE]
    PRIMARY KEY (CLIENT, CHMLCMPLNCIDFRVALUEUUID)
);