RSR_CACHE_DAT_SH SAP table for – Cache: Data Store, Pattern for Shared Memory and Buffer

Here we would like to draw your attention to RSR_CACHE_DAT_SH 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_DAT_SH is a SAP standard transp table used for storing Cache: Data Store, Pattern for Shared Memory and Buffer related data in SAP. It comes under the package RSR_CACHE.

SAP RSR_CACHE_DAT_SH table

Table RSR_CACHE_DAT_SH technical data

TableRSR_CACHE_DAT_SH
Data storingCache: Data Store, Pattern for Shared Memory and Buffer
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSR_CACHE
Delivery ClassS – System table, data changes have the status of program changes
ComponentSAP_BW
Table CategoryTRANSP

SAP RSR_CACHE_DAT_SH 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_DAT_SH table.

  • RELID : Relation ID
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • GEN_FF_LOG_ID : Common Store of GENUNIID and Cache LOGID
    Its a key field. Its data type is CHAR (Character String) with field length 52
  • SRTF2 : Cluster sort field
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • FF_LOG_ID : Logical ID
    Its data type is RAW (Byte string) with field length 16
  • GENUNIID : Internal display of the report identifier
    Its data type is CHAR (Character String) with field length 25
  • DSTART : 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
  • DEND : 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
  • DDELTA : 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
  • DQFFID : OLAP: Query Cube Cache FF ID
    Its data type is RAW (Byte string) with field length 16
  • DATA_SIZE : Integer
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CLUSTR : BW: Cluster block
  • CLUSTD : Cluster data
    Its data type is LRAW (Long byte string, requires preceding INT2 field) with field length 3900