GRACUSERPRMVL SAP table for – User Permission Violation Table

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

SAP GRACUSERPRMVL table

Table GRACUSERPRMVL technical data

TableGRACUSERPRMVL
Data storingUser Permission Violation Table
ModuleGRC
Sub ModuleGRC-AC
SAP PackageGRAC_SOD
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

SAP GRACUSERPRMVL 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 GRACUSERPRMVL 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
  • XCONNECTOR : Connector Id
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • SEQUENCE : Sequence
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RISKID : Access Risk ID
    Its data type is CHAR (Character String) with field length 8
  • ACTRULEID : SOD Rule ID
    Its data type is CHAR (Character String) with field length 4
  • FUNCTID : Function Id
    Its data type is CHAR (Character String) with field length 8
  • CONNECTOR : Connector Id
    Its data type is CHAR (Character String) with field length 32
  • ACTION : Action
    Its data type is CHAR (Character String) with field length 50
  • RESOURCEID : SOD Resource
    Its data type is CHAR (Character String) with field length 100
  • RESOURCEEXTN : Resource Extension
    Its data type is CHAR (Character String) with field length 50
  • FROMVAL : From Value
    Its data type is CHAR (Character String) with field length 50
  • TOVAL : To Value
    Its data type is CHAR (Character String) with field length 50
  • ROLEID : Role ID
    Its data type is CHAR (Character String) with field length 32
  • COMPROLEID : Role ID
    Its data type is CHAR (Character String) with field length 32
  • PROFILEID : Profile Name
    Its data type is CHAR (Character String) with field length 20
  • ORGRULEID : Organization Rule id
    Its data type is CHAR (Character String) with field length 10
  • ACCONTROLID : SOD Control ID
    Its data type is CHAR (Character String) with field length 10
  • MONITOR : Owner Description
    Its data type is CHAR (Character String) with field length 12
  • RUNTIME : 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