GRACMITROLE SAP table for – Role mitigating control assignment

Here we would like to draw your attention to GRACMITROLE table in SAP. As we know it is being mainly used with the SAP GRC-AC (Access Control in GRC) component which is coming under GRC module (Governance, Risk and Compliance). GRACMITROLE is a SAP standard transp table used for storing Role mitigating control assignment related data in SAP. It comes under the package GRAC_SOD.

SAP GRACMITROLE table

Table GRACMITROLE technical data

TableGRACMITROLE
Data storingRole mitigating control assignment
ModuleGRC
Sub ModuleGRC-AC
SAP PackageGRAC_SOD
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ROLE : UUID of the GRC object (char32)
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Primary keys for mitigation db tables
    Its a key field.
  • CONNECTOR : Connector Id
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • RISKID : Access Risk ID
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • ACTRULEID : SOD Rule ID
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ACCONTROLID : SOD Control ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Mitigation details in db tables
  • VALIDFROM : Validity Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Validity End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MONITOR : Owner Description
    Its data type is CHAR (Character String) with field length 12
  • ACTIVE : Active indicator
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Structure to store update info ( BY as CHAR12 & ON as DEC15)
  • UPDATED_BY : Field Last Updated by Username
    Its data type is CHAR (Character String) with field length 12
  • UPDATED_ON : Timestamp when the Field was Last Updated
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15