RSSAUTHHIER SAP table for – Definition of the Authorizations for Hierarchies

Here we would like to draw your attention to RSSAUTHHIER table in SAP. As we know it is being mainly used with the SAP BW-BEX (Business Explorer in BW) component which is coming under BW module (Business Warehouse). RSSAUTHHIER is a SAP standard transp table used for storing Definition of the Authorizations for Hierarchies related data in SAP. It comes under the package RSSBR.

SAP RSSAUTHHIER table

Table RSSAUTHHIER technical data

TableRSSAUTHHIER
Data storingDefinition of the Authorizations for Hierarchies
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSSBR
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP RSSAUTHHIER Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in RSSAUTHHIER table.

  • AUTHHIERUID : Unique ID for Authorization Definition for Hierarchies
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • HIESID : SID for Hierarchy ID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • HIEID : Internal hierarchy ID (unique ID)
    Its data type is CHAR (Character String) with field length 25
  • HIENM : Hierarchy name
    Its data type is CHAR (Character String) with field length 30
  • VERSION : Hierarchy version
    Its data type is CHAR (Character String) with field length 3
  • DATETO : Valid-to date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IOBJNM : InfoObject
    Its data type is CHAR (Character String) with field length 30
  • NODE : Dim: Field for a Characteristic Value Shorter Than 60 Char.
    Its data type is CHAR (Character String) with field length 60
  • NIOBJNM : InfoObject
    Its data type is CHAR (Character String) with field length 30
  • TLEVEL : Hierarchy Level
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • AUTHTYPE : Type of Authorization for a Hierarchy
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • COMPMODE : BW Reporting Authorizations: Hierarchy Validity Area
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • USERDEFAULT : BW Reporting Authorizations: Node Variables Default Value
    Its data type is CHAR (Character String) with field length 1
  • HASMULTIPLENODES : Boolean
    Its data type is CHAR (Character String) with field length 1