EHFNDD_STAR
Stability And Reactivity Root
EHFNDD_STAR is an SAP database table in S/4HANA. Stability And Reactivity Root. It contains 25 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PCStRct | view_entity | from | BASIC | Stability and Reactivity |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | pcstrctuuid | EHFND_STAR_UUID | Stability Reactivity | |||
| creationutcdatetime | ABP_CREATION_TSTMPL | Created On | ||||
| createdbyuser | ABP_CREATION_USER | Created By | ||||
| lastchangeutcdatetime | ABP_LASTCHANGE_TSTMPL | Changed On | ||||
| lastchangedbyuser | ABP_LASTCHANGE_USER | Changed By | ||||
| chmlcmplncinfouuid | EHFND_CCI_UUID | Chemical Compliance Information | ||||
| pcprptyprocgsts | EHFND_PROPERTY_STATUS | Processing Status | ||||
| pcprptyreleasedby | EHFND_PROPERTY_RELEASED_BY | Released By | ||||
| validitystartdatetime | EHFND_VALID_FROM_TSTMP | Valid From | ||||
| validityenddatetime | EHFND_VALID_TO_TSTMP | Valid To | ||||
| pcstrctreactivitynote | EHFND_STAR_NOTE_REACTIVITY | Notes | ||||
| pcstrctchmlstabilitynote | EHFND_STAR_NOTE_CHMLSTABILITY | Notes | ||||
| pcstrctconditionstoavoidnote | EHFND_STAR_NOTE_CONDTOAVOID | Notes | ||||
| pcstrcttemptoavoidlowrlmtoptr | EHFND_OPERATOR_LOWER_LIMIT | Operator of Lower Limit | ||||
| pcstrcttemptoavoidlowrlmtqty | EHFND_STAR_TEMP_QTY | Temperature to Avoid | ||||
| pcstrcttemptoavdlowrlmtqtyval | EHFND_TEMP_LOWER_QTY_CH | Temperature to Avoid: Lower Limit Tx | ||||
| pcstrcttemptoavoiduprlmtoptr | EHFND_OPERATOR_UPPER_LIMIT | Operator of Upper Limit | ||||
| pcstrcttemptoavoiduprlmtqty | EHFND_STAR_TEMP_QTY | Temperature to Avoid | ||||
| pcstrcttemptoavoiduprlmtqtyval | EHFND_TEMP_UPPER_QTY_CH | Temperature to Avoid: Upper Limit Tx | ||||
| pcstrcttemptoavoidunit | EHFND_UNIT_CODE_MEINS | Unit of Measurement | ||||
| pcstrcthzrctnsnote | EHFND_STAR_NOTE_HZRCTNS | Notes | ||||
| pcstrctincompatiblematlsnote | EHFND_STAR_NOTE_INCOMPATMATLS | Notes | ||||
| pcstrcthzdeprdsnote | EHFND_STAR_NOTE_HZDEPRDS | Notes | ||||
| pcstrcthzdeprdsnodtarsnuuid | EHFND_STAR_PH_HAZDEC_ND_UUID | No Data Reason |
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.
-- Stability And Reactivity Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_STAR (
CLIENT, -- Client [MANDT]
PCSTRCTUUID, -- Stability Reactivity [EHFND_STAR_UUID]
CREATIONUTCDATETIME, -- Created On [ABP_CREATION_TSTMPL]
CREATEDBYUSER, -- Created By [ABP_CREATION_USER]
LASTCHANGEUTCDATETIME, -- Changed On [ABP_LASTCHANGE_TSTMPL]
LASTCHANGEDBYUSER, -- Changed By [ABP_LASTCHANGE_USER]
CHMLCMPLNCINFOUUID, -- Chemical Compliance Information [EHFND_CCI_UUID]
PCPRPTYPROCGSTS, -- Processing Status [EHFND_PROPERTY_STATUS]
PCPRPTYRELEASEDBY, -- Released By [EHFND_PROPERTY_RELEASED_BY]
VALIDITYSTARTDATETIME, -- Valid From [EHFND_VALID_FROM_TSTMP]
VALIDITYENDDATETIME, -- Valid To [EHFND_VALID_TO_TSTMP]
PCSTRCTREACTIVITYNOTE, -- Notes [EHFND_STAR_NOTE_REACTIVITY]
PCSTRCTCHMLSTABILITYNOTE, -- Notes [EHFND_STAR_NOTE_CHMLSTABILITY]
PCSTRCTCONDITIONSTOAVOIDNOTE, -- Notes [EHFND_STAR_NOTE_CONDTOAVOID]
PCSTRCTTEMPTOAVOIDLOWRLMTOPTR, -- Operator of Lower Limit [EHFND_OPERATOR_LOWER_LIMIT]
PCSTRCTTEMPTOAVOIDLOWRLMTQTY, -- Temperature to Avoid [EHFND_STAR_TEMP_QTY]
PCSTRCTTEMPTOAVDLOWRLMTQTYVAL, -- Temperature to Avoid: Lower Limit Tx [EHFND_TEMP_LOWER_QTY_CH]
PCSTRCTTEMPTOAVOIDUPRLMTOPTR, -- Operator of Upper Limit [EHFND_OPERATOR_UPPER_LIMIT]
PCSTRCTTEMPTOAVOIDUPRLMTQTY, -- Temperature to Avoid [EHFND_STAR_TEMP_QTY]
PCSTRCTTEMPTOAVOIDUPRLMTQTYVAL, -- Temperature to Avoid: Upper Limit Tx [EHFND_TEMP_UPPER_QTY_CH]
PCSTRCTTEMPTOAVOIDUNIT, -- Unit of Measurement [EHFND_UNIT_CODE_MEINS]
PCSTRCTHZRCTNSNOTE, -- Notes [EHFND_STAR_NOTE_HZRCTNS]
PCSTRCTINCOMPATIBLEMATLSNOTE, -- Notes [EHFND_STAR_NOTE_INCOMPATMATLS]
PCSTRCTHZDEPRDSNOTE, -- Notes [EHFND_STAR_NOTE_HZDEPRDS]
PCSTRCTHZDEPRDSNODTARSNUUID, -- No Data Reason [EHFND_STAR_PH_HAZDEC_ND_UUID]
PRIMARY KEY (CLIENT, PCSTRCTUUID)
);
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