WRF_HIER_NODES SAP table for – Hierarchy Node

Here we would like to draw your attention to WRF_HIER_NODES 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). WRF_HIER_NODES is a SAP standard transparent table used for storing Hierarchy Node related data in SAP. It comes under the package WRF_GENERIC_HIERARCHY.

SAP WRF_HIER_NODES table

Table WRF_HIER_NODES technical data

TableWRF_HIER_NODES
Data storingHierarchy Node
ModuleLO
ComponentLO-MD
SAP PackageWRF_GENERIC_HIERARCHY
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WRF_HIER_NODES 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 WRF_HIER_NODES table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • MODIFIER
    Its data type is C (Character String) with field length 12
  • LOGSYS : Logical system
    Its data type is C (Character String) with field length 10
  • AUTH_GRP
    Its data type is C (Character String) with field length 4
  • FLAG_END_NODE
    Its data type is C (Character String) with field length 1
  • FLAG_CONT_USED
    Its data type is C (Character String) with field length 1
  • TIMESTAMP : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VALID_FROM : Valid From (Time Stamp)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VALID_TO : Valid To (Time Stamp)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • APP_ID
    Its a key field. Its data type is N (Character String with Digits Only) with field length 2
  • HIER_ID
    Its a key field. Its data type is C (Character String) with field length 2
  • NODE_ID : Unique ID – 32 characters
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • NODE_LEVEL
    Its data type is N (Character String with Digits Only) with field length 2
  • NODE_NAME
    Its data type is C (Character String) with field length 30
  • PARENT_NODE_ID : Unique ID – 32 characters
    Its data type is N (Character String with Digits Only) with field length 6
  • CREATOR : User Name
    Its data type is C (Character String) with field length 12
  • CREATE_DATE : System Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8