SAP WRF_HIER_NODES Hierarchy Node Table
Overview
WRF_HIER_NODES is a standard SAP S/4HANA table that stores Hierarchy Node data. There are total 17 fields in the WRF_HIER_NODES table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_HIER_NODES belongs to Merchandise Categories (LO-RFM-MD-MC) module and is located in the package Generic Hierarchy (WRF_GENERIC_HIERARCHY).
In addition, following links provide an overview of foreign key relationships, if any, that link WRF_HIER_NODES to other SAP tables and standard CDS views available based on WRF_HIER_NODES table in S/4HANA 2020.
Techincal Settings of WRF_HIER_NODES
Below are technical details of the table WRF_HIER_NODES
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_HIER_NODES Fields
The following table gives you an overview of the fields available in WRF_HIER_NODES
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| APP_ID | Application ID | WRF_APPID | WRF_APPL_SET | NUMC | 2 |
| HIER_ID | Hierarchy ID | WRF_HIERID | WRF_HIER_ID | CHAR | 2 |
| NODE_ID | Node ID | WRF_NODEID | NUMC | 6 | |
| NODE_LEVEL | Path Depth of Node | WRF_LEVEL | NUMC | 2 | |
| NODE_NAME | Node Name | WRF_NODENAME | CHAR | 30 | |
| PARENT_NODE_ID | Parent Node ID | WRF_PARENT | * | NUMC | 6 |
| CREATOR | Created By | WRF_CREATOR | * | CHAR | 12 |
| CREATE_DATE | Creation Date | WRF_CREATEDATE | DATS | 8 | |
| MODIFIER | Last Changed by | WRF_MODIFIER | * | CHAR | 12 |
| LOGSYS | Logical System | WRF_LOGSYS | CHAR | 10 | |
| AUTH_GRP | Authorization Group | WRF_AUTHGRP | CHAR | 4 | |
| FLAG_END_NODE | Flag: End Node | WRF_FLAG_EN | CHAR | 1 | |
| FLAG_CONT_USED | Additional Attributes for Nodes/Objects | WRF_CON_USED | CHAR | 1 | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| VALID_FROM | Valid From | WRF_VALID_FROM | DATS | 8 | |
| VALID_TO | Valid To | WRF_VALID_TO | 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 WRF_HIER_NODES
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_HIER_NODES | APP_ID | : | WRF_APPL_SET |
| WRF_HIER_NODES | HIER_ID | : | WRF_HIER_ID |
| WRF_HIER_NODES | MANDT | : | T000 |