RSR_CACHE_ST_SHO SAP table for – Statistics for Cache Entries for Shared Objects

Here we would like to draw your attention to RSR_CACHE_ST_SHO 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_ST_SHO is a SAP standard transp table used for storing Statistics for Cache Entries for Shared Objects related data in SAP. It comes under the package RSR_CACHE.

SAP RSR_CACHE_ST_SHO table

Table RSR_CACHE_ST_SHO technical data

TableRSR_CACHE_ST_SHO
Data storingStatistics for Cache Entries for Shared Objects
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_ST_SHO 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_ST_SHO table.

  • GUID : GUID in ‘CHAR’ Format in Uppercase
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • MEM_ID : Memory ID
    Its a key field. Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • SYSID : Name of SAP System
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • HOST : Application Server
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • SERVERNAME : Application Server Instance
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • INSERT_TMSTMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • GENUNIID : Internal display of the report identifier
    Its data type is CHAR (Character String) with field length 25
  • DATA_SIZE : Integer
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : OLAP: Cache
  • CREATE_USR : User Name
    Its data type is CHAR (Character String) with field length 12
  • READ_USR : User Name
    Its data type is CHAR (Character String) with field length 12
  • UPDATE_USR : User Name
    Its data type is CHAR (Character String) with field length 12
  • CREATE_STMP : 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
  • READ_STMP : 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
  • UPDATE_STMP : 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
  • COMPUTE_TIME : UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 21
  • READ_CNT : Integer
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SWAP_CNT : Integer
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CHANGED : Boolean
    Its data type is CHAR (Character String) with field length 1