GRACREQUSER SAP table for – User Associated with Request

Here we would like to draw your attention to GRACREQUSER 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). GRACREQUSER is a SAP standard transp table used for storing User Associated with Request related data in SAP. It comes under the package GRAC_ACCESS_REQUEST.

SAP GRACREQUSER table

Table GRACREQUSER technical data

TableGRACREQUSER
Data storingUser Associated with Request
ModuleGRC
Sub ModuleGRC-AC
SAP PackageGRAC_ACCESS_REQUEST
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • REQ_ID : UUID of the GRC object (char32)
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • USERID : User ID
    Its a key field. Its data type is CHAR (Character String) with field length 50
  • .INCLUDE : DB structure for User Name
  • FNAME : First Name
    Its data type is CHAR (Character String) with field length 100
  • LNAME : Last Name
    Its data type is CHAR (Character String) with field length 100
  • PROVUSER : User ID
    Its data type is CHAR (Character String) with field length 50
  • SNC_NAME : SNC Name
    Its data type is CHAR (Character String) with field length 255
  • UNSEC_SNC : Unsecure Logon Allowed (SNC)
    Its data type is CHAR (Character String) with field length 1
  • ACCNO : Accounting Number
    Its data type is CHAR (Character String) with field length 12
  • USER_GROUP : User group
    Its data type is CHAR (Character String) with field length 12
  • EMPPOSITION : HR Position
    Its data type is CHAR (Character String) with field length 12
  • EMPJOB : Job
    Its data type is CHAR (Character String) with field length 12
  • PERSONNELNO : Personnel Number
    Its data type is CHAR (Character String) with field length 20
  • PERSONNELAREA : Personnel Area
    Its data type is CHAR (Character String) with field length 60
  • EMPTYPE : Employee Type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • EMAIL : E-Mail Address
    Its data type is CHAR (Character String) with field length 255
  • BUSINESS_AREA : Business Area
    Its data type is CHAR (Character String) with field length 10
  • FUNCTIONAL_AREA : Functional Area
    Its data type is CHAR (Character String) with field length 10
  • ACADEMIC_TITLE : Academic Title
    Its data type is CHAR (Character String) with field length 20
  • USERALIAS : User Alias
    Its data type is CHAR (Character String) with field length 40
  • USER_TYPE : User Type
    Its data type is CHAR (Character String) with field length 1
  • START_MENU : Start Menu
    Its data type is CHAR (Character String) with field length 30
  • LOGON_LANGU : Logon Language
    Its data type is LANG (Language key character with length 1) with field length 1
  • DEC_NOTATION : Decimal Notations
    Its data type is CHAR (Character String) with field length 1
  • DATE_FORMAT : Date Format
    Its data type is CHAR (Character String) with field length 1
  • TIME_ZONE : Time Zone
    Its data type is CHAR (Character String) with field length 6
  • LIC_TYPE : ID for the User Types of the SAP System
    Its data type is CHAR (Character String) with field length 2
  • MANAGER : User ID
    Its data type is CHAR (Character String) with field length 50
  • FUNCTION : Function field for su01 provisioning
    Its data type is CHAR (Character String) with field length 40