SAP AGR_TCODES Assignment of roles to Tcodes Table

Overview

AGR_TCODES is a standard SAP S/4HANA table that stores Assignment of roles to Tcodes data. There are total 8 fields in the AGR_TCODES table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AGR_TCODES 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_TCODES to other SAP tables and standard CDS views available based on AGR_TCODES table in S/4HANA 2020.

Techincal Settings of AGR_TCODES

Below are technical details of the table AGR_TCODES

  • Buffering switched on
  • Full buffering as specified by generic key
  • Storage type is Column Store

List of AGR_TCODES Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClient IDSYMANDTT000CLNT3
AGR_NAMERole NameAGR_NAMEAGR_DEFINECHAR30
TYPEReport typeREPORTTYPESREPOTYPESCHAR2
TCODEExtended program nameAGXREPORTCHAR48
EXCLUDEExclusiveAGR_EXCLCHAR1
DIRECTFlag to show that the transaction was input directlyAGR_DIRECHAR1
INHERITEDFlag to show that the entry was inheritedAGR_INHECHAR1
FOLDERCounter for menu IDMENU_NUM_5NUMC5

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_TCODES

Table NameFieldCardinalityCheck Table
AGR_TCODESAGR_NAME1: CNAGR_DEFINE
AGR_TCODESMANDT1: CNT000
AGR_TCODESTYPE1: CNSREPOTYPES

Other References