GRACUSER SAP table for – User Table

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

SAP GRACUSER table

Table GRACUSER technical data

TableGRACUSER
Data storingUser Table
ModuleGRC
Sub ModuleGRC-AC
SAP PackageGRAC_REPOSITORY
Delivery ClassA – Application table (master and transaction data)
ComponentGRCFND_A
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • USER_ID : User ID
    Its a key field. Its data type is CHAR (Character String) with field length 50
  • CONNECTOR : Connector Id
    Its data type is CHAR (Character String) with field length 32
  • FIRST_NAME : User name
    Its data type is CHAR (Character String) with field length 50
  • LAST_NAME : User name
    Its data type is CHAR (Character String) with field length 50
  • EMAIL : E-Mail Address
    Its data type is CHAR (Character String) with field length 241
  • PHONE : Phone Number
    Its data type is CHAR (Character String) with field length 20
  • DEPARTMENT : Department
    Its data type is CHAR (Character String) with field length 100
  • UPDATED_ON : Time Stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • MANAGER_ID : User ID
    Its data type is CHAR (Character String) with field length 50
  • EXCLUDED : Boolean Variable (X=True, -=False, Space=Unknown)
    Its data type is CHAR (Character String) with field length 1
  • PERSONNELNO : Personnel Number
    Its data type is CHAR (Character String) with field length 20
  • USER_HR_FNAME : User name
    Its data type is CHAR (Character String) with field length 50
  • USER_HR_LNAME : User name
    Its data type is CHAR (Character String) with field length 50
  • USER_HR_EMAIL : E-Mail Address
    Its data type is CHAR (Character String) with field length 241
  • FNAME_SH : User name
    Its data type is CHAR (Character String) with field length 50
  • LNAME_SH : User name
    Its data type is CHAR (Character String) with field length 50
  • EMAIL_SH : E-Mail Address
    Its data type is CHAR (Character String) with field length 241
  • USER_ID_SH : User ID Upper case only
    Its data type is CHAR (Character String) with field length 50