SAP AGR_TEXTS File Structure for Hierarchical Menu - Customer Table

Overview

AGR_TEXTS is a standard SAP S/4HANA table that stores File Structure for Hierarchical Menu - Customer data. There are total 5 fields in the AGR_TEXTS table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AGR_TEXTS belongs to ABAP Authorization and Role Management (BC-SEC-AUT-PFC) module and is located in the package ABAP Role Administration (Profile Generator) (S_PROFGEN).

In addition, following links provide an overview of foreign key relationships, if any, that link AGR_TEXTS to other SAP tables and standard CDS views available based on AGR_TEXTS table in S/4HANA 2020.

Techincal Settings of AGR_TEXTS

Below are technical details of the table AGR_TEXTS

  • Buffering allowed but switched off
  • Full buffering as specified by generic key
  • Storage type is Column Store

List of AGR_TEXTS Fields

The following table gives you an overview of the fields available in AGR_TEXTS

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClient IDSYMANDT*CLNT3
AGR_NAMERole NameAGR_NAMEAGR_DEFINECHAR30
SPRASLanguage of menu textsMENU_SPRAST002LANG1
LINECounter for menu IDMENU_NUM_5NUMC5
TEXTRole DescriptionAGR_TITLECHAR80

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AGR_TEXTS

Table NameFieldCardinalityCheck Table
AGR_TEXTSAGR_NAME1: CNAGR_DEFINE
AGR_TEXTSSPRAS1: CNT002

Other References