SAP WTREE Version Management for Reclassification Trees Table
Overview
WTREE is a standard SAP S/4HANA table that stores Version Management for Reclassification Trees data. There are total 128 fields in the WTREE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WTREE belongs to Material Groups (LO-MD-MG) module and is located in the package IS-R merchandise categories (WWGR).
In addition, following links provide an overview of foreign key relationships, if any, that link WTREE to other SAP tables and standard CDS views available based on WTREE table in S/4HANA 2020.
Techincal Settings of WTREE
Below are technical details of the table WTREE
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of WTREE Fields
The following table gives you an overview of the fields available in WTREE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| KLART | Class Type | KLASSENART | TCLA | CHAR | 3 |
| WTREE | Change version of a reclassification tree | WTREE_D | CHAR | 6 | |
| WTREE_ID | Internal: Node ID | SEU_ID | NUMC | 6 | |
| VONDAT | Valid-From Date | VONDAT | DATS | 8 | |
| ID | Internal: Node ID | SEU_ID | NUMC | 6 | |
| TYPE | Node type | SEU_TYPE | CHAR | 4 | |
| NAME | Object name | SEU_NAME | CHAR | 30 | |
| TLEVEL | Node level | SEU_LEVEL | NUMC | 2 | |
| LINK | Link ID | SEU_LINK | CHAR | 1 | |
| KOMP | Internal: Compression ID | SEU_COMPR | CHAR | 1 | |
| LEAF | Internal: Page ID | SEU_LEAF | CHAR | 1 | |
| TLOCK | Internal: Selection ID | SEU_LOCK | CHAR | 1 | |
| PARENT | Internal: Node ID | SEU_ID | NUMC | 6 | |
| CHILD | Internal: Node ID | SEU_ID | NUMC | 6 | |
| NEXT_NODE | Internal: Node ID | SEU_ID | NUMC | 6 | |
| NLENGTH | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| COLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| INTENSIV | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TEXT | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT1 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH1 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR1 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV1 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS1 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND1 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT2 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH2 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR2 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV2 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS2 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND2 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT3 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH3 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR3 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV3 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS3 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND3 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT4 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH4 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR4 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV4 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS4 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND4 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT5 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH5 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR5 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV5 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS5 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND5 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT6 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH6 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR6 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV6 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS6 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND6 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT7 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH7 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR7 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV7 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS7 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND7 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT8 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH8 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR8 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV8 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS8 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND8 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| TEXT9 | Text/icon/symbol | SEU_TEXT | CHAR | 75 | |
| TLENGTH9 | Output length of a hierarchy node | SEU_NODELN | NUMC | 2 | |
| TCOLOR9 | Color display of a hierarchy node | SEU_COLOR | NUMC | 1 | |
| TINTENSIV9 | Intensity of display | SEU_INTENS | CHAR | 1 | |
| TPOS9 | Hierarchy display: Column position of a text | SEU_POS | CHAR | 3 | |
| KIND9 | Text type (Space = Text 'I' = 'Icon' 'S' = Symbol) | SEU_KIND | CHAR | 1 | |
| HIDE | Hide area of a hierarchy node | SEU_HIDE | CHAR | 75 | |
| FORCE_PLUS | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT1 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT2 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT3 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT4 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT5 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT6 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT7 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT8 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| HOTSPOT9 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT1 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT2 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT3 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT4 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT5 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT6 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT7 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT8 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| INPUT9 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| NODISPLAY | Flag: Nodes not displayed | NODISPLAY | CHAR | 1 | |
| MOREINFO | Flage: Additional information about nodes exists | MOREINFO | CHAR | 1 | |
| PROPFAW0 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW1 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW2 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW3 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW4 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW5 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW6 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW7 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW8 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| PROPFAW9 | Flag: Proportional font and automatic item width | PROPFAW | CHAR | 1 | |
| STYLE0 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE1 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE2 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE3 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE4 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE5 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE6 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE7 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE8 | Tree control style | CTLSTYLE | NUMC | 2 | |
| STYLE9 | Tree control style | CTLSTYLE | NUMC | 2 | |
| NODEICON | Tree Control: Icon / Image | TV_IMAGE | CHAR | 46 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WTREE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WTREE | KLART | : | TCLA |
| WTREE | MANDT | : | T000 |