EHFNDV_TX

29 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PCTxProperty view from BASIC Toxicological Property

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pctxprptyuuid EHFND_TX_UUID Toxicological Property
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
substanceuuid EHFND_SUB_UUID Substance
pcprptyprocgsts EHFND_PROPERTY_STATUS Processing Status
releasedbyuser EHFND_PROPERTY_RELEASED_BY Released By
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
pctxacuteoralnodatarsnuuid EHFND_TX_AOT_NDRSN_PH_UUID Reason for No Data
pctxacuteinhltnnodatarsnuuid EHFND_TX_AIT_NDRSN_PH_UUID Reason for No Data
pctxacutedermalnodatarsnuuid EHFND_TX_ADT_NDRSN_PH_UUID Reason for No Data
pctxskinirrtnnodatarsnuuid EHFND_TX_SI_NDRSN_PH_UUID Reason for No Data
pctxeyeirrtnnodatarsnuuid EHFND_TX_EI_NDRSN_PH_UUID Reason for No Data
pctxsenstnnodatarsnuuid EHFND_TX_S_NDRSN_PH_UUID Reason for No Data
pctxreptddosenodatarsnuuid EHFND_TX_RDT_NDRSN_PH_UUID Reason for No Data
pctxcrcngnctynodatarsnuuid EHFND_TX_C_NDRSN_PH_UUID Reason for No Data
pctxgentcvitronodatarsnuuid EHFND_TX_GTVT_NDRSN_PH_UUID Reason for No Data
pctxgentcvivonodatarsnuuid EHFND_TX_GTVV_NDRSN_PH_UUID Reason for No Data
pctxrprdvdevnodatarsnuuid EHFND_TX_RD_NDRSN_PH_UUID Reason for No Data
pctxrprdvfrtltynodatarsnuuid EHFND_TX_RF_NDRSN_PH_UUID Reason for No Data
pctxhumanexposurenodatarsnuuid EHFND_TX_EHE_NDRSN_PH_UUID Reason for No Data
pctxnrlgclnodatarsnuuid EHFND_TX_NE_NDRSN_PH_UUID Reason for No Data
pctxothrlvtinfonodatarsnuuid EHFND_TX_ORI_NDRSN_PH_UUID Reason for No Data
pctxothhlthhzdnodatarsnuuid EHFND_TX_OHH_NDRSN_PH_UUID Reason for No Data
pctxspcfcrskassmtnodatarsnuuid EHFND_TX_SRA_NDRSN_PH_UUID Reason for No Data

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_TX (
    MANDT,                           -- Client [MANDT]
    PCTXPRPTYUUID,                   -- Toxicological Property [EHFND_TX_UUID]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [EHFND_CCI_UUID]
    SUBSTANCEUUID,                   -- Substance [EHFND_SUB_UUID]
    PCPRPTYPROCGSTS,                 -- Processing Status [EHFND_PROPERTY_STATUS]
    RELEASEDBYUSER,                  -- Released By [EHFND_PROPERTY_RELEASED_BY]
    VALIDITYSTARTDATETIME,           -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,             -- Valid To [EHFND_VALID_TO_TSTMP]
    CREATIONUTCDATETIME,             -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                   -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,               -- User Name [UNAME]
    PCTXACUTEORALNODATARSNUUID,      -- Reason for No Data [EHFND_TX_AOT_NDRSN_PH_UUID]
    PCTXACUTEINHLTNNODATARSNUUID,    -- Reason for No Data [EHFND_TX_AIT_NDRSN_PH_UUID]
    PCTXACUTEDERMALNODATARSNUUID,    -- Reason for No Data [EHFND_TX_ADT_NDRSN_PH_UUID]
    PCTXSKINIRRTNNODATARSNUUID,      -- Reason for No Data [EHFND_TX_SI_NDRSN_PH_UUID]
    PCTXEYEIRRTNNODATARSNUUID,       -- Reason for No Data [EHFND_TX_EI_NDRSN_PH_UUID]
    PCTXSENSTNNODATARSNUUID,         -- Reason for No Data [EHFND_TX_S_NDRSN_PH_UUID]
    PCTXREPTDDOSENODATARSNUUID,      -- Reason for No Data [EHFND_TX_RDT_NDRSN_PH_UUID]
    PCTXCRCNGNCTYNODATARSNUUID,      -- Reason for No Data [EHFND_TX_C_NDRSN_PH_UUID]
    PCTXGENTCVITRONODATARSNUUID,     -- Reason for No Data [EHFND_TX_GTVT_NDRSN_PH_UUID]
    PCTXGENTCVIVONODATARSNUUID,      -- Reason for No Data [EHFND_TX_GTVV_NDRSN_PH_UUID]
    PCTXRPRDVDEVNODATARSNUUID,       -- Reason for No Data [EHFND_TX_RD_NDRSN_PH_UUID]
    PCTXRPRDVFRTLTYNODATARSNUUID,    -- Reason for No Data [EHFND_TX_RF_NDRSN_PH_UUID]
    PCTXHUMANEXPOSURENODATARSNUUID,  -- Reason for No Data [EHFND_TX_EHE_NDRSN_PH_UUID]
    PCTXNRLGCLNODATARSNUUID,         -- Reason for No Data [EHFND_TX_NE_NDRSN_PH_UUID]
    PCTXOTHRLVTINFONODATARSNUUID,    -- Reason for No Data [EHFND_TX_ORI_NDRSN_PH_UUID]
    PCTXOTHHLTHHZDNODATARSNUUID,     -- Reason for No Data [EHFND_TX_OHH_NDRSN_PH_UUID]
    PCTXSPCFCRSKASSMTNODATARSNUUID,  -- Reason for No Data [EHFND_TX_SRA_NDRSN_PH_UUID]
    PRIMARY KEY (MANDT, PCTXPRPTYUUID)
);

Learn More