RSR_CACHE_QUERY SAP table for – Cache: Storage for Query and Time of Creation

Here we would like to draw your attention to RSR_CACHE_QUERY 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_QUERY is a SAP standard transp table used for storing Cache: Storage for Query and Time of Creation related data in SAP. It comes under the package RSR_CACHE.

SAP RSR_CACHE_QUERY table

Table RSR_CACHE_QUERY technical data

TableRSR_CACHE_QUERY
Data storingCache: Storage for Query and Time of Creation
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_QUERY 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_QUERY table.

  • GENUNIID : Internal display of the report identifier
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • 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
  • .INCLUDE : Cache settings for query
  • COMPR_THRESH : Cache Compression Threshold
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 20
  • COMPR_SIZE : Cache Compression Size
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • COMPR_DYNAMIC : Cache Compression Dynamic
    Its data type is CHAR (Character String) with field length 1