SAP WRF_HIER_OBJ Objects of a Hierarchy Table

Overview

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

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

Techincal Settings of WRF_HIER_OBJ

Below are technical details of the table WRF_HIER_OBJ

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

List of WRF_HIER_OBJ Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
APP_IDApplication IDWRF_APPIDWRF_APPL_SETNUMC2
HIER_IDHierarchy IDWRF_HIERIDWRF_HIER_IDCHAR2
NODE_IDNode IDWRF_NODEIDWRF_HIER_NODESNUMC6
OBJ_IDObject IDWRF_OBJIDNUMC6
OBJ_NAMEObject NameWRF_OBJNAMECHAR30
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC15
CREATORCreated ByWRF_CREATOR*CHAR12
CREATE_DATECreation DateWRF_CREATEDATEDATS8
MODIFIERLast Changed byWRF_MODIFIER*CHAR12
LOGSYSLogical SystemWRF_LOGSYSCHAR10
VALID_FROMValid FromWRF_VALID_FROMDATS8
VALID_TOValid ToWRF_VALID_TODATS8
FLAG_CONT_USEDAdditional Attributes for Nodes/ObjectsWRF_CON_USEDCHAR1

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_OBJ

Table NameFieldCardinalityCheck Table
WRF_HIER_OBJAPP_ID:WRF_APPL_SET
WRF_HIER_OBJHIER_ID:WRF_HIER_ID
WRF_HIER_OBJMANDT:T000
WRF_HIER_OBJNODE_ID:WRF_HIER_NODES

Other References