EHFNDV_TXSI

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PCTxSkinIrritationStudy view from BASIC Skin Irritation Study

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pctxskinirrtnprptyuuid EHFND_TX_SI_UUID Skin Irritiation Property
pctxprptyuuid EHFND_TX_UUID Toxicological Property
pctxskinirrtnspeciesphrsuuid EHFND_TX_SI_SPECIES_UUID Species
pctxskinirrtnmethodphrsuuid EHFND_TX_SI_METHOD_UUID Method
pctxexpsrdurn EHFND_EXPOSURE_TIME Exposure Time
pctxexpsrdurnastxt EHFND_EXPOSURE_TIME_CH Exposure Time
pctxexpsrdurnuom EHFND_EXPOSURE_TIME_UNIT Exposure Time Unit
pctxskinirrtnresultphrsuuid EHFND_TX_SI_RESULT_UUID Result
pctxskinirrtnaddlstmntuuid EHFND_TX_SI_ADDL_STMNT_UUID Additional Statement
pcprptyrating EHFND_RATING_TYPE Use of Data
pctxnotetext EHFND_NOTE Comments
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User 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_TXSI (
    MANDT,                         -- Client [MANDT]
    PCTXSKINIRRTNPRPTYUUID,        -- Skin Irritiation Property [EHFND_TX_SI_UUID]
    PCTXPRPTYUUID,                 -- Toxicological Property [EHFND_TX_UUID]
    PCTXSKINIRRTNSPECIESPHRSUUID,  -- Species [EHFND_TX_SI_SPECIES_UUID]
    PCTXSKINIRRTNMETHODPHRSUUID,   -- Method [EHFND_TX_SI_METHOD_UUID]
    PCTXEXPSRDURN,                 -- Exposure Time [EHFND_EXPOSURE_TIME]
    PCTXEXPSRDURNASTXT,            -- Exposure Time [EHFND_EXPOSURE_TIME_CH]
    PCTXEXPSRDURNUOM,              -- Exposure Time Unit [EHFND_EXPOSURE_TIME_UNIT]
    PCTXSKINIRRTNRESULTPHRSUUID,   -- Result [EHFND_TX_SI_RESULT_UUID]
    PCTXSKINIRRTNADDLSTMNTUUID,    -- Additional Statement [EHFND_TX_SI_ADDL_STMNT_UUID]
    PCPRPTYRATING,                 -- Use of Data [EHFND_RATING_TYPE]
    PCTXNOTETEXT,                  -- Comments [EHFND_NOTE]
    CREATIONUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                 -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,         -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,             -- User Name [UNAME]
    PRIMARY KEY (MANDT, PCTXSKINIRRTNPRPTYUUID)
);