TNODEE SAP (Definition of attributes of a node type) Table details
Dictionary Type: Table
Description: Definition of attributes of a node type
Description: Definition of attributes of a node type
Table field list including key, data, relationships and ABAP select examples
TNODEE is a standard SAP Table which is used to store Definition of attributes of a node type data and is available within R/3 SAP systems depending on the version and release level.
The TNODEE table consists of various fields, each holding specific information or linking keys about Definition of attributes of a node type data available in SAP. These include TEXT_POS (Node text item for a node type), STXT_RTYPE (Link type for obtaining text), LTXT_RTYPE (Link type for obtaining text), F1_RTYPE (Valid Reference Types in Structure Repository).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TNODEE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
NODE_TYPE | Valid Node Types in Structure Repository | HIER_NODET | CHAR | 4 | TNODEH | HIER_NODET | |||
TEXT_POS | Node text item for a node type | HIER_TXPOS | INT1 | 3 | HIER_COUNT | ||||
STXT_RTYPE | Link type for obtaining text | HIER_TXT_R | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
LTXT_RTYPE | Link type for obtaining text | HIER_TXT_R | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F1_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F1_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F1_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F1_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F1_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F2_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F2_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F2_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F2_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F2_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F3_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F3_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F3_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F3_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F3_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F4_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F4_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F4_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F4_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F4_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F5_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F5_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F5_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F5_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F5_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F6_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F6_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F6_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F6_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F6_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F7_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F7_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F7_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F7_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F7_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F8_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F8_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F8_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F8_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F8_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F9_RTYPE | Valid Reference Types in Structure Repository | HIER_RTYPE | CHAR | 4 | TRTYPEH | HIER_RTYPE | |||
F9_ICON | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
F9_HOTSPOT | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F9_FIX | Display options for output field in node type | HIER_ICON1 | CHAR | 1 | HIER_ICON1 | ||||
F9_REF_EX | Flag with values ' ' and 'X' | HIER_YESNO | CHAR | 1 | HIER_YESNO | ||||
F1_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F2_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F3_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F4_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F5_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F6_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F7_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F8_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F9_COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
F1_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F2_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F3_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F4_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F5_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F6_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F7_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F8_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F9_NODELN | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
F1_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F2_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F3_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F4_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F5_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F6_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F7_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F8_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F9_INTENS | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
F1_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F2_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F3_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F4_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F5_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F6_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F7_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F8_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
F9_POS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
ATR_COU | Use of country attribute | HIER_ATR01 | CHAR | 1 | HIER_YESNO | ||||
ATR_BRA | Use of the industry sector attribute | HIER_ATR02 | CHAR | 1 | HIER_YESNO |
Key field | Non-key field |
How do I retrieve data from SAP table TNODEE using ABAP code
The following ABAP code Example will allow you to do a basic selection on TNODEE to SELECT all data from the tableDATA: WA_TNODEE TYPE TNODEE.
SELECT SINGLE *
FROM TNODEE
INTO CORRESPONDING FIELDS OF WA_TNODEE
WHERE...
How to access SAP table TNODEE
Within an ECC or HANA version of SAP you can also view further information about TNODEE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects