RSRREPDIR SAP table for – Directory of all reports

Here we would like to draw your attention to RSRREPDIR 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). RSRREPDIR is a SAP standard transp table used for storing Directory of all reports related data in SAP. It comes under the package RSROA_SHELL.

SAP RSRREPDIR table

Table RSRREPDIR technical data

TableRSRREPDIR
Data storingDirectory of all reports
ModuleBW
Sub ModuleBW-BEX-OT
SAP PackageRSROA_SHELL
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_BW
Table CategoryTRANSP

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

  • COMPUID : UUID in compressed form
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • OBJVERS : Object version
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • INFOCUBE : InfoCube
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • GENUNIID : Internal display of the report identifier
    Its data type is CHAR (Character String) with field length 25
  • COMPTYPE : Type of a reporting component
    Its data type is CHAR (Character String) with field length 3
  • COMPID : Name (ID) of a reporting component
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Processor attributes of a reporting component
  • RFCSUPPORT : Report suuports access using OLAP API
    Its data type is CHAR (Character String) with field length 1
  • OBJSTAT : Object Status
    Its data type is CHAR (Character String) with field length 3
  • SMODE : Special reports
    Its data type is CHAR (Character String) with field length 1
  • READMODE : Read Mode
    Its data type is CHAR (Character String) with field length 1
  • NOAGGRFL : Flag: Do not use aggregates for this query
    Its data type is CHAR (Character String) with field length 1
  • IDVERS : Dictionary version (internal vers.) of report in RSIX
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DVERS : Dictionary version (current Release) of report in RSIX
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • RNAME : ABAP Program Name
    Its data type is CHAR (Character String) with field length 40
  • AUTHOR : Name of author
    Its data type is CHAR (Character String) with field length 12
  • GENTIME : Query Generation Time (Cache Invalidation)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LASTUSER : Last changed by
    Its data type is CHAR (Character String) with field length 12
  • MODTIME : Last Change to Definition
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • REPTIME : Last Change of Query Runtime Object
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • GEN1TIME : Query Gen Time (tech. reasons, no cache invalidation needed)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PACKFL : Process key figure with high precision
    Its data type is CHAR (Character String) with field length 1
  • PACKFL_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • NOSPBUF : SP Cannot be Permanently Buffered
    Its data type is CHAR (Character String) with field length 1
  • CACHEMODE : Cache Mode
    Its data type is CHAR (Character String) with field length 1
  • CACHEUSAGEMODE : Cache Usage Mode
    Its data type is CHAR (Character String) with field length 1
  • KIDSEL : Use Selection of Structure Elements
    Its data type is CHAR (Character String) with field length 1
  • FAGGR_LATE : Calculation of Commutative Formulas After Aggregation
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : BW: Processor Attribute Optimization
  • OPT_OCCURS : Boolean
    Its data type is CHAR (Character String) with field length 1
  • OPT_OCCURS_TIME : 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
  • OPT_OCCURS_MODE : Optimization Mode
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • OPT_OCCURS_PER : Dummy for B20 int1 (Local Everywhere)
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • SUPPRMESS : Suppress Messages
    Its data type is RAW (Byte string) with field length 32
  • CACHEUSEREXIT : Boolean
    Its data type is CHAR (Character String) with field length 1
  • NOPARALLEL : no parallel processing
    Its data type is CHAR (Character String) with field length 1
  • GENPROT : Boolean
    Its data type is CHAR (Character String) with field length 1
  • INPUTABLE : Make All Basic Indicators Ready for Input
    Its data type is CHAR (Character String) with field length 1
  • PARTITIONMODE : Type of SP Grouping for Delta Caching
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DELTACACHE : Update Cache Objects in Delta Process
    Its data type is CHAR (Character String) with field length 1
  • ACTUALDATA : Data Integrity
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • OLAPSTAT : OLAP Statistic Properties of the Query
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • OLAPSTATDETLEV : OLAP Statistics Detail Level
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ADDNLS : Should the near-line storage be read too?
    Its data type is CHAR (Character String) with field length 1
  • NOHPA : Obsolete Field (Do Not Use BWA Index)
    Its data type is CHAR (Character String) with field length 1
  • READMODE_DEFT : Boolean
    Its data type is CHAR (Character String) with field length 1
  • ACTUALDATA_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • CACHEMODE_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • DELTACACHE_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • PARTITION_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • DIS_MODE : Disaggregation on Totals
    Its data type is CHAR (Character String) with field length 1
  • INFOPROV_SUPPORT : Query is used as InfoProvider
    Its data type is CHAR (Character String) with field length 1
  • NOPARALLEL_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • KIDSEL_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • ADDNLS_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • NOHPA_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • CHUSEREXIT_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • TREXOPS : Operations in SAP HANA/BWA
    Its data type is CHAR (Character String) with field length 1
  • TREXOPS_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • MATERIALIZEQUERYLAYER : Materialize Intermediate Query Result
    Its data type is CHAR (Character String) with field length 1
  • MATERIALIZEQUERYLAYER_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1
  • IS_PLANQUERY : Boolean
    Its data type is CHAR (Character String) with field length 1
  • DATA_INTEGRITY_SCENARIO : Data Integrity Profile
    Its data type is CHAR (Character String) with field length 1
  • DI_SCENARIO_DEF : Boolean
    Its data type is CHAR (Character String) with field length 1