GRACMITUSER SAP table for – User mitigating control assignment

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

SAP GRACMITUSER table

Table GRACMITUSER technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • USERID : User ID
    Its a key field. Its data type is CHAR (Character String) with field length 50
  • .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