SAP Table WRF_HIER_ID
Hierarchy Table
WRF_HIER_ID (Hierarchy Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WRF_HIER_ID to other SAP tables.
WRF_HIER_ID table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| APP_ID | Application ID | WRF_APPID | WRF_APPL_SET | NUMC | 2 | 0 | ||||||||
| HIER_ID | Hierarchy ID | WRF_HIERID | CHAR | 2 | 0 | |||||||||
| ROOT_ID | Root Node | WRF_ROOTID | NUMC | 6 | 0 | |||||||||
| NEXT_OBJECT_ID | Next Free Object ID | WRF_NEXT_OBJ_ID | NUMC | 6 | 0 | |||||||||
| NEXT_NODE_ID | Next Free Node ID | WRF_NEXT_NODE_ID | NUMC | 6 | 0 | |||||||||
| OBJ_REF | Reference Object | WRF_OBJ_REF | CHAR | 30 | 0 | |||||||||
| OBJ_STRUCT | Attribute Structure for Objects | WRF_OSTRUCT_REF | DD02L | CHAR | 30 | 0 | ||||||||
| NODE_STRUCT | Attribute Structure for Nodes | WRF_STRUCT_REF | DD02L | CHAR | 30 | 0 | ||||||||
| AUTH_GRP | Authorization Group | WRF_AUTHGRP | CHAR | 4 | 0 | |||||||||
| OBJ_DISPLAY_CONT | Display Objects in Hierarchy Tree | WRF_OBJ_DIS_CONT | CHAR | 1 | 0 |
Possible values
|
||||||||
| DISPLAY_MODE | Display Mode for Tree Display | WRF_DISPLAY_MODE | NUMC | 1 | 0 |
Possible values
|
||||||||
| FLG_OBJSTR_ONLY | No Other Attribute Structure for Objects Allowed | WRF_OBJSTR_ONLY | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLG_NODESTR_ONLY | No Other Attribute Structure Allowed for Node | WRF_NODESTR_ONLY | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLG_OBJNME_UNIQ | Object Name Must Be Unique | WRF_OBJNME_UNIQ | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLG_NODENME_UNIQ | Node Name Must Be Unique | WRF_NODENME_UNIQ | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLG_ADD_EN_ONLY | Objects Can Only Be Moved to End Nodes | WRF_ADD_EN_ONLY | CHAR | 1 | 0 |
Possible values
|
||||||||
| FLG_CHANGE_DOC | Write Change Document | WRF_CHNGE_DOC | CHAR | 1 | 0 |
Possible values
|
||||||||
WRF_HIER_ID foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WRF_HIER_ID | APP_ID | WRF_HIER_ID | APP_ID | WRF_APPL_SET | Hierarchy Control Table | APP_ID |
| WRF_HIER_ID | APP_ID | WRF_HIER_ID | MANDT | WRF_APPL_SET | Hierarchy Control Table | MANDT |
| WRF_HIER_ID | MANDT | WRF_HIER_ID | MANDT | T000 | Clients | MANDT |
| WRF_HIER_ID | NODE_STRUCT | * | DD02L | SAP Tables | AS4VERS | |
| WRF_HIER_ID | NODE_STRUCT | WRF_HIER_ID | NODE_STRUCT | DD02L | SAP Tables | TABNAME |
| WRF_HIER_ID | NODE_STRUCT | * | DD02L | SAP Tables | AS4LOCAL | |
| WRF_HIER_ID | OBJ_STRUCT | WRF_HIER_ID | OBJ_STRUCT | DD02L | SAP Tables | TABNAME |
| WRF_HIER_ID | OBJ_STRUCT | * | DD02L | SAP Tables | AS4LOCAL | |
| WRF_HIER_ID | OBJ_STRUCT | * | DD02L | SAP Tables | AS4VERS | |
