GRACMITROLEORG SAP table for – Role Org mitigating control assignment

Here we would like to draw your attention to GRACMITROLEORG 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). GRACMITROLEORG is a SAP standard transp table used for storing Role Org mitigating control assignment related data in SAP. It comes under the package GRAC_SOD.

SAP GRACMITROLEORG table

Table GRACMITROLEORG technical data

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

SAP GRACMITROLEORG 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 GRACMITROLEORG 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
  • ORGRULEID : Orgrule Id
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .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