GRACRLCONNVAL SAP table for – Role Connector (system) Validity

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

SAP GRACRLCONNVAL table

Table GRACRLCONNVAL technical data

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

SAP GRACRLCONNVAL 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 GRACRLCONNVAL 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
  • CONNECTOR : Connector Id
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • ACTUAL_END_DATE : Actual End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MAX_DUR_DAYS : Maximum Days of Assignment
  • MAX_DUR_MONTHS : Maximum Months of Assignment
  • MAX_DUR_YEARS : Maximum Years of Assignment
  • PROV_ALLOW : Provisioning Allowed
    Its data type is CHAR (Character String) with field length 1
  • REP_REF_ROLE_ID : UUID of the GRC object (char32)
    Its data type is CHAR (Character String) with field length 32
  • AUTO_PROV_ALLOW : Allow Auto-provisioning
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Include Structure for Change history
  • CHANGED_BY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_ON : Time Stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CREATED_BY : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_ON : Time Stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15