EHFNDV_TXRD

55 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PCTxRprdvDevStudy view from BASIC Reprotoxicity Dev Study

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pctxrprdvdevprptyuuid EHFND_TX_RD_UUID Property
pctxprptyuuid EHFND_TX_UUID Toxicological Property
pctxtesttypephrsuuid EHFND_TX_RD_TEST_TYPE_UUID Test Type
pctxrprdvdevmethodphrsuuid EHFND_TX_RD_METHOD_UUID Method
pctxrprdvdevspeciesphrsuuid EHFND_TX_RD_SPECIES_UUID Species
pctxrprdvdevstrainphrsuuid EHFND_TX_RD_STRAIN_UUID Strain
pctxsexphrsuuid EHFND_TX_SEX_UUID Sex
pctxrouteofapplphrsuuid EHFND_TX_APPL_ROUTE_UUID Route of Application
pctxrprdvdevdurn EHFND_TX_DURATION Duration of Treatment
pctxrprdvdevdurnastxt EHFND_TX_DURATION_CH Duration Of Treatment as Text
pctxrprdvdevdurnuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxfrequencyphrsuuid EHFND_TX_FREQUENCY_UUID Frequency of Treatment
pctxgtmvaltypephrsuuid EHFND_TX_RD_GTM_VALTYPE_UUID Gen. Tox. Maternal Value Type
pctxgtmlowrqty EHFND_TX_RD_GTM_LW Lower Limit Gen. Tox. Maternal
pctxgtmlowrqtytxt EHFND_TX_RD_GTM_L_C Lower Limit Gen. Tox. Maternal as Text
pctxgtmlowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxgtmuprqty EHFND_TX_RD_GTM_UP Upper Limit Gen. Tox. Maternal
pctxgtmuprqtytxt EHFND_TX_RD_GTM_U_C Upper Limit Gen. Tox. Maternal as Text
pctxgtmuprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxgtmuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxteratogenicvaltypephrsuuid EHFND_TX_RD_TRTG_VALTYPE_UUID Teratogenicity Value Type
pctxteratogeniclowrqty EHFND_TX_RD_TRTG_LW Lower Limit Teratogenicity
pctxteratogeniclowrqtytxt EHFND_TX_RD_TRTG_L_C Lower Limit Teratogenicity as Text
pctxteratogeniclowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxteratogenicuprqty EHFND_TX_RD_TRTG_VAL_UP Upper Limit Teratogenicity
pctxteratogenicuprqtytxt EHFND_TX_RD_TRTG_VAL_U_C Upper Limit Teratogenicity as Text
pctxteratogenicuprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxteratogenicuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxdevtoxtyvaltypephrsuuid EHFND_TX_RD_DT_VALTYPE_UUID Developmental Tox. Value Type
pctxdevtoxtylowrqty EHFND_TX_RD_DT_LW Lower Limit Dev. Tox.
pctxdevtoxtylowrqtytxt EHFND_TX_RD_DT_L_C Lower Limit Dev. Tox. as Text
pctxdevtoxtylowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxdevtoxtyuprqty EHFND_TX_RD_DT_UP Upper Limit Dev. Tox.
pctxdevtoxtyuprqtytxt EHFND_TX_RD_DT_U_C Upper Limit Dev. Tox. as Text
pctxdevtoxtyuprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxdevtoxtyuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxembryofetalvaltypephrsuuid EHFND_TX_RD_EFT_VALTYPE_UUID Embryo-Fetal Tox. Value Type
pctxembryofetallowrqty EHFND_TX_RD_EFT_LW Lower Limit Embryo-Fetal Tox.
pctxembryofetallowrqtytxt EHFND_TX_RD_EFT_L_C Lower Limit Embryo-Fetal Tox. as Text
pctxembryofetallowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxembryofetaluprqty EHFND_TX_RD_EFT_UP Upper Limit Embryo-Fetal Tox.
pctxembryofetaluprqtytxt EHFND_TX_RD_EFT_U_C Upper Limit Embryo-Fetal Tox. As Text
pctxembryofetaluprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxembryofetaluom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxsymptomphrsuuid EHFND_TX_SYMPTOM_UUID Symptoms
pctxtargetorganphrsuuid EHFND_TX_TRGT_ORGAN_UUID Target Organ
pctxrprdvdevresultphrsuuid EHFND_TX_RD_RESULT_UUID Result
pctxrprdvdevaddlstmntuuid EHFND_TX_RD_ADDL_STMNT_UUID Additional Statement
pctxnotetext EHFND_NOTE Comments
pcprptyrating EHFND_RATING_TYPE Use of Data
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_TXRD (
    MANDT,                           -- Client [MANDT]
    PCTXRPRDVDEVPRPTYUUID,           -- Property [EHFND_TX_RD_UUID]
    PCTXPRPTYUUID,                   -- Toxicological Property [EHFND_TX_UUID]
    PCTXTESTTYPEPHRSUUID,            -- Test Type [EHFND_TX_RD_TEST_TYPE_UUID]
    PCTXRPRDVDEVMETHODPHRSUUID,      -- Method [EHFND_TX_RD_METHOD_UUID]
    PCTXRPRDVDEVSPECIESPHRSUUID,     -- Species [EHFND_TX_RD_SPECIES_UUID]
    PCTXRPRDVDEVSTRAINPHRSUUID,      -- Strain [EHFND_TX_RD_STRAIN_UUID]
    PCTXSEXPHRSUUID,                 -- Sex [EHFND_TX_SEX_UUID]
    PCTXROUTEOFAPPLPHRSUUID,         -- Route of Application [EHFND_TX_APPL_ROUTE_UUID]
    PCTXRPRDVDEVDURN,                -- Duration of Treatment [EHFND_TX_DURATION]
    PCTXRPRDVDEVDURNASTXT,           -- Duration Of Treatment as Text [EHFND_TX_DURATION_CH]
    PCTXRPRDVDEVDURNUOM,             -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXFREQUENCYPHRSUUID,           -- Frequency of Treatment [EHFND_TX_FREQUENCY_UUID]
    PCTXGTMVALTYPEPHRSUUID,          -- Gen. Tox. Maternal Value Type [EHFND_TX_RD_GTM_VALTYPE_UUID]
    PCTXGTMLOWRQTY,                  -- Lower Limit Gen. Tox. Maternal [EHFND_TX_RD_GTM_LW]
    PCTXGTMLOWRQTYTXT,               -- Lower Limit Gen. Tox. Maternal as Text [EHFND_TX_RD_GTM_L_C]
    PCTXGTMLOWRQTYOPTR,              -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXGTMUPRQTY,                   -- Upper Limit Gen. Tox. Maternal [EHFND_TX_RD_GTM_UP]
    PCTXGTMUPRQTYTXT,                -- Upper Limit Gen. Tox. Maternal as Text [EHFND_TX_RD_GTM_U_C]
    PCTXGTMUPRQTYOPTR,               -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXGTMUOM,                      -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXTERATOGENICVALTYPEPHRSUUID,  -- Teratogenicity Value Type [EHFND_TX_RD_TRTG_VALTYPE_UUID]
    PCTXTERATOGENICLOWRQTY,          -- Lower Limit Teratogenicity [EHFND_TX_RD_TRTG_LW]
    PCTXTERATOGENICLOWRQTYTXT,       -- Lower Limit Teratogenicity as Text [EHFND_TX_RD_TRTG_L_C]
    PCTXTERATOGENICLOWRQTYOPTR,      -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXTERATOGENICUPRQTY,           -- Upper Limit Teratogenicity [EHFND_TX_RD_TRTG_VAL_UP]
    PCTXTERATOGENICUPRQTYTXT,        -- Upper Limit Teratogenicity as Text [EHFND_TX_RD_TRTG_VAL_U_C]
    PCTXTERATOGENICUPRQTYOPTR,       -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXTERATOGENICUOM,              -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXDEVTOXTYVALTYPEPHRSUUID,     -- Developmental Tox. Value Type [EHFND_TX_RD_DT_VALTYPE_UUID]
    PCTXDEVTOXTYLOWRQTY,             -- Lower Limit Dev. Tox. [EHFND_TX_RD_DT_LW]
    PCTXDEVTOXTYLOWRQTYTXT,          -- Lower Limit Dev. Tox. as Text [EHFND_TX_RD_DT_L_C]
    PCTXDEVTOXTYLOWRQTYOPTR,         -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXDEVTOXTYUPRQTY,              -- Upper Limit Dev. Tox. [EHFND_TX_RD_DT_UP]
    PCTXDEVTOXTYUPRQTYTXT,           -- Upper Limit Dev. Tox. as Text [EHFND_TX_RD_DT_U_C]
    PCTXDEVTOXTYUPRQTYOPTR,          -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXDEVTOXTYUOM,                 -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXEMBRYOFETALVALTYPEPHRSUUID,  -- Embryo-Fetal Tox. Value Type [EHFND_TX_RD_EFT_VALTYPE_UUID]
    PCTXEMBRYOFETALLOWRQTY,          -- Lower Limit Embryo-Fetal Tox. [EHFND_TX_RD_EFT_LW]
    PCTXEMBRYOFETALLOWRQTYTXT,       -- Lower Limit Embryo-Fetal Tox. as Text [EHFND_TX_RD_EFT_L_C]
    PCTXEMBRYOFETALLOWRQTYOPTR,      -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXEMBRYOFETALUPRQTY,           -- Upper Limit Embryo-Fetal Tox. [EHFND_TX_RD_EFT_UP]
    PCTXEMBRYOFETALUPRQTYTXT,        -- Upper Limit Embryo-Fetal Tox. As Text [EHFND_TX_RD_EFT_U_C]
    PCTXEMBRYOFETALUPRQTYOPTR,       -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXEMBRYOFETALUOM,              -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXSYMPTOMPHRSUUID,             -- Symptoms [EHFND_TX_SYMPTOM_UUID]
    PCTXTARGETORGANPHRSUUID,         -- Target Organ [EHFND_TX_TRGT_ORGAN_UUID]
    PCTXRPRDVDEVRESULTPHRSUUID,      -- Result [EHFND_TX_RD_RESULT_UUID]
    PCTXRPRDVDEVADDLSTMNTUUID,       -- Additional Statement [EHFND_TX_RD_ADDL_STMNT_UUID]
    PCTXNOTETEXT,                    -- Comments [EHFND_NOTE]
    PCPRPTYRATING,                   -- Use of Data [EHFND_RATING_TYPE]
    CREATIONUTCDATETIME,             -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                   -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,               -- User Name [UNAME]
    PRIMARY KEY (MANDT, PCTXRPRDVDEVPRPTYUUID)
);

Learn More