SAP GRAC_S_UI_ITEM_DATA Item Data in ALV Grid Table data and field list

GRAC_S_UI_ITEM_DATA 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 "Item Data in ALV Grid" 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_GRAC_S_UI_ITEM_DATA TYPE GRAC_S_UI_ITEM_DATA.

The GRAC_S_UI_ITEM_DATA table consists of various fields, each holding specific information or linking keys about Item Data in ALV Grid data available in SAP. These include ITEM_TYPE (Line Item Type), SYSTEMS (Application or Connector), RISKS (Grac Traffic Icons), MITIGATION_CONTROL (Grac Traffic Icons)... 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. .

GRAC_S_UI_ITEM_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP GRAC_S_UI_ITEM_DATA 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 GRAC_S_UI_ITEM_DATA 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
ITEM_NAMELine Item ID GRAC_LINE_ITEM_IDCHAR100GRAC_LINE_ITEM_ID
ITEM_TYPELine Item Type GRAC_LINE_ITEM_TYPECHAR3GRAC_LINE_ITEM_TYPE
SYSTEMSApplication or Connector GRAC_REQSYSTEMCHAR32Assigned to domainRFCDEST
RISKSGrac Traffic Icons GRAC_ICONSCHAR30
MITIGATION_CONTROLGrac Traffic Icons GRAC_ICONSCHAR30
TRANSACTION_USAGETransaction Usage GRAC_TRANSACTIONS_USAGECHAR10CHAR10
VALID_FROMValidity Start Date GRAC_VALID_FROMDATS8GRAC_DATE
VALID_TOValidity End Date GRAC_VALID_TODATS8GRAC_DATE
ACTIONAction Associated with Line Item GRAC_LINE_ITEM_ACTIONCHAR3GRAC_LINE_ITEM_ACTION
ACTION_SYSTEMAction Associated with Line Item GRAC_REQ_SYSTEM_ACTIONCHAR3GRAC_REQ_SYSTEM_ACTION
CELL_VARIANT_ACTIONChar 20 CHAR20CHAR20CHAR20
CELL_VARIANTChar 20 CHAR20CHAR20CHAR20
APP_ACTIONLine Item Owner Action Like Approve and Reject GRAC_LINE_ITEM_OWNER_ACTIONCHAR2GRAC_LINE_ITEM_OWNER_ACTION
ITEM_IDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
ITEMNUMAction Sequence GRAC_SEQNUMC4GRAC_SEQUENCE
PARENT_ITEMNUMAction Sequence GRAC_SEQNUMC4GRAC_SEQUENCE
READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
ITEM_DESCDescription GRAC_DESCNCHAR132GRAC_DESCN
ITEM_TYPE_DESCDescription for item type GRAC_ITEM_TYPE_DESCCHAR132GRAC_DESCN
COMMENTS 0
ISCHECKEDIndicator GRFN_BOOLEANCHAR1GRFN_BOOLEAN
USERIDUser ID GRAC_USERCHAR50GRAC_USER
FFOBJECTDescription for User ID or Role GRAC_FFOBJECTCHAR30GRAC_FFOBJECT
OWNERUser ID GRAC_USERIDCHAR12UNAME
OWNER_NAMEUser ID GRAC_USERCHAR50GRAC_USER
CONNECTORApplication or Connector GRAC_REQSYSTEMCHAR32Assigned to domainRFCDEST
OWNER_READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
APP_ACTION_READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
ROLE_TYPE_DESCDescription GRAC_DESCNCHAR132GRAC_DESCN
STATUSExpiration Status GRAC_EXP_STATUSCHAR8GRAC_EXP_STATUS
PROV_ACTION_TXT 0
PROV_TYPEProvisioning Type GRAC_PROV_TYPENUMC2GRAC_PROV_TYPE
PROV_TYPE_READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
ASSIGNMENT_TYPEAssignment Type GRAC_ASSIGNMENT_TYPENUMC2GRAC_ASSIGNMENT_TYPE
ASSIGNMENT_TYPE_READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
PROVISIONEDProvision Status GRAC_PROVISIONEDCHAR1GRAC_PROVISIONED
RISK_ICONGrac Traffic Icons GRAC_ICONSCHAR30
MITIGATION_ICONGrac Traffic Icons GRAC_ICONSCHAR30
CELL_VARIANT_OWNERChar 20 CHAR20CHAR20CHAR20
ACTION_READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
BUSS_ROLE_IDObject ID GRFN_API_OBJECT_IDCHAR50CHAR50
BUSS_ROLE_NAMERole Name GRAC_ROLE_NAMECHAR300GRAC_ROLE_NAME
VT_READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
VF_READONLYBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN

Key field Non-key field



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

As GRAC_S_UI_ITEM_DATA 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 GRAC_S_UI_ITEM_DATA as there is no data to select.

How to access SAP table GRAC_S_UI_ITEM_DATA

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

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