SAP WRF_HIER_ID Hierarchy Table Table
Overview
WRF_HIER_ID is a standard SAP S/4HANA table that stores Hierarchy Table data. There are total 18 fields in the WRF_HIER_ID table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_HIER_ID 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_ID to other SAP tables and standard CDS views available based on WRF_HIER_ID table in S/4HANA 2020.
Techincal Settings of WRF_HIER_ID
Below are technical details of the table WRF_HIER_ID
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_HIER_ID Fields
The following table gives you an overview of the fields available in WRF_HIER_ID
| 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 | CHAR | 2 | |
| ROOT_ID | Root Node | WRF_ROOTID | * | NUMC | 6 |
| NEXT_OBJECT_ID | Next Free Object ID | WRF_NEXT_OBJ_ID | * | NUMC | 6 |
| NEXT_NODE_ID | Next Free Node ID | WRF_NEXT_NODE_ID | * | NUMC | 6 |
| OBJ_REF | Reference Object | WRF_OBJ_REF | CHAR | 30 | |
| OBJ_STRUCT | Attribute Structure for Objects | WRF_OSTRUCT_REF | DD02L | CHAR | 30 |
| NODE_STRUCT | Attribute Structure for Nodes | WRF_STRUCT_REF | DD02L | CHAR | 30 |
| AUTH_GRP | Authorization Group | WRF_AUTHGRP | CHAR | 4 | |
| OBJ_DISPLAY_CONT | Display Objects in Hierarchy Tree | WRF_OBJ_DIS_CONT | CHAR | 1 | |
| DISPLAY_MODE | Display Mode for Tree Display | WRF_DISPLAY_MODE | NUMC | 1 | |
| FLG_OBJSTR_ONLY | No Other Attribute Structure for Objects Allowed | WRF_OBJSTR_ONLY | CHAR | 1 | |
| FLG_NODESTR_ONLY | No Other Attribute Structure Allowed for Node | WRF_NODESTR_ONLY | CHAR | 1 | |
| FLG_OBJNME_UNIQ | Object Name Must Be Unique | WRF_OBJNME_UNIQ | CHAR | 1 | |
| FLG_NODENME_UNIQ | Node Name Must Be Unique | WRF_NODENME_UNIQ | CHAR | 1 | |
| FLG_ADD_EN_ONLY | Objects Can Only Be Moved to End Nodes | WRF_ADD_EN_ONLY | CHAR | 1 | |
| FLG_CHANGE_DOC | Write Change Document | WRF_CHNGE_DOC | CHAR | 1 |
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_ID
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_HIER_ID | APP_ID | : | WRF_APPL_SET |
| WRF_HIER_ID | MANDT | : | T000 |
| WRF_HIER_ID | NODE_STRUCT | : | DD02L |
| WRF_HIER_ID | OBJ_STRUCT | : | DD02L |