WTREE SAP table for – Version Management for Reclassification Trees

Here we would like to draw your attention to WTREE table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). WTREE is a SAP standard transparent table used for storing Version Management for Reclassification Trees related data in SAP. It comes under the package WWGR.

SAP WTREE table

Table WTREE technical data

TableWTREE
Data storingVersion Management for Reclassification Trees
ModuleLO
ComponentLO-MD
SAP PackageWWGR
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WTREE Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in WTREE table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • TLEVEL : Node level
    Its data type is N (Character String with Digits Only) with field length 2
  • INPUT6
    Its data type is C (Character String) with field length 1
  • INPUT7
    Its data type is C (Character String) with field length 1
  • INPUT8
    Its data type is C (Character String) with field length 1
  • INPUT9
    Its data type is C (Character String) with field length 1
  • NODISPLAY
    Its data type is C (Character String) with field length 1
  • MOREINFO
    Its data type is C (Character String) with field length 1
  • PROPFAW0
    Its data type is C (Character String) with field length 1
  • PROPFAW
    Its data type is C (Character String) with field length 1
  • PROPFAW1
    Its data type is C (Character String) with field length 1
  • LINK : Link ID
    Its data type is C (Character String) with field length 1
  • PROPFAW2
    Its data type is C (Character String) with field length 1
  • PROPFAW3
    Its data type is C (Character String) with field length 1
  • PROPFAW4
    Its data type is C (Character String) with field length 1
  • PROPFAW5
    Its data type is C (Character String) with field length 1
  • PROPFAW6
    Its data type is C (Character String) with field length 1
  • PROPFAW7
    Its data type is C (Character String) with field length 1
  • PROPFAW8
    Its data type is C (Character String) with field length 1
  • PROPFAW9
    Its data type is C (Character String) with field length 1
  • STYLE0
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE
    Its data type is N (Character String with Digits Only) with field length 2
  • KOMP
    Its data type is C (Character String) with field length 1
  • STYLE1
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE2
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE3
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE4
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE5
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE6
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE7
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE8
    Its data type is N (Character String with Digits Only) with field length 2
  • STYLE9
    Its data type is N (Character String with Digits Only) with field length 2
  • NODEICON
    Its data type is C (Character String) with field length 46
  • LEAF
    Its data type is C (Character String) with field length 1
  • LASTHTEXT
    Its data type is C (Character String) with field length 5
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TLOCK
    Its data type is C (Character String) with field length 1
  • PARENT : Internal: Node ID
    Its data type is N (Character String with Digits Only) with field length 6
  • CHILD : Internal: Node ID
    Its data type is N (Character String with Digits Only) with field length 6
  • NEXT_NODE
    Its data type is N (Character String with Digits Only) with field length 6
  • NLENGTH
    Its data type is N (Character String with Digits Only) with field length 2
  • KLART
    Its a key field. Its data type is C (Character String) with field length 3
  • COLOR : ABAP ONline Community: Character 64
    Its data type is N (Character String with Digits Only) with field length 1
  • INTENSIV
    Its data type is C (Character String) with field length 1
  • TEXT : Keyword for Searching in the ABAP Documentation
    Its data type is C (Character String) with field length 75
  • TLENGTH
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV
    Its data type is C (Character String) with field length 1
  • TPOS
    Its data type is C (Character String) with field length 3
  • KIND : ABAP: Type of selection
    Its data type is C (Character String) with field length 1
  • TEXT1
    Its data type is C (Character String) with field length 75
  • TLENGTH1
    Its data type is N (Character String with Digits Only) with field length 2
  • WTREE
    Its a key field. Its data type is C (Character String) with field length 6
  • TCOLOR1
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV1
    Its data type is C (Character String) with field length 1
  • TPOS1
    Its data type is C (Character String) with field length 3
  • KIND1
    Its data type is C (Character String) with field length 1
  • TEXT2
    Its data type is C (Character String) with field length 75
  • TLENGTH2
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR2
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV2
    Its data type is C (Character String) with field length 1
  • TPOS2
    Its data type is C (Character String) with field length 3
  • KIND2
    Its data type is C (Character String) with field length 1
  • WTREE_ID
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • TEXT3
    Its data type is C (Character String) with field length 75
  • TLENGTH3
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR3
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV3
    Its data type is C (Character String) with field length 1
  • TPOS3
    Its data type is C (Character String) with field length 3
  • KIND3
    Its data type is C (Character String) with field length 1
  • TEXT4
    Its data type is C (Character String) with field length 75
  • TLENGTH4
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR4
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV4
    Its data type is C (Character String) with field length 1
  • VONDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TPOS4
    Its data type is C (Character String) with field length 3
  • KIND4
    Its data type is C (Character String) with field length 1
  • TEXT5
    Its data type is C (Character String) with field length 75
  • TLENGTH5
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR5
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV5
    Its data type is C (Character String) with field length 1
  • TPOS5
    Its data type is C (Character String) with field length 3
  • KIND5
    Its data type is C (Character String) with field length 1
  • TEXT6
    Its data type is C (Character String) with field length 75
  • TLENGTH6
    Its data type is N (Character String with Digits Only) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is WTREE_NODE
  • TCOLOR6
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV6
    Its data type is C (Character String) with field length 1
  • TPOS6
    Its data type is C (Character String) with field length 3
  • KIND6
    Its data type is C (Character String) with field length 1
  • TEXT7
    Its data type is C (Character String) with field length 75
  • TLENGTH7
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR7
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV7
    Its data type is C (Character String) with field length 1
  • TPOS7
    Its data type is C (Character String) with field length 3
  • KIND7
    Its data type is C (Character String) with field length 1
  • ID : Demo hierarchy: Node ID
    Its data type is N (Character String with Digits Only) with field length 6
  • TEXT8
    Its data type is C (Character String) with field length 75
  • TLENGTH8
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR8
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV8
    Its data type is C (Character String) with field length 1
  • TPOS8
    Its data type is C (Character String) with field length 3
  • KIND8
    Its data type is C (Character String) with field length 1
  • TEXT9
    Its data type is C (Character String) with field length 75
  • TLENGTH9
    Its data type is N (Character String with Digits Only) with field length 2
  • TCOLOR9
    Its data type is N (Character String with Digits Only) with field length 1
  • TINTENSIV9
    Its data type is C (Character String) with field length 1
  • TYPE : Node type
    Its data type is C (Character String) with field length 4
  • TPOS9
    Its data type is C (Character String) with field length 3
  • KIND9
    Its data type is C (Character String) with field length 1
  • HIDE
    Its data type is C (Character String) with field length 75
  • FORCE_PLUS
    Its data type is C (Character String) with field length 1
  • HOTSPOT
    Its data type is C (Character String) with field length 1
  • HOTSPOT1
    Its data type is C (Character String) with field length 1
  • HOTSPOT2
    Its data type is C (Character String) with field length 1
  • HOTSPOT3
    Its data type is C (Character String) with field length 1
  • HOTSPOT4
    Its data type is C (Character String) with field length 1
  • HOTSPOT5
    Its data type is C (Character String) with field length 1
  • NAME : ABAP Program Name
    Its data type is C (Character String) with field length 30
  • HOTSPOT6
    Its data type is C (Character String) with field length 1
  • HOTSPOT7
    Its data type is C (Character String) with field length 1
  • HOTSPOT8
    Its data type is C (Character String) with field length 1
  • HOTSPOT9
    Its data type is C (Character String) with field length 1
  • INPUT
    Its data type is C (Character String) with field length 1
  • INPUT1
    Its data type is C (Character String) with field length 1
  • INPUT2
    Its data type is C (Character String) with field length 1
  • INPUT3
    Its data type is C (Character String) with field length 1
  • INPUT4
    Its data type is C (Character String) with field length 1
  • INPUT5
    Its data type is C (Character String) with field length 1