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

Here we would like to draw your attention to RSR_CACHE_VARSH 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). RSR_CACHE_VARSH is a SAP standard transp table used for storing Cache Directory: Storage for Variables and Hierarchies related data in SAP. It comes under the package RSR_CACHE.

SAP RSR_CACHE_VARSH table

Table RSR_CACHE_VARSH technical data

TableRSR_CACHE_VARSH
Data storingCache Directory: Storage for Variables and Hierarchies
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSR_CACHE
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

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

  • GENUNIID : Internal display of the report identifier
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • SERVERNAME : Application Server Instance
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • VH_LOG_ID : Logical ID
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • VH_HASH
    Its data type is RAW (Byte string) with field length 20
  • CREATE_STAMP : 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
  • SRDATE : Date with which texts, attributes and hierarchies are read
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CGID : Partitioning Group Regarding Cache
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CSID : ID for Constant Selection
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DATA_SIZE : Integer
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • VARSH_XSTRING
    Its data type is RSTR (Byte string of variable length – ABAP type XSTRING) with field length 0
  • DELETE_FLAG : Boolean
    Its data type is CHAR (Character String) with field length 1