RSR_CACHE_LOG SAP table for – OLAP Cache Table for Saving Log Entries

Here we would like to draw your attention to RSR_CACHE_LOG 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_LOG is a SAP standard transp table used for storing OLAP Cache Table for Saving Log Entries related data in SAP. It comes under the package RSR_CACHE.

SAP RSR_CACHE_LOG table

Table RSR_CACHE_LOG technical data

TableRSR_CACHE_LOG
Data storingOLAP Cache Table for Saving Log Entries
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSR_CACHE
Delivery ClassL – Table for storing temporary data
ComponentSAP_BW
Table CategoryTRANSP

SAP RSR_CACHE_LOG 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_LOG table.

  • LOGGING_ID : UUID in character form
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • MESSAGE_NR : Cache NUMC Field of Length 9
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 9
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • TIMESTAMP : 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
  • HOST : Application Server
    Its data type is CHAR (Character String) with field length 32
  • MSGTYPE : Message Type
    Its data type is CHAR (Character String) with field length 1
  • CLASS : Object Type Name
    Its data type is CHAR (Character String) with field length 30
  • METHOD : Full Component Name
    Its data type is CHAR (Character String) with field length 61
  • MEM_ID : Memory ID
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • LOG_ID : GUID in ‘CHAR’ Format in Uppercase
    Its data type is CHAR (Character String) with field length 32
  • TEXT1 : Character Field of Length 40
    Its data type is CHAR (Character String) with field length 40
  • TEXT2 : Character Field of Length 40
    Its data type is CHAR (Character String) with field length 40
  • TEXT3 : Character Field of Length 40
    Its data type is CHAR (Character String) with field length 40
  • TEXT4 : Character Field of Length 40
    Its data type is CHAR (Character String) with field length 40
  • TEXT_STRING : Parameters for Service Call
    Its data type is STRG (Character String of Variable Length) with field length 0