UHDT_NTXT
Node Value Text
UHDT_NTXT is an SAP database table in S/4HANA. Node Value Text. It contains 6 fields. 35 CDS views read from this table.
CDS Views using this table (35)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAC_CDS_UH_ACTIVITYTYPENODE | view | left_outer | Universal Hier Activity Type Node | |
| FAC_CDS_UH_COMPANYCODENODE | view | left_outer | Universal Hierarchy Company Code Node | |
| FAC_CDS_UH_COSTCENTERNODE | view | left_outer | Universal Hierarchy Cost Center Node | |
| FAC_CDS_UH_FSVCONTRAITEM | view | left_outer | Universal Hierarchy FSV Contra Item | |
| FAC_CDS_UH_FSVNODE | view | left_outer | Universal Hierarchy FSV Node | |
| FAC_CDS_UH_FUNCNLAREANODE | view | left_outer | Universal Hierarchy Function Area Node | |
| FAC_CDS_UH_GENERICNODE | view | left_outer | Universal Hierarchy Generic Node | |
| FAC_CDS_UH_GLACCOUNTNODE | view | left_outer | Universal Hierarchy G/L Account Node | |
| fac_cds_uh_node | view | left_outer | Universal Hierarchy Node | |
| FAC_CDS_UH_PRFTCENTERNODE | view | left_outer | Universal Hierarchy Profit Center Node | |
| FAC_CDS_UH_REGIONNODE | view | left_outer | Universal Hierarchy Region Node | |
| FAC_CDS_UH_RULENODE | view | left_outer | Universal Hierarchy Company Code Node | |
| FAC_CDS_UH_SEGMENTNODE | view | left_outer | Universal Hierarchy Segment Node | |
| FAC_CDS_UH_STSTCLKEYFIGNODE | view | left_outer | Universal Hier Stat Key Figure Node | |
| fac_cds_ve_group_node | view | left_outer | Validation Group Node | |
| FIISAL_GR_ALTVGLACCTHIERDETL2 | view_entity | left_outer | Greece GLAccount global hierarchy detail | |
| FIISAL_GR_GLACCTHIERDETAIL2 | view_entity | left_outer | Greece GLAccount global hierarchy detail | |
| FINCS_UH_BUSINESSAREANODE | view | left_outer | Universal Hierarchy Business Area Node | |
| FINCS_UH_COSTCENTERNODE | view | left_outer | Universal Hierarchy Cost Center Node | |
| FINCS_UH_COUNTRYKEYNODE | view | left_outer | Universal Hierarchy Country/Region Node | |
| FINCS_UH_CUSTOMERGRPNODE | view | left_outer | Universal Hierarchy Customer Group Node | |
| FINCS_UH_CUSTOMERNODE | view | left_outer | Universal Hierarchy Customer Node | |
| FINCS_UH_FinTransTypeNODE | view | left_outer | Universal Hierarchy Transaction Type Node | |
| FINCS_UH_FSITEMNODE | view | left_outer | Universal Hierarchy Financial Statement Item Node | |
| FINCS_UH_FUNCTIONALAREANODE | view | left_outer | Universal Hierarchy Functional Area Node | |
| FINCS_UH_GLACCOUNTNODE | view | left_outer | Universal Hierarchy G/L Account Node | |
| FINCS_UH_PRODUCTNODE | view | left_outer | Universal Hierarchy Product Sold Node | |
| FINCS_UH_PROFITCENTERNODE | view | left_outer | Universal Hierarchy Profit Center Node | |
| FINCS_UH_PROJECTNODE | view | left_outer | Universal Hierarchy Project Node | |
| FINCS_UH_RITEMNODE | view | left_outer | Universal Hierarchy Reporting Item Node | |
| FINCS_UH_SALESORGNODE | view | left_outer | Universal Hierarchy Sales Organization Node | |
| FINCS_UH_SEGMENTNode | view | left_outer | Universal Hierarchy Segment Node | |
| FINCS_UH_SUPPLIERNODE | view | left_outer | Universal Hierarchy Supplier Node | |
| FINCS_UH_UNITNODE | view | left_outer | Universal Hierarchy - Consolidation Unit Node | |
| I_UniversalHierNodeText | view | from | BASIC | Universal Hierarchy Node Text |
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.
-- Node Value Text
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_NTXT (
CLIENT, -- Client [MANDT]
NODE_ID, -- Node ID [NODID]
LANG, -- Language [LANGU]
LVAL_TXT, -- Node Text [NLTXT]
HVAL_TXT, -- Node High Text [NHTXT]
VER_ID, -- Version ID [VRSID]
PRIMARY KEY (CLIENT, NODE_ID, LANG)
);
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