RSRA_ER_DRILL SAP table for – Drill Characteristics for the Exception Reporting Setting

Here we would like to draw your attention to RSRA_ER_DRILL 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). RSRA_ER_DRILL is a SAP standard transp table used for storing Drill Characteristics for the Exception Reporting Setting related data in SAP. It comes under the package RSRB.

SAP RSRA_ER_DRILL table

Table RSRA_ER_DRILL technical data

TableRSRA_ER_DRILL
Data storingDrill Characteristics for the Exception Reporting Setting
ModuleBW
Sub ModuleBW-BEX-ET
SAP PackageRSRB
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_BW
Table CategoryTRANSP

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

  • SETTINGNM : Technical Name of Report Agent Setting
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • OBJVERS : Object version
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • IOBJNM : InfoObject
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • POSIT : Position of an Entry in a Selection
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • HRY_START_LEVEL : Level to which you drilldown within the hierarchy
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • HRY_DRILL_LEVEL : Hierarchy level, from which drilldown will recommence
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : External key of a hierarchy
  • HIENM : Hierarchy name
    Its data type is CHAR (Character String) with field length 30
  • VERSION : Hierarchy version
    Its data type is CHAR (Character String) with field length 3
  • DATETO : Valid-to date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8