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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PCTxSkinIrritationStudy | view | from | BASIC | Skin Irritation Study |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA