SAP WRF_HIER_ID_T Hierarchy Text Table

Overview

WRF_HIER_ID_T is a standard SAP S/4HANA table that stores Hierarchy Text data. There are total 5 fields in the WRF_HIER_ID_T 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_T 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_T to other SAP tables and standard CDS views available based on WRF_HIER_ID_T table in S/4HANA 2020.

Techincal Settings of WRF_HIER_ID_T

Below are technical details of the table WRF_HIER_ID_T

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of WRF_HIER_ID_T Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
APP_IDApplication IDWRF_APPIDWRF_APPL_SETNUMC2
HIER_IDHierarchy IDWRF_HIERIDWRF_HIER_IDCHAR2
SPRASLanguage KeySPRAST002LANG1
HIER_DESCHierarchy DescriptionWRF_HIERDESCCHAR40

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_T

Table NameFieldCardinalityCheck Table
WRF_HIER_ID_TAPP_ID:WRF_APPL_SET
WRF_HIER_ID_THIER_ID1: CNWRF_HIER_ID
WRF_HIER_ID_TMANDT:T000
WRF_HIER_ID_TSPRAS:T002

Other References