SAP table WRF_APPL_SET (Hierarchy Control Table)

SAP table WRF_APPL_SET has 2 primary key fields being MANDT,APP_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_APPID
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
NUMBER_OF_HIER Maximum Number of Hierarchies That Can Be Created NUMC 3 0 WRF_ANZAHLHIER
FUNCTION_MODULE Function Module for Alternate Hierarchy Maintenance Dialog CHAR 30 0 TFDIR WRF_FUNCTION_MODULE
FLG_NODESTR_ONLY No Other Attribute Structure Allowed for Node CHAR 1 0 WRF_NODESTR_ONLY
FLG_OBJSTR_ONLY No Other Attribute Structure for Objects Allowed CHAR 1 0 WRF_OBJSTR_ONLY
FLG_NODENME_UNIQ Node Name Must Be Unique CHAR 1 0 WRF_NODENME_UNIQ
FLG_OBJNME_UNIQ Object Name Must Be Unique CHAR 1 0 WRF_OBJNME_UNIQ
FLG_ADD_EN_ONLY Objects Can Only Be Moved to End Nodes CHAR 1 0 WRF_ADD_EN_ONLY
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_CHANGE_DOC Write Change Document CHAR 1 0 WRF_CHNGE_DOC

WRF_APPL_SET foreign key relationships

Table Field Check Table Check Field
0 WRF_APPL_SET FUNCTION_MODULE TFDIR Function Module FUNCNAME
1 WRF_APPL_SET MANDT T000 Clients MANDT
0 WRF_APPL_SET NODE_STRUCT DD02L SAP Tables TABNAME
0 WRF_APPL_SET NODE_STRUCT DD02L SAP Tables AS4LOCAL
0 WRF_APPL_SET NODE_STRUCT DD02L SAP Tables AS4VERS
1 WRF_APPL_SET OBJ_STRUCT DD02L SAP Tables TABNAME
1 WRF_APPL_SET OBJ_STRUCT DD02L SAP Tables AS4LOCAL
1 WRF_APPL_SET OBJ_STRUCT DD02L SAP Tables AS4VERS