RSRHINTAB_OLAP_S SAP table for – Hierarchy interval for the OLAP processor

Here we would like to draw your attention to RSRHINTAB_OLAP_S 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). RSRHINTAB_OLAP_S is a SAP standard transp table used for storing Hierarchy interval for the OLAP processor related data in SAP. It comes under the package RSR_HIER.

SAP RSRHINTAB_OLAP_S table

Table RSRHINTAB_OLAP_S technical data

TableRSRHINTAB_OLAP_S
Data storingHierarchy interval for the OLAP processor
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSR_HIER
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_BW
Table CategoryTRANSP

SAP RSRHINTAB_OLAP_S 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 RSRHINTAB_OLAP_S table.

  • HIESID : SID for Hierarchy ID
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SVER : Version in Inclusion Table Key
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • PRED : Master data ID
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • LISTNO : Sequence of the inclusion relationships
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • INTVL_HASH : Hashvalue for Leaffrom and Leafto
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • LEAFFROM : Page of Hierarchy from
    Its data type is SSTR (Short Character String of Variable Length) with field length 1333
  • LEAFTO : Page of the Hierarchy to
    Its data type is SSTR (Short Character String of Variable Length) with field length 1333
  • TLEVEL : Level of a hierarchy node
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • FACTOR : Factor, with which the incl. name goes into the node
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10