SAP table WRF_HIER_ID (Hierarchy Table)

SAP table WRF_HIER_ID has 3 primary key fields being MANDT,APP_ID,HIER_ID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
APP_ID Application ID NUMC 2 0 WRF_APPL_SET WRF_APPID
HIER_ID Hierarchy ID CHAR 2 0 WRF_HIERID
ROOT_ID Root Node NUMC 6 0 * WRF_ROOTID
NEXT_OBJECT_ID Next Free Object ID NUMC 6 0 * WRF_NEXT_OBJ_ID
NEXT_NODE_ID Next Free Node ID NUMC 6 0 * WRF_NEXT_NODE_ID
OBJ_REF Reference Object CHAR 30 0 WRF_OBJ_REF
OBJ_STRUCT Attribute Structure for Objects CHAR 30 0 DD02L WRF_OSTRUCT_REF
NODE_STRUCT Attribute Structure for Nodes CHAR 30 0 DD02L WRF_STRUCT_REF
AUTH_GRP Authorization Group CHAR 4 0 WRF_AUTHGRP
OBJ_DISPLAY_CONT Display Objects in Hierarchy Tree CHAR 1 0 WRF_OBJ_DIS_CONT
DISPLAY_MODE Display Mode for Tree Display NUMC 1 0 WRF_DISPLAY_MODE
0 Simple Tree Model
1 Column Tree Model
2 List Tree Model
FLG_OBJSTR_ONLY No Other Attribute Structure for Objects Allowed CHAR 1 0 WRF_OBJSTR_ONLY
FLG_NODESTR_ONLY No Other Attribute Structure Allowed for Node CHAR 1 0 WRF_NODESTR_ONLY
FLG_OBJNME_UNIQ Object Name Must Be Unique CHAR 1 0 WRF_OBJNME_UNIQ
FLG_NODENME_UNIQ Node Name Must Be Unique CHAR 1 0 WRF_NODENME_UNIQ
FLG_ADD_EN_ONLY Objects Can Only Be Moved to End Nodes CHAR 1 0 WRF_ADD_EN_ONLY
FLG_CHANGE_DOC Write Change Document CHAR 1 0 WRF_CHNGE_DOC

WRF_HIER_ID foreign key relationships

Table Field Check Table Check Field
0 WRF_HIER_ID APP_ID WRF_APPL_SET Hierarchy Control Table MANDT
0 WRF_HIER_ID APP_ID WRF_APPL_SET Hierarchy Control Table APP_ID
1 WRF_HIER_ID MANDT T000 Clients MANDT
0 WRF_HIER_ID NODE_STRUCT DD02L SAP Tables TABNAME
0 WRF_HIER_ID NODE_STRUCT DD02L SAP Tables AS4LOCAL
0 WRF_HIER_ID NODE_STRUCT DD02L SAP Tables AS4VERS
1 WRF_HIER_ID OBJ_STRUCT DD02L SAP Tables TABNAME
1 WRF_HIER_ID OBJ_STRUCT DD02L SAP Tables AS4LOCAL
1 WRF_HIER_ID OBJ_STRUCT DD02L SAP Tables AS4VERS