EHFNDV_SUB

12 Fields 2 CDS Views

Generated Table for View

EHFNDV_SUB is an SAP database table in S/4HANA. Generated Table for View. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Substance view from BASIC Substance
I_SubstanceActiveDraft view from BASIC Active and draft substances

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient MANDT Client
KEY substanceuuid EHFND_SUB_UUID Substance
listedsubstanceuuid EHFND_SUB_LISU_UUID Listed Substance
substanceinternalname EHFND_SUB_INTERNAL_SUBNAM Internal Name
responsibleunit EHFND_CCI_RESPONSIBLE_UNIT Responsible Unit
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
specification EHFND_INTERNAL_NR Internal Number
specificationinternalid EHFND_EHS_ESERECN Record number
polymerisbsdonoecddef EHFND_SUB_POLYMER_OECD OECD Polymer

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_SUB (
    SAPCLIENT,                -- Client [MANDT]
    SUBSTANCEUUID,            -- Substance [EHFND_SUB_UUID]
    LISTEDSUBSTANCEUUID,      -- Listed Substance [EHFND_SUB_LISU_UUID]
    SUBSTANCEINTERNALNAME,    -- Internal Name [EHFND_SUB_INTERNAL_SUBNAM]
    RESPONSIBLEUNIT,          -- Responsible Unit [EHFND_CCI_RESPONSIBLE_UNIT]
    CREATIONUTCDATETIME,      -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,            -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,    -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,        -- User Name [UNAME]
    SPECIFICATION,            -- Internal Number [EHFND_INTERNAL_NR]
    SPECIFICATIONINTERNALID,  -- Record number [EHFND_EHS_ESERECN]
    POLYMERISBSDONOECDDEF,    -- OECD Polymer [EHFND_SUB_POLYMER_OECD]
    PRIMARY KEY (SAPCLIENT, SUBSTANCEUUID)
);

Learn More