GRACROLE SAP table for – Role

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

SAP GRACROLE table

Table GRACROLE technical data

TableGRACROLE
Data storingRole
ModuleGRC
Sub ModuleGRC-AC
SAP PackageGRAC_ROLE_MANAGEMENT
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ROLEID : Role ID
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • ROLE_NAME : Role Name
    Its data type is CHAR (Character String) with field length 300
  • CONNECTOR_GRP : Connector Group
    Its data type is CHAR (Character String) with field length 10
  • ROLE_TYPE : Role Type
    Its data type is CHAR (Character String) with field length 3
  • BPROC : Business Process
    Its data type is CHAR (Character String) with field length 10
  • BSUBPROC : Subprocess
    Its data type is CHAR (Character String) with field length 10
  • PRJREL : Project Release
    Its data type is CHAR (Character String) with field length 10
  • CRITLVL : Critical Level
    Its data type is CHAR (Character String) with field length 3
  • PROFILE : Profile Name
    Its data type is CHAR (Character String) with field length 20
  • ROLE_STATUS : Role Status
    Its data type is CHAR (Character String) with field length 3
  • NMCNV : Naming Convention
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • METHODOLOGY : Methodology process
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • LOCKED : Indicator
    Its data type is CHAR (Character String) with field length 1
  • CURRENT_STEP : Sequence
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • MAX_STEP : Sequence
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BACKEND_MODE : Indicator
    Its data type is CHAR (Character String) with field length 1
  • CERTIFY_PERIOD : Certification period
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • CERTIFY_DATE : Cerfified Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CERTIFY_DUE : Cerfified Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CERTIFY_BY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • REAFFIRM_PERIOD : Reaffirm Period
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • LAST_REAFFIRM_DT : Reaffirm Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REAFFIRM_DUE : Reaffirm Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_REAFFIRM_BY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • COMM_MAND : Indicator
    Its data type is CHAR (Character String) with field length 1
  • CHANGE_BY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • CHANGE_ON : Time Stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CREATE_BY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • CREATE_ON : Time Stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ROLE_SOURCE : Role Source
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SENSITIVITY : Role Sensitivity
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ALLOW_DERIVATION : Indicator
    Its data type is CHAR (Character String) with field length 1
  • IDENTIFIER : Role Identifier
    Its data type is CHAR (Character String) with field length 100
  • PROV_COMM_MAND : Comments Mandatory for provisioning
    Its data type is CHAR (Character String) with field length 1
  • CONS_PARENT_APVR : Consider parent role approvers for child roles
    Its data type is CHAR (Character String) with field length 1
  • LAST_AUTH_SYNC : Time Stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LAST_AUTH_UPDATE : Time Stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CAN_BE_FF_ROLE : Can be Firefighter Role
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes