AGR_HIER

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

Tabelle für die Strukturinformation des Menüs

AGR_HIER is an SAP database table in S/4HANA. Tabelle für die Strukturinformation des Menüs. 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.

-- Tabelle für die Strukturinformation des Menüs
-- 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