SAP GRFNAE Audit Entity Table data and field list

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

The GRFNAE table consists of various fields, each holding specific information or linking keys about Audit Entity data available in SAP. These include AE_GUID (Audit Entity GUID), STATUS (Audit Entity Status), CREATED_BY (User Name), CREATED_MAIN (User Replaced by Delegate)... 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. .

GRFNAE 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 GRFNAE 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 GRFNAE 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
AE_GUIDAudit Entity GUID GRFN_AE_GUIDCHAR32GRFN_GUID
STATUSAudit Entity Status GRFN_AE_STATUSCHAR5GRFN_AE_STATUS
CREATED_BYUser Name UNAMECHAR12UNAME
CREATED_MAINUser Replaced by Delegate GRPC_DL_MAIN_USERCHAR12Assigned to domainXUBNAMEXUSUSER_ADDR
CREATEDONAuditable Entity-Created On GRFN_AE_CREATED_ONDATS8DATS
CREATEDATCreated At GRFN_AUDIT_CREATEDATTIMS6
CHANGEDBYChanged By GRFN_AUD_CHANGEDBYCHAR12UNAME
CHANGEDONChanged On GRFN_AUD_CHANGEDONDATS8DATS
CHANGEDATChanged At GRFN_AUDIT_CHANGEDATTIMS6
AE_NAMETitle/Short Name GRFN_NAMECHAR40GRFN_NAME
AE_DESC_GSAP Script ID GRFN_SAPSCRIPT_IDCHAR32GRFN_GUID
NOTES_GSAP Script ID GRFN_SAPSCRIPT_IDCHAR32GRFN_GUID
CHANGED_BYUser Name UNAMECHAR12UNAME
CHANGED_MAINUser Replaced by Delegate GRPC_DL_MAIN_USERCHAR12Assigned to domainXUBNAMEXUSUSER_ADDR
CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
START_DATEStart Date BEGDATUMDATS8DATUMBEG
END_DATEEnd Date ENDDATUMDATS8DATUMEND
AE_TYPEAttribute Value GRPC_ATTRVALUECHAR10GRPC_ATTRVALUE
RISKObject ID GRFN_OBJECT_IDNUMC8NUM08

Key field Non-key field



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

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

SELECT SINGLE *
FROM GRFNAE
INTO CORRESPONDING FIELDS OF WA_GRFNAE
WHERE...

How to access SAP table GRFNAE

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

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