1. Home
  2. Resources
  3. SAP Tables
  4. AGR_HIER - Table for Structure Information for Menu

SAP Table AGR_HIER

Table for Structure Information for Menu

AGR_HIER (Table for Structure Information for Menu) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AGR_HIER to other SAP tables.

AGR_HIER table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client ID SYMANDT T000 CLNT 3 0
AGR_NAME Role Name AGR_NAME AGR_DEFINE CHAR 30 0
OBJECT_ID Counter for Menu ID MENU_NUM_8 NUMC 8 0
PARENT_ID Counter for Menu ID MENU_NUM_8 NUMC 8 0
FOLDER Customized ('C') or standard menu ('S') flag MENU_FLAG CHAR 1 0
SORT_ORDER Counter for Menu ID MENU_NUM_8 NUMC 8 0
REPORTTYPE Report type REPORTTYPE CHAR 2 0
REPORT Extended Program Name EXTDREPORT CHAR 48 0
MENU_LEVEL Level in the menu MENU_NUM_2 NUMC 2 0
SAP_GUID Unique ID - 32 characters HIER_GUID CHAR 32 0
ATTRIBUTES Attributes of the menu MENU_ATTR CHAR 10 0
TARGET_SYS Logical Destination (Specified in Function Call) RFCDEST CHAR 32 0
X_POS Counter for menu ID MENU_NUM_5 NUMC 5 0
Y_POS Counter for menu ID MENU_NUM_5 NUMC 5 0
BOOK_INFO Structures: name of the structure COLOR_INFO CHAR 12 0
SOURCE_AGR Role Name AGR_NAME CHAR 30 0
ICON Icons for Role Menu Entries MENU_ICON CHAR 128 0
FLAGS Attributes for Menu Entry MENU_FLAGS CHAR 16 0
APPL_ALIAS Application Alias MENU_DETAILS_ALIAS CHAR 60 0

AGR_HIER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AGR_HIER AGR_NAME AGR_HIER MANDT AGR_DEFINE Role definition MANDT
AGR_HIER AGR_NAME AGR_HIER AGR_NAME AGR_DEFINE Role definition AGR_NAME
AGR_HIER MANDT AGR_HIER MANDT T000 Clients MANDT