EHFNDV_TXRF

63 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PCTxRprdvFrtltyStudy view from BASIC Reprotoxicity Fert Study

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pctxrprdvfrtltyprptyuuid EHFND_TX_RF_UUID Property
pctxprptyuuid EHFND_TX_UUID Toxicological Property
pctxtesttypephrsuuid EHFND_TX_RF_TEST_TYPE_UUID Test Type
pctxrprdvfrtltymethodphrsuuid EHFND_TX_RF_METHOD_UUID Method
pctxrprdvfrtltyspeciesphrsuuid EHFND_TX_RF_SPECIES_UUID Species
pctxrprdvfrtltystrainphrsuuid EHFND_TX_RF_STRAIN_UUID Strain
pctxsexphrsuuid EHFND_TX_SEX_UUID Sex
pctxrouteofapplphrsuuid EHFND_TX_APPL_ROUTE_UUID Route of Application
pctxrprdvfrtltydurn EHFND_TX_DURATION Duration of Treatment
pctxrprdvfrtltydurnastxt EHFND_TX_DURATION_CH Duration Of Treatment as Text
pctxrprdvfrtltydurnuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxfrequencyphrsuuid EHFND_TX_FREQUENCY_UUID Frequency of Treatment
pctxgtpvaltypephrsuuid EHFND_TX_RF_GTP_VALTYPE_UUID Gen. Tox. Parent: Value Type
pctxgtplowrqty EHFND_TX_RF_GTP_LW Lower Limit Gen. Tox. Parent
pctxgtplowrqtytxt EHFND_TX_RF_GTP_L_C Lower Limit Gen. Tox. Parent as Text
pctxgtplowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxgtpuprqty EHFND_TX_RF_GTP_UP Upper Limit Gen. Tox. Parent
pctxgtpuprqtytxt EHFND_TX_RF_GTP_U_C Upper Limit Gen. Tox. Parent as Text
pctxgtpuprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxgtpuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxf1valtypephrsuuid EHFND_TX_RF_GTF1_VALTYPE_UUID Gen. Tox. F1: Value Type
pctxf1lowrqty EHFND_TX_RF_GTF1_LW Lower Limit Gen. Tox. F1
pctxf1lowrqtytxt EHFND_TX_RF_GTF1_L_C Lower Limit Gen. Tox. F1 as Text
pctxf1lowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxf1uprqty EHFND_TX_RF_GTF1_UP Upper Limit Gen. Tox. F1
pctxf1uprqtytxt EHFND_TX_RF_GTF1_U_C Upper Limit Gen. Tox. F1 as Text
pctxf1uprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxf1uom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxf2valtypephrsuuid EHFND_TX_RF_GTF2_VALTYPE_UUID Gen. Tox. F2: Value Type
pctxf2lowrqty EHFND_TX_RF_GTF2_LW Lower Limit Gen. Tox. F2
pctxf2lowrqtytxt EHFND_TX_RF_GTF2_L_C Lower Limit Gen. Tox. F2 as Text
pctxf2lowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxf2uprqty EHFND_TX_RF_GTF2_UP Upper Quantity Gen. Tox. F2
pctxf2uprqtytxt EHFND_TX_RF_GTF2_U_C Upper Quantity Gen. Tox. F2 as Text
pctxf2uprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxf2uom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxfrtltyvaluetypephrsuuid EHFND_TX_RF_FERT_VALTYPE_UUID Fertility: Value Type
pctxfrtltylowrqty EHFND_TX_RF_FERT_LW Lower Quantity Fertility
pctxfrtltylowrqtytxt EHFND_TX_RF_FERT_L_C Lower Quantity Fertility as Text
pctxfrtltylowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxfrtltyuprqty EHFND_TX_RF_FERT_UP Upper Quantity Fertility
pctxfrtltyuprqtytxt EHFND_TX_RF_FERT_U_C Upper Quantity Fertility as Text
pctxfrtltyuprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxfrtltyuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxeedevvaltypephrsuuid EHFND_TX_RF_EED_VALTYPE_UUID Early Embryo. Dev.: Value Type
pctxeedevlowrqty EHFND_TX_RF_EED_LW Lower Quantity Early Embryo Dev.
pctxeedevlowrqtytxt EHFND_TX_RF_EED_L_C Lower Quantity Early Embryo Dev. as Text
pctxeedevlowrqtyoptr EHFND_OPERATOR_LOWER_LIMIT Operator of Lower Limit
pctxeedevuprqty EHFND_TX_RF_EED_UP Upper Quantity Early Embryo Dev.
pctxeedevuprqtytxt EHFND_TX_RF_EED_U_C Upper Quantity Early Embryo Dev. as Text
pctxeedevuprqtyoptr EHFND_OPERATOR_UPPER_LIMIT Operator of Upper Limit
pctxeedevuom EHFND_UNIT_CODE_MEINS Unit of Measurement
pctxsymptomphrsuuid EHFND_TX_SYMPTOM_UUID Symptoms
pctxtargetorganphrsuuid EHFND_TX_TRGT_ORGAN_UUID Target Organ
pctxrprdvfrtltyresultphrsuuid EHFND_TX_RF_RESULT_UUID Result
pctxrprdvfrtltyaddlstmntuuid EHFND_TX_RF_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_TXRF (
    MANDT,                           -- Client [MANDT]
    PCTXRPRDVFRTLTYPRPTYUUID,        -- Property [EHFND_TX_RF_UUID]
    PCTXPRPTYUUID,                   -- Toxicological Property [EHFND_TX_UUID]
    PCTXTESTTYPEPHRSUUID,            -- Test Type [EHFND_TX_RF_TEST_TYPE_UUID]
    PCTXRPRDVFRTLTYMETHODPHRSUUID,   -- Method [EHFND_TX_RF_METHOD_UUID]
    PCTXRPRDVFRTLTYSPECIESPHRSUUID,  -- Species [EHFND_TX_RF_SPECIES_UUID]
    PCTXRPRDVFRTLTYSTRAINPHRSUUID,   -- Strain [EHFND_TX_RF_STRAIN_UUID]
    PCTXSEXPHRSUUID,                 -- Sex [EHFND_TX_SEX_UUID]
    PCTXROUTEOFAPPLPHRSUUID,         -- Route of Application [EHFND_TX_APPL_ROUTE_UUID]
    PCTXRPRDVFRTLTYDURN,             -- Duration of Treatment [EHFND_TX_DURATION]
    PCTXRPRDVFRTLTYDURNASTXT,        -- Duration Of Treatment as Text [EHFND_TX_DURATION_CH]
    PCTXRPRDVFRTLTYDURNUOM,          -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXFREQUENCYPHRSUUID,           -- Frequency of Treatment [EHFND_TX_FREQUENCY_UUID]
    PCTXGTPVALTYPEPHRSUUID,          -- Gen. Tox. Parent: Value Type [EHFND_TX_RF_GTP_VALTYPE_UUID]
    PCTXGTPLOWRQTY,                  -- Lower Limit Gen. Tox. Parent [EHFND_TX_RF_GTP_LW]
    PCTXGTPLOWRQTYTXT,               -- Lower Limit Gen. Tox. Parent as Text [EHFND_TX_RF_GTP_L_C]
    PCTXGTPLOWRQTYOPTR,              -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXGTPUPRQTY,                   -- Upper Limit Gen. Tox. Parent [EHFND_TX_RF_GTP_UP]
    PCTXGTPUPRQTYTXT,                -- Upper Limit Gen. Tox. Parent as Text [EHFND_TX_RF_GTP_U_C]
    PCTXGTPUPRQTYOPTR,               -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXGTPUOM,                      -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXF1VALTYPEPHRSUUID,           -- Gen. Tox. F1: Value Type [EHFND_TX_RF_GTF1_VALTYPE_UUID]
    PCTXF1LOWRQTY,                   -- Lower Limit Gen. Tox. F1 [EHFND_TX_RF_GTF1_LW]
    PCTXF1LOWRQTYTXT,                -- Lower Limit Gen. Tox. F1 as Text [EHFND_TX_RF_GTF1_L_C]
    PCTXF1LOWRQTYOPTR,               -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXF1UPRQTY,                    -- Upper Limit Gen. Tox. F1 [EHFND_TX_RF_GTF1_UP]
    PCTXF1UPRQTYTXT,                 -- Upper Limit Gen. Tox. F1 as Text [EHFND_TX_RF_GTF1_U_C]
    PCTXF1UPRQTYOPTR,                -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXF1UOM,                       -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXF2VALTYPEPHRSUUID,           -- Gen. Tox. F2: Value Type [EHFND_TX_RF_GTF2_VALTYPE_UUID]
    PCTXF2LOWRQTY,                   -- Lower Limit Gen. Tox. F2 [EHFND_TX_RF_GTF2_LW]
    PCTXF2LOWRQTYTXT,                -- Lower Limit Gen. Tox. F2 as Text [EHFND_TX_RF_GTF2_L_C]
    PCTXF2LOWRQTYOPTR,               -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXF2UPRQTY,                    -- Upper Quantity Gen. Tox. F2 [EHFND_TX_RF_GTF2_UP]
    PCTXF2UPRQTYTXT,                 -- Upper Quantity Gen. Tox. F2 as Text [EHFND_TX_RF_GTF2_U_C]
    PCTXF2UPRQTYOPTR,                -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXF2UOM,                       -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXFRTLTYVALUETYPEPHRSUUID,     -- Fertility: Value Type [EHFND_TX_RF_FERT_VALTYPE_UUID]
    PCTXFRTLTYLOWRQTY,               -- Lower Quantity Fertility [EHFND_TX_RF_FERT_LW]
    PCTXFRTLTYLOWRQTYTXT,            -- Lower Quantity Fertility as Text [EHFND_TX_RF_FERT_L_C]
    PCTXFRTLTYLOWRQTYOPTR,           -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXFRTLTYUPRQTY,                -- Upper Quantity Fertility [EHFND_TX_RF_FERT_UP]
    PCTXFRTLTYUPRQTYTXT,             -- Upper Quantity Fertility as Text [EHFND_TX_RF_FERT_U_C]
    PCTXFRTLTYUPRQTYOPTR,            -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXFRTLTYUOM,                   -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXEEDEVVALTYPEPHRSUUID,        -- Early Embryo. Dev.: Value Type [EHFND_TX_RF_EED_VALTYPE_UUID]
    PCTXEEDEVLOWRQTY,                -- Lower Quantity Early Embryo Dev. [EHFND_TX_RF_EED_LW]
    PCTXEEDEVLOWRQTYTXT,             -- Lower Quantity Early Embryo Dev. as Text [EHFND_TX_RF_EED_L_C]
    PCTXEEDEVLOWRQTYOPTR,            -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
    PCTXEEDEVUPRQTY,                 -- Upper Quantity Early Embryo Dev. [EHFND_TX_RF_EED_UP]
    PCTXEEDEVUPRQTYTXT,              -- Upper Quantity Early Embryo Dev. as Text [EHFND_TX_RF_EED_U_C]
    PCTXEEDEVUPRQTYOPTR,             -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
    PCTXEEDEVUOM,                    -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
    PCTXSYMPTOMPHRSUUID,             -- Symptoms [EHFND_TX_SYMPTOM_UUID]
    PCTXTARGETORGANPHRSUUID,         -- Target Organ [EHFND_TX_TRGT_ORGAN_UUID]
    PCTXRPRDVFRTLTYRESULTPHRSUUID,   -- Result [EHFND_TX_RF_RESULT_UUID]
    PCTXRPRDVFRTLTYADDLSTMNTUUID,    -- Additional Statement [EHFND_TX_RF_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, PCTXRPRDVFRTLTYPRPTYUUID)
);

Learn More