SAP GRACROLEARC Role Archiving table for deleted roles Table data and field list

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

The GRACROLEARC table consists of various fields, each holding specific information or linking keys about Role Archiving table for deleted roles 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. .

GRACROLEARC 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 (Deep)


SAP GRACROLEARC 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 GRACROLEARC 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
DELETED_BYUser Name in User Master Record GRAC_USER12CHAR12Assigned to domainXUBNAMEXUS
DELETED_ONTime Stamp GRFN_TIMESTAMPDEC15TSTPSGRFN_TIMESTAMP

Key field Non-key field



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

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

SELECT SINGLE *
FROM GRACROLEARC
INTO CORRESPONDING FIELDS OF WA_GRACROLEARC
WHERE...

How to access SAP table GRACROLEARC

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

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