SAP GRACBUSROLEUSERS Business Role User Reassignment Table data and field list

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

The GRACBUSROLEUSERS table consists of various fields, each holding specific information or linking keys about Business Role User Reassignment data available in SAP. These include PROV_ID (UUID of the GRC object (char32)), CONNECTOR (Connector Id), USER_ID (User ID), ROLE_ID (Role ID)... 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. .

GRACBUSROLEUSERS 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 GRACBUSROLEUSERS 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 GRACBUSROLEUSERS 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 MANDTCLNT3Assigned to domainMANDT
PROV_IDUUID of the GRC object (char32) GRFN_GUIDCHAR32GRFN_GUID
CONNECTORConnector Id GRFN_CONNECTORIDCHAR32Assigned to domainRFCDEST
USER_IDUser ID GRAC_USERCHAR50GRAC_USER
ROLE_IDRole ID GRAC_ROLEIDCHAR32GRFN_GUID
ACTIONProvisioning Action Type for Technical role in a Business Ro GRAC_ROLE_PROVISIONINGINT13GRAC_ROLE_PROVISIONING
VALID_FROMValidity Start Date GRAC_VALID_FROMDATS8GRAC_DATE
VALID_TOValidity End Date GRAC_VALID_TODATS8GRAC_DATE
UPDATED_BYField Last Updated by Username GRAC_UPDATED_BYCHAR12Assigned to domainXUBNAME
UPDATED_ONTime Stamp GRFN_TIMESTAMPDEC15TSTPSGRFN_TIMESTAMP
STATUSBoolean GRAC_BOOLEANCHAR1GRFN_BOOLEAN
REASONDescription GRAC_DESCCHAR255GRAC_DESC

Key field Non-key field



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

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

SELECT SINGLE *
FROM GRACBUSROLEUSERS
INTO CORRESPONDING FIELDS OF WA_GRACBUSROLEUSERS
WHERE...

How to access SAP table GRACBUSROLEUSERS

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

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