GRACMITPROF SAP table for – Profile mitigating control assignment

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

SAP GRACMITPROF table

Table GRACMITPROF technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROFILE : Profile Name
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • .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