SAP GRFN_S_API_AE Auditable Enity API structure Table data and field list

GRFN_S_API_AE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Auditable Enity API structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_GRFN_S_API_AE TYPE GRFN_S_API_AE.

The GRFN_S_API_AE table consists of various fields, each holding specific information or linking keys about Auditable Enity API structure 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. .

GRFN_S_API_AE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP GRFN_S_API_AE structure 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 GRFN_S_API_AE 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
AE_GUID	Audit Entity GUID	GRFN_AE_GUID	CHAR	32			GRFN_GUID
STATUS	Audit Entity Status	GRFN_AE_STATUS	CHAR	5			GRFN_AE_STATUS
CREATED_BY	User Name	UNAME	CHAR	12			UNAME
CREATED_MAIN	User Replaced by Delegate	GRPC_DL_MAIN_USER	CHAR	12	Assigned to domain		XUBNAME	XUS	USER_ADDR
CREATED_TIMESTMP	Query UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	GRFN_QUERYTIMESTAMP	DEC	15			TZNTSTMPS
CREATEDON	Auditable Entity-Created On	GRFN_AE_CREATED_ON	DATS	8			DATS
CREATEDAT	Created At	GRFN_AUDIT_CREATEDAT	TIMS	6
CHANGEDBY	Changed By	GRFN_AUD_CHANGEDBY	CHAR	12			UNAME
CHANGEDON	Changed On	GRFN_AUD_CHANGEDON	DATS	8			DATS
CHANGEDAT	Changed At	GRFN_AUDIT_CHANGEDAT	TIMS	6
AE_NAME	Title/Short Name	GRFN_NAME	CHAR	40			GRFN_NAME
AE_DESC_G	SAP Script ID	GRFN_SAPSCRIPT_ID	CHAR	32			GRFN_GUID
NOTES_G	SAP Script ID	GRFN_SAPSCRIPT_ID	CHAR	32			GRFN_GUID
CHANGED_BY	User Name	UNAME	CHAR	12			UNAME
CHANGED_MAIN	User Replaced by Delegate	GRPC_DL_MAIN_USER	CHAR	12	Assigned to domain		XUBNAME	XUS	USER_ADDR
CHANGED_TIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
START_DATE	Start Date	BEGDATUM	DATS	8			DATUM	BEG
END_DATE	End Date	ENDDATUM	DATS	8			DATUM	END
AE_TYPE	Attribute Value	GRPC_ATTRVALUE	CHAR	10			GRPC_ATTRVALUE
RISK	Object ID	GRFN_OBJECT_ID	NUMC	8			NUM08
AE_VERSION	Audit Entity Version	GRFN_AE_VERSION	CHAR	32			GRFN_GUID
AE_DESC_T	Description	GRFN_LONG_TEXT	STRG	0

Key field

Non-key field

< GRFN_S_AP - Audit Plan GRFN_S_API_AE_AU_RELOBJ - Auditable Enity related entities API structure >

How do I retrieve data from SAP structure GRFN_S_API_AE using ABAP code?

As GRFN_S_API_AE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on GRFN_S_API_AE as there is no data to select.

How to access SAP table GRFN_S_API_AE

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

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