| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | KLART | Class Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | TCLA | KLASSENART | Allow NULL? |
| 3 | WTREE | Change version of a reclassification tree | nvarchar | 6 | 0 | CHAR | (N' ') | No | | WTREE_D | Allow NULL? |
| 4 | WTREE_ID | Internal: Node ID | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SEU_ID | Allow NULL? |
| 5 | VONDAT | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VONDAT | Allow NULL? |
| 6 | ID | Internal: Node ID | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | SEU_ID | Allow NULL? |
| 7 | TYPE | Node type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SEU_TYPE | Allow NULL? |
| 8 | NAME | Object name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SEU_NAME | Allow NULL? |
| 9 | TLEVEL | Node level | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_LEVEL | Allow NULL? |
| 10 | LINK | Link ID | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_LINK | Allow NULL? |
| 11 | KOMP | Internal: Compression ID | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_COMPR | Allow NULL? |
| 12 | LEAF | Internal: Page ID | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_LEAF | Allow NULL? |
| 13 | TLOCK | Internal: Selection ID | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_LOCK | Allow NULL? |
| 14 | PARENT | Internal: Node ID | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | SEU_ID | Allow NULL? |
| 15 | CHILD | Internal: Node ID | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | SEU_ID | Allow NULL? |
| 16 | NEXT_NODE | Internal: Node ID | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | SEU_ID | Allow NULL? |
| 17 | NLENGTH | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 18 | COLOR | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 19 | INTENSIV | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 20 | TEXT | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 21 | TLENGTH | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 22 | TCOLOR | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 23 | TINTENSIV | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 24 | TPOS | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 25 | KIND | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 26 | TEXT1 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 27 | TLENGTH1 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 28 | TCOLOR1 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 29 | TINTENSIV1 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 30 | TPOS1 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 31 | KIND1 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 32 | TEXT2 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 33 | TLENGTH2 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 34 | TCOLOR2 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 35 | TINTENSIV2 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 36 | TPOS2 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 37 | KIND2 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 38 | TEXT3 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 39 | TLENGTH3 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 40 | TCOLOR3 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 41 | TINTENSIV3 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 42 | TPOS3 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 43 | KIND3 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 44 | TEXT4 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 45 | TLENGTH4 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 46 | TCOLOR4 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 47 | TINTENSIV4 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 48 | TPOS4 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 49 | KIND4 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 50 | TEXT5 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 51 | TLENGTH5 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 52 | TCOLOR5 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 53 | TINTENSIV5 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 54 | TPOS5 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 55 | KIND5 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 56 | TEXT6 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 57 | TLENGTH6 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 58 | TCOLOR6 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 59 | TINTENSIV6 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 60 | TPOS6 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 61 | KIND6 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 62 | TEXT7 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 63 | TLENGTH7 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 64 | TCOLOR7 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 65 | TINTENSIV7 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 66 | TPOS7 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 67 | KIND7 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 68 | TEXT8 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 69 | TLENGTH8 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 70 | TCOLOR8 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 71 | TINTENSIV8 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 72 | TPOS8 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 73 | KIND8 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 74 | TEXT9 | Text/Icon/Symbol | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_TEXT | Allow NULL? |
| 75 | TLENGTH9 | Output length of a hierarchy node | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SEU_NODELN | Allow NULL? |
| 76 | TCOLOR9 | Color display of a hierarchy node | char | 1 | 0 | NUMC | (N'0') | Yes | | SEU_COLOR | Allow NULL? |
| 77 | TINTENSIV9 | Intensity of display | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_INTENS | Allow NULL? |
| 78 | TPOS9 | Hierarchy display: Column position of a text | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SEU_POS | Allow NULL? |
| 79 | KIND9 | Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) | char | 1 | 0 | CHAR | (N' ') | Yes | | SEU_KIND | Allow NULL? |
| 80 | HIDE | Hide area of a hierarchy node | nvarchar | 75 | 0 | CHAR | (N' ') | Yes | | SEU_HIDE | Allow NULL? |
| 81 | FORCE_PLUS | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 82 | HOTSPOT | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 83 | HOTSPOT1 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 84 | HOTSPOT2 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 85 | HOTSPOT3 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 86 | HOTSPOT4 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 87 | HOTSPOT5 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 88 | HOTSPOT6 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 89 | HOTSPOT7 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 90 | HOTSPOT8 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 91 | HOTSPOT9 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 92 | INPUT | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 93 | INPUT1 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 94 | INPUT2 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 95 | INPUT3 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 96 | INPUT4 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 97 | INPUT5 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 98 | INPUT6 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 99 | INPUT7 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 100 | INPUT8 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 101 | INPUT9 | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 102 | NODISPLAY | Flag: Nodes not displayed | char | 1 | 0 | CHAR | (N' ') | Yes | | NODISPLAY | Allow NULL? |
| 103 | MOREINFO | Flage: Additional information about nodes exists | char | 1 | 0 | CHAR | (N' ') | Yes | | MOREINFO | Allow NULL? |
| 104 | PROPFAW0 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 105 | PROPFAW | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 106 | PROPFAW1 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 107 | PROPFAW2 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 108 | PROPFAW3 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 109 | PROPFAW4 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 110 | PROPFAW5 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 111 | PROPFAW6 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 112 | PROPFAW7 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 113 | PROPFAW8 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 114 | PROPFAW9 | Flag: Proportional font and automatic item width | char | 1 | 0 | CHAR | (N' ') | Yes | | PROPFAW | Allow NULL? |
| 115 | STYLE0 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 116 | STYLE | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 117 | STYLE1 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 118 | STYLE2 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 119 | STYLE3 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 120 | STYLE4 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 121 | STYLE5 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 122 | STYLE6 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 123 | STYLE7 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 124 | STYLE8 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 125 | STYLE9 | Tree control style | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CTLSTYLE | Allow NULL? |
| 126 | NODEICON | Tree Control: Icon / Image | nvarchar | 46 | 0 | CHAR | (N' ') | Yes | | TV_IMAGE | Allow NULL? |
| 127 | LASTHTEXT | | nvarchar | 5 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 128 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 129 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |