SAP GRACPREREQ Prerequisite Table data and field list

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

The GRACPREREQ table consists of various fields, each holding specific information or linking keys about Prerequisite data available in SAP. These include PREREQ_NAME (Role prerequisite name), PREREQ_TYPE (Prerequisite Type), PREREQ_COURSEID (Course ID), PREREQ_SYSTEM (Prerequisite System)... 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. .

GRACPREREQ table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

Text table = GRACPREREQT


SAP GRACPREREQ 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 GRACPREREQ 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
PREREQ_NAMERole prerequisite name GRAC_ROLE_PREREQ_NAMECHAR50CHAR50LOW
PREREQ_TYPEPrerequisite Type GRAC_PREREQ_TYPECHAR10GRACPRERQTYPCHAR10
PREREQ_COURSEIDCourse ID GRAC_COURSE_IDCHAR32GRFN_GUID
PREREQ_SYSTEMPrerequisite System GRAC_PREREQ_SYSTEMCHAR32Assigned to domainRFCDESTF4_RFCDESALL

Key field Non-key field



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

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

SELECT SINGLE *
FROM GRACPREREQ
INTO CORRESPONDING FIELDS OF WA_GRACPREREQ
WHERE...

How to access SAP table GRACPREREQ

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

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