AGR_HIER

Transparent Table Control Table (SAP+Cust)
19 Fields 8 CDS Views

Table for Structure Information for Menu

AGR_HIER is an SAP database table in S/4HANA. Table for Structure Information for Menu. It contains 19 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
SUIM_AGR_DFL_HT view_entity from SUIM | HT Auth. Defaults in Role Menu
SUIM_AGR_DFL_RF view_entity from SUIM | RF Auth. Defaults in Role Menu
SUIM_AGR_DFL_TR view_entity from SUIM | TR Auth. Defaults in Role Menu
SUIM_AGR_HIER_OT_APPL view from SUIM Get OT Applications form AGR_HIER/BUFFI
SUIM_AGR_MNU_OTH view_entity from SUIM | Other Node Types in Menu
SUIM_AGR_MNU_PROV view_entity from SUIM | Provider Entries in Role Menu
SUIM_AGR_MNU_TRAN view_entity from SUIM|Startable Transactions in Role Menu
SUIM_AGR_START_APPL view left_outer rest

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt SYMANDT Client ID
KEY agr_name AGR_NAME Role
KEY object_id MENU_NUM_8 Object ID
parent_id MENU_NUM_8 Object ID
folder MENU_FLAG Cust. menu
sort_order MENU_NUM_8 Object ID
reporttype REPORTTYPE ReportTyp
report EXTDREPORT Extended Name
menu_level MENU_NUM_2 Level
sap_guid HIER_GUID Unique ID
attributes MENU_ATTR Attributes
target_sys RFCDEST Destination
x_pos MENU_NUM_5 ID
y_pos MENU_NUM_5 ID
book_info COLOR_INFO Color
source_agr AGR_NAME Role
icon MENU_ICON Icon
flags MENU_FLAGS Attributes
appl_alias MENU_DETAILS_ALIAS Application Alias

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Table for Structure Information for Menu
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AGR_HIER (
    MANDT,       -- Client ID [SYMANDT]
    AGR_NAME,    -- Role [AGR_NAME]
    OBJECT_ID,   -- Object ID [MENU_NUM_8]
    PARENT_ID,   -- Object ID [MENU_NUM_8]
    FOLDER,      -- Cust. menu [MENU_FLAG]
    SORT_ORDER,  -- Object ID [MENU_NUM_8]
    REPORTTYPE,  -- ReportTyp [REPORTTYPE]
    REPORT,      -- Extended Name [EXTDREPORT]
    MENU_LEVEL,  -- Level [MENU_NUM_2]
    SAP_GUID,    -- Unique ID [HIER_GUID]
    ATTRIBUTES,  -- Attributes [MENU_ATTR]
    TARGET_SYS,  -- Destination [RFCDEST]
    X_POS,       -- ID [MENU_NUM_5]
    Y_POS,       -- ID [MENU_NUM_5]
    BOOK_INFO,   -- Color [COLOR_INFO]
    SOURCE_AGR,  -- Role [AGR_NAME]
    ICON,        -- Icon [MENU_ICON]
    FLAGS,       -- Attributes [MENU_FLAGS]
    APPL_ALIAS,  -- Application Alias [MENU_DETAILS_ALIAS]
    PRIMARY KEY (MANDT, AGR_NAME, OBJECT_ID)
);

Learn More