WTREE SAP (Version Management for Reclassification Trees) Table details
Dictionary Type: Table
Description: Version Management for Reclassification Trees
Description: Version Management for Reclassification Trees
Table field list including key, data, relationships and ABAP select examples
WTREE is a standard SAP Table which is used to store Version Management for Reclassification Trees data and is available within R/3 SAP systems depending on the version and release level.
The WTREE table consists of various fields, each holding specific information or linking keys about Version Management for Reclassification Trees data available in SAP. These include KLART (Class Type), WTREE (Change version of a reclassification tree), WTREE_ID (Internal: Node ID), VONDAT (Valid-From Date).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP WTREE 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KLART | Class Type | KLASSENART | CHAR | 3 | TCLA | KLASSENART | KAR | ||
WTREE | Change version of a reclassification tree | WTREE_D | CHAR | 6 | CHAR6 | ||||
WTREE_ID | Internal: Node ID | SEU_ID | NUMC | 6 | SEU_ID | ||||
VONDAT | Valid-From Date | VONDAT | DATS | 8 | DATUM | ||||
ID | Internal: Node ID | SEU_ID | NUMC | 6 | SEU_ID | ||||
TYPE | Node type | SEU_TYPE | CHAR | 4 | SEU_TYPE | ||||
NAME | Object name | SEU_NAME | CHAR | 30 | SEU_NAME | ||||
TLEVEL | Node level | SEU_LEVEL | NUMC | 2 | SEU_LEVEL | ||||
LINK | Link ID | SEU_LINK | CHAR | 1 | CHAR1 | ||||
KOMP | Internal: Compression ID | SEU_COMPR | CHAR | 1 | CHAR1 | ||||
LEAF | Internal: Page ID | SEU_LEAF | CHAR | 1 | CHAR1 | ||||
TLOCK | Internal: Selection ID | SEU_LOCK | CHAR | 1 | CHAR1 | ||||
PARENT | Internal: Node ID | SEU_ID | NUMC | 6 | SEU_ID | ||||
CHILD | Internal: Node ID | SEU_ID | NUMC | 6 | SEU_ID | ||||
NEXT_NODE | Internal: Node ID | SEU_ID | NUMC | 6 | SEU_ID | ||||
NLENGTH | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
INTENSIV | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TEXT | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT1 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH1 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR1 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV1 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS1 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND1 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT2 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH2 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR2 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV2 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS2 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND2 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT3 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH3 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR3 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV3 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS3 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND3 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT4 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH4 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR4 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV4 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS4 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND4 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT5 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH5 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR5 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV5 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS5 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND5 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT6 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH6 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR6 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV6 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS6 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND6 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT7 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH7 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR7 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV7 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS7 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND7 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT8 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH8 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR8 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV8 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS8 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND8 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
TEXT9 | Text/Icon/Symbol | SEU_TEXT | CHAR | 75 | SEU_TEXT | ||||
TLENGTH9 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | NUM2 | ||||
TCOLOR9 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | NUM1 | ||||
TINTENSIV9 | Intensity of display | SEU_INTENS | CHAR | 1 | CHAR1 | ||||
TPOS9 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | CHAR3 | ||||
KIND9 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | SEU_KIND | CHAR | 1 | CHAR1 | ||||
HIDE | Hide area of a hierarchy node | SEU_HIDE | CHAR | 75 | SEU_TEXT | ||||
FORCE_PLUS | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT1 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT2 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT3 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT4 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT5 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT6 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT7 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT8 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
HOTSPOT9 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT1 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT2 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT3 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT4 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT5 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT6 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT7 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT8 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INPUT9 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
NODISPLAY | Flag: Nodes not displayed | NODISPLAY | CHAR | 1 | CHAR1_X | ||||
MOREINFO | Flage: Additional information about nodes exists | MOREINFO | CHAR | 1 | CHAR1_X | ||||
PROPFAW0 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW1 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW2 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW3 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW4 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW5 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW6 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW7 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW8 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
PROPFAW9 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | CHAR1_X | ||||
STYLE0 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE1 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE2 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE3 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE4 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE5 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE6 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE7 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE8 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
STYLE9 | Tree control style | CTLSTYLE | NUMC | 2 | NUMC2 | ||||
NODEICON | Tree Control: Icon / Image | TV_IMAGE | CHAR | 46 | TV_IMAGE | ||||
LASTHTEXT | Text Field from STREEATTR | 0 | |||||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table WTREE using ABAP code
The following ABAP code Example will allow you to do a basic selection on WTREE to SELECT all data from the tableDATA: WA_WTREE TYPE WTREE.
SELECT SINGLE *
FROM WTREE
INTO CORRESPONDING FIELDS OF WA_WTREE
WHERE...
How to access SAP table WTREE
Within an ECC or HANA version of SAP you can also view further information about WTREE 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