SAP WRF_APPL_SET Hierarchy Control Table Table

Overview

WRF_APPL_SET is a standard SAP S/4HANA table that stores Hierarchy Control Table data. There are total 15 fields in the WRF_APPL_SET table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WRF_APPL_SET 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_APPL_SET to other SAP tables and standard CDS views available based on WRF_APPL_SET table in S/4HANA 2020.

Techincal Settings of WRF_APPL_SET

Below are technical details of the table WRF_APPL_SET

  • Buffering switched on
  • Full table is passed to buffer
  • Storage type is Column Store

List of WRF_APPL_SET Fields

The following table gives you an overview of the fields available in WRF_APPL_SET

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
APP_IDApplication IDWRF_APPIDNUMC2
OBJ_STRUCTAttribute Structure for ObjectsWRF_OSTRUCT_REFDD02LCHAR30
NODE_STRUCTAttribute Structure for NodesWRF_STRUCT_REFDD02LCHAR30
AUTH_GRPAuthorization GroupWRF_AUTHGRPCHAR4
NUMBER_OF_HIERMaximum Number of Hierarchies That Can Be CreatedWRF_ANZAHLHIERNUMC3
FUNCTION_MODULEFunction Module for Alternate Hierarchy Maintenance DialogWRF_FUNCTION_MODULETFDIRCHAR30
FLG_NODESTR_ONLYNo Other Attribute Structure Allowed for NodeWRF_NODESTR_ONLYCHAR1
FLG_OBJSTR_ONLYNo Other Attribute Structure for Objects AllowedWRF_OBJSTR_ONLYCHAR1
FLG_NODENME_UNIQNode Name Must Be UniqueWRF_NODENME_UNIQCHAR1
FLG_OBJNME_UNIQObject Name Must Be UniqueWRF_OBJNME_UNIQCHAR1
FLG_ADD_EN_ONLYObjects Can Only Be Moved to End NodesWRF_ADD_EN_ONLYCHAR1
OBJ_DISPLAY_CONTDisplay Objects in Hierarchy TreeWRF_OBJ_DIS_CONTCHAR1
DISPLAY_MODEDisplay Mode for Tree DisplayWRF_DISPLAY_MODENUMC1
FLG_CHANGE_DOCWrite Change DocumentWRF_CHNGE_DOCCHAR1

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_APPL_SET

Table NameFieldCardinalityCheck Table
WRF_APPL_SETFUNCTION_MODULE:TFDIR
WRF_APPL_SETMANDT:T000
WRF_APPL_SETNODE_STRUCT:DD02L
WRF_APPL_SETOBJ_STRUCT:DD02L

Other References