SAP GRACROLE Role Table data and field list

GRACROLE is a standard SAP Table which is used to store Role data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The GRACROLE table consists of various fields, each holding specific information or linking keys about Role data available in SAP. These include ROLEID (Role ID), ROLE_NAME (Role Name), CONNECTOR_GRP (Connector Group), ROLE_TYPE (Role Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

GRACROLE table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = GRACROLET


SAP GRACROLE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the GRACROLE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ROLEIDRole ID GRAC_ROLEIDCHAR32GRFN_GUID
ROLE_NAMERole Name GRAC_ROLE_NAMECHAR300GRAC_ROLE_NAME
CONNECTOR_GRPConnector Group GRFN_CONNECTORGRPCHAR10GRFNCONNGRPGRFN_CONNECTORGRP
ROLE_TYPERole Type GRAC_ROLE_TYPECHAR3GRACROLETYPEGRAC_ROLE_TYPE
BPROCBusiness Process GRAC_BPROCCHAR10GRACBPROCGRACBPROC
BSUBPROCSubprocess GRAC_BSUBPROCCHAR10GRACBSUBPROCGRAC_BSUBPROC
PRJRELProject Release GRAC_PRJ_RELCHAR10GRACPROJRELGRAC_PRJ_REL
CRITLVLCritical Level GRAC_CRITLVLCHAR3GRACCRITILVLGRAC_CRITLVL
PROFILEProfile Name GRAC_PROFILECHAR20GRAC_PROFILE
ROLE_STATUSRole Status GRAC_ROLE_STATUSCHAR3GRACROLESTATUSGRAC_ROLE_STATUS
NMCNVNaming Convention GRAC_NMCNVNUMC4GRACNAMECONVGRAC_NMCNV
METHODOLOGYMethodology process GRAC_METHODOLOGYNUMC3GRACMTHGRAC_METHODOLOGY
LOCKEDIndicator GRFN_BOOLEANCHAR1GRFN_BOOLEAN
CURRENT_STEPSequence GRAC_SEQUENCENUMC4GRAC_SEQUENCE
MAX_STEPSequence GRAC_SEQUENCENUMC4GRAC_SEQUENCE
BACKEND_MODEIndicator GRFN_BOOLEANCHAR1GRFN_BOOLEAN
CERTIFY_PERIODCertification period GRAC_CERTIFY_PERIODNUMC5GRAC_NUMBER
CERTIFY_DATECerfified Date GRAC_CERTIFY_DATEDATS8GRFN_DATUM
CERTIFY_DUECerfified Date GRAC_CERTIFY_DATEDATS8GRFN_DATUM
CERTIFY_BYUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
REAFFIRM_PERIODReaffirm Period GRAC_REAF_PERIODNUMC5GRAC_NUMBER
LAST_REAFFIRM_DTReaffirm Date GRAC_REAFF_DATEDATS8GRFN_DATUM
REAFFIRM_DUEReaffirm Date GRAC_REAFF_DATEDATS8GRFN_DATUM
LAST_REAFFIRM_BYUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
COMM_MANDIndicator GRFN_BOOLEANCHAR1GRFN_BOOLEAN
CHANGE_BYUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
CHANGE_ONTime Stamp GRFN_TIMESTAMPDEC15TSTPSGRFN_TIMESTAMP
CREATE_BYUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
CREATE_ONTime Stamp GRFN_TIMESTAMPDEC15TSTPSGRFN_TIMESTAMP
ROLE_SOURCERole Source GRAC_ROLE_SOURCENUMC3GRAC_ROLE_SOURCE
SENSITIVITYRole Sensitivity GRAC_SENSITIVITYNUMC3GRACRLSENSGRAC_SENSITIVITY
ALLOW_DERIVATIONIndicator GRFN_BOOLEANCHAR1GRFN_BOOLEAN
IDENTIFIERRole Identifier GRAC_IDENTIFIERCHAR100GRAC_IDENTIFIER
PROV_COMM_MANDComments Mandatory for provisioning GRAC_COMM_MANDCHAR1GRFN_BOOLEAN
CONS_PARENT_APVRConsider parent role approvers for child roles GRAC_CONS_PARENT_APPRVCHAR1GRFN_BOOLEAN
LAST_AUTH_SYNCTime Stamp GRFN_TIMESTAMPDEC15TSTPSGRFN_TIMESTAMP
LAST_AUTH_UPDATETime Stamp GRFN_TIMESTAMPDEC15TSTPSGRFN_TIMESTAMP
CAN_BE_FF_ROLECan be Firefighter Role GRAC_CAN_BE_FFCHAR1GRFN_BOOLEAN

Key field Non-key field



How do I retrieve data from SAP table GRACROLE using ABAP code

The following ABAP code Example will allow you to do a basic selection on GRACROLE to SELECT all data from the table
DATA: WA_GRACROLE TYPE GRACROLE.

SELECT SINGLE *
FROM GRACROLE
INTO CORRESPONDING FIELDS OF WA_GRACROLE
WHERE...

How to access SAP table GRACROLE

Within an ECC or HANA version of SAP you can also view further information about GRACROLE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).