RSRHINTAB_OLAP SAP table for – (obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel

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

SAP RSRHINTAB_OLAP table

Table RSRHINTAB_OLAP technical data

TableRSRHINTAB_OLAP
Data storing(obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSR_HIER
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_BW
Table CategoryTRANSP

SAP RSRHINTAB_OLAP 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 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
  • LEAFFROM : Dim: Field for a Characteristic Value Shorter Than 60 Char.
    Its a key field. Its data type is CHAR (Character String) with field length 60
  • LEAFTO : Dim: Field for a Characteristic Value Shorter Than 60 Char.
    Its a key field. Its data type is CHAR (Character String) with field length 60
  • 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
  • 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