SAP AGR_APPL_VARS Applications and Application Variants in Role Menu Table

Overview

AGR_APPL_VARS is a standard SAP S/4HANA table that stores Applications and Application Variants in Role Menu data. There are total 5 fields in the AGR_APPL_VARS table. The following is a list of the fields that make up this table. Key fields are marked in blue.

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

Techincal Settings of AGR_APPL_VARS

Below are technical details of the table AGR_APPL_VARS

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

List of AGR_APPL_VARS Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClient IDSYMANDTT000CLNT3
AGR_NAMEName of imparting rolePAR_AGRAGR_DEFINECHAR30
TYPEType of Check Flag and Authorization Default ValuesUSOBTYPECHAR2
NAMEProgram, transaction or function module nameXUPNAMECHAR30
ACTIVECharacter Field of Length 1CHAR01CHAR1

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_APPL_VARS

Table NameFieldCardinalityCheck Table
AGR_APPL_VARSAGR_NAME1: CNAGR_DEFINE
AGR_APPL_VARSMANDT:T000

Other References