1. SAP Tutorial
  2. Business Warehouse

RSRHIEDIR_OLAP SAP table for – OLAP Relevant Information for the Hierarchies

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

SAP RSRHIEDIR_OLAP table

Table RSRHIEDIR_OLAP technical data

TableRSRHIEDIR_OLAP
Data storingOLAP Relevant Information for the Hierarchies
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSR_HIER
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP RSRHIEDIR_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 RSRHIEDIR_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
  • OBJVERS : Object version
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • HDATE : Key date for which the hierarchy structure is stored
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TMPJOIN : Hierarchy Version for “Temporal Join”
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DELETETIMESTMP : Time from which the entry can be deleted
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SVER : Version in Inclusion Table Key
    Its data type is CHAR (Character String) with field length 1
  • HIEID : Internal hierarchy ID (unique ID)
    Its data type is CHAR (Character String) with field length 25
  • CHABASNM : InfoObject
    Its data type is CHAR (Character String) with field length 30
  • ROOTSID : Master data ID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RESTLEAFSID : Master data ID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RESTTOPSID : Master data ID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SIDRANGE : Number Range Start for SIDs
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Technical attributes of the hierarchy
  • MAXTLEVEL : Level of a Hierarchy Node (as Integer)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • INTVLFL : Flag: Hierarchy contains intervals
    Its data type is CHAR (Character String) with field length 1
  • HIENDTFL : Hierarchy structure is time-dependent
    Its data type is CHAR (Character String) with field length 1
  • HIEUNIQUE : Uniqueness of a Hierarchy
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • READMODE : Hierarchy – Data selection on demand – Mode
    Its data type is CHAR (Character String) with field length 1
  • USERDEFREADMODE : Boolean
    Its data type is CHAR (Character String) with field length 1
  • NORESTNODES : Suppression of unassigned nodes
    Its data type is CHAR (Character String) with field length 1
  • FILTERSID : Filter Node (SID) for the Hierarchy
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • TIMESTMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ALEAFNODSP : Do Not Display Leaves for Inner-Nodes in the Query
    Its data type is CHAR (Character String) with field length 1
  • ALEAFNODCH : Display for Generated Leaves Cannot Be Changed
    Its data type is CHAR (Character String) with field length 1
  • VIRTUELL : Boolean
    Its data type is CHAR (Character String) with field length 1
  • DONTCOMPLETE : Do Not Complete Hierarchy (Remaining + Intervals)
    Its data type is CHAR (Character String) with field length 1
  • HIERCLNM : Name of the Hierarchy Read Class
    Its data type is CHAR (Character String) with field length 30
  • HIERCLPA : Parameter for Hierarhcy Read Class
    Its data type is CHAR (Character String) with field length 100
  • TIMESTMP_SOURCE : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CARDFIX : Exact Cardinality
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CARDREST : Exact Cardinality
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CARDINTVL : Exact Cardinality
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BIA_INDEX : Hierarchy Index in BWA
    Its data type is CHAR (Character String) with field length 1
  • VALID_FROM : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALID_TO : Valid-to date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

    • RSRHIEDIR_OLAP related tables

    • RSRHIEDIR_OLAP : OLAP Relevant Information for the Hierarchies
    • RSRHIEDIR_TIMDEP : Time Intervals with Time-Dependent Hierarchies
    • RSRHINTAB_OLAP : (obsolete) Hierarchy interval for the OLAP /XPRA -> 7.40 rel
    • RSRHIEDIR_SHORT : Structure for Appropriate Lock Object for Hierarchies
    • RSRHINTAB_OLAP_S : Hierarchy interval for the OLAP processor

    RSRHIEDIR_OLAP related transaction codes under SAP package RSR_HIER

    • RSRHIERARCHYVIRT : Maintain Virtual Time Hierarchies

    Related References

    Related Tutorials

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

    RSRHINTAB_OLAP table in SAP BW (Business Explorer in BW) module. This table is used for storing data of (obsolete) Hierarchy...

    RSRHINTAB_OLAP_S SAP table for – Hierarchy interval for the OLAP processor

    RSRHINTAB_OLAP_S table in SAP BW (Business Explorer in BW) module. This table is used for storing data of Hierarchy interval...

    RSR_TRACE_POS SAP table for – OLAP Trace

    RSR_TRACE_POS table in SAP BW (Business Explorer in BW) module. This table is used for storing data of OLAP Trace....

    RSR_CACHE_VARSHB SAP table for – Cache, BLOB Tables: Storage for Variables and Hierarchies

    RSR_CACHE_VARSHB table in SAP BW (Business Explorer in BW) module. This table is used for storing data of Cache, BLOB...

    RSR_CACHE_VARSH SAP table for – Cache Directory: Storage for Variables and Hierarchies

    RSR_CACHE_VARSH table in SAP BW (Business Explorer in BW) module. This table is used for storing data of Cache Directory:...

    RSSTATREQDETAILS SAP table for – Statistical information about Requests in a DTA

    RSSTATREQDETAILS table in SAP BW (Warehouse Management in BW) module. This table is used for storing data of Statistical information...

    SETHANA_STATUS SAP table for – Status of set hierarchies in HANA

    SETHANA_STATUS table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Status...

    «
    »