Users with Critical Authorizations Report (SAP_ALL, Debug, Table Maintenance)
Short answer: A custom ALV report that lists users holding authorizations that are critical on their own, such as the SAP_ALL and SAP_NEW profiles, debugging with value change, table maintenance, user and role maintenance or changing RFC destinations, showing which role or profile grants the access, the value and the validity end of the assignment. The rule list is kept in a settings table that can be maintained per customer; before an audit, one list shows who has what.
- Estimated effort
- M · 5–7 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
"Users by complex selection criteria" in SUIM (RSUSR002) searches one authorization object and value combination at a time; it does not evaluate dozens of critical rules in one run, and it does not show in the same row which role grants the access and when the assignment ends. SAP_ALL profile assignments and role-based authorizations are searched separately. The segregation of duties (SoD) report checks pairs of authorizations; this report scans authorizations that are critical on their own against a rule list.
Who uses it? BASIS and authorization administrators, information security teams, internal audit and IT management working with external auditors.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| USR02User Logon Data | User type, group, lock status, validity and last logon (driving table) | — | ECC + S/4 |
| AGR_USERSAssignment of Roles to Users | User-to-role assignment and validity dates | AGR_USERS-UNAME = USR02-BNAME | ECC + S/4 |
| AGR_1251Authorization Data for Roles | Authorization object, field and values in the role | AGR_1251-AGR_NAME = AGR_USERS-AGR_NAME | ECC + S/4 |
| UST04User Profile Assignments | Directly assigned profiles (SAP_ALL, SAP_NEW) | UST04-BNAME = USR02-BNAME | ECC + S/4 |
| AGR_TEXTSRole Texts | Role description | AGR_TEXTS-AGR_NAME = AGR_USERS-AGR_NAME AND AGR_TEXTS-SPRAS = SY-LANGU AND AGR_TEXTS-LINE = 0 | ECC + S/4 |
| USR21User Name to Address Key Assignment | Person number of the user | USR21-BNAME = USR02-BNAME | ECC + S/4 |
| ADRPPersons (Business Address Services) | Full name of the user | ADRP-PERSNUMBER = USR21-PERSNUMBER | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_UNAME | User | Range / multiple | USR02-BNAME | No | * hariç FIREFIGHTER* |
| S_USTYP | User type | Range / multiple | USR02-USTYP | No | A, B, S |
| S_CLASS | User group | Range / multiple | USR02-CLASS | No | — |
| S_AGR | Role | Range / multiple | AGR_USERS-AGR_NAME | No | ROL_* |
| S_OBJCT | Authorization object (narrows the rule list) | Range / multiple | AGR_1251-OBJECT | No | S_DEVELOP, S_TABU_DIS |
| P_KEYDT | Key date | Single value | — | Yes | 17.11.2026 |
| P_PROF | Check directly assigned critical profiles | Checkbox | — | No | X |
| P_LOCK | Also show locked users | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | User | USR02-BNAME |
| 2 | Full name | ADRP-NAME_TEXT |
| 3 | User type | USR02-USTYP |
| 4 | User group | USR02-CLASS |
| 5 | Last logon | USR02-TRDAT |
| 6 | Critical rule | Calculated Description of the matching rule in the settings table |
| 7 | Role | AGR_USERS-AGR_NAME |
| 8 | Role description | AGR_TEXTS-TEXT |
| 9 | Profile | UST04-PROFILE |
| 10 | Authorization object | AGR_1251-OBJECT |
| 11 | Field | AGR_1251-FIELD |
| 12 | Value | AGR_1251-LOW |
| 13 | Assignment valid to | AGR_USERS-TO_DAT |
| 14 | Risk level | Calculated Risk level of the rule; SAP_ALL and debug change are always Critical |
Sample output
| User | Full name | User type | User group | Last logon | Critical rule | Role | Role description | Profile | Authorization object | Field | Value | Assignment valid to | Risk level |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MKAYA | Murat Kaya | A | FINANS | 11/16/2026 | Table maintenance (change) | ROL_FI_ANAHTAR_KULLANICI | FI key user | S_TABU_DIS | ACTVT | 02 | 12/31/9999 | High | |
| ADEMIR | Ayşe Demir | A | BT_DESTEK | 11/17/2026 | Debugging with value change | ROL_BT_DESTEK | IT application support | S_DEVELOP | OBJTYPE | DEBUG | 12/31/2026 | Critical | |
| RFC_ENTEGRASYON | Integration technical user | B | TEKNIK | 11/17/2026 | Full authorization profile | SAP_ALL | Critical | ||||||
| OYILMAZ | Okan Yılmaz | A | SATIS | 09/02/2026 | User maintenance transaction | ROL_SD_SUPERVIZOR | Sales supervisor | S_TCODE | TCD | SU01 | 03/31/2027 | High |
How does the report work?
- The rule list is read from the settings table: rule code, risk level, authorization object, field and value (e.g. S_TCODE-TCD = SU01, PFCG, SE38, SM59, SCC4; S_DEVELOP OBJTYPE = DEBUG and ACTVT = 02; S_TABU_DIS ACTVT = 02; S_USER_GRP ACTVT = 01/02; S_BTCH_ADM BTCADMIN = Y).
- Authorization values that are not deleted (DELETED blank) are read from AGR_1251 and matched against the rules; ‘*’ wildcards and LOW–HIGH ranges count as a match when they cover the rule value.
- Matching roles are expanded to users through AGR_USERS assignments valid on the key date; single roles of composite roles are stored separately in AGR_USERS and are found directly. The role description is added from AGR_TEXTS.
- Users with SAP_ALL, SAP_NEW or other critical profiles from the rule list assigned directly are read from UST04.
- User type, group, lock status (UFLAG), validity and last logon are added from USR02, the full name from USR21/ADRP. Locked users are excluded depending on the selection.
- The result is listed by user and rule in ALV; double-clicking the user opens SU01, double-clicking the role opens PFCG.
Performance notes
Narrow AGR_1251 by the authorization objects in the rule list first and compare the values in ABAP. Read user and name data once with FOR ALL ENTRIES. On systems with thousands of roles the report can take a few minutes; run it in the background for the monthly audit list.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the user opens SU01, double-clicking the role opens PFCG.
- Export to Excel
- Runs as a background job
- Send the result by email The monthly list can be emailed to the information security team.
Authorization objects
- S_USER_GRPDisplay user data by user group (ACTVT 03)
- S_USER_AGRDisplay roles and role authorizations
- S_USER_PRODisplay profiles
Frequently asked questions
Who defines the critical rule list?
During installation, a starter list of common critical authorizations is prepared with the information security and audit team. The list is kept in a settings table; adding a rule needs no program change.
Does the report read user password data?
No. The report reads only metadata such as roles, profiles, user type, validity and last logon. Fields holding password hashes or security keys are never selected.
How are emergency (firefighter) users separated?
Emergency users can be excluded from the selection by user group or name pattern, or listed alone with a separate variant. Approved exceptions are then tracked apart from the main findings.
Packages that include this solution
SAP Access and Payment Risk Audit Pack
A six-component pack that brings together the controls asked most often in the yearly IT and finance audit: users with critical authorizations, …
Related reports
Expiring and Expired Role Assignments Report
A custom ALV report that lists role assignments whose validity ends within the next N days or that have ended but are still on the user, with the …
Segregation of Duties (SoD) Conflict Report by User
A custom ALV report that lists users who can run conflicting activities together (for example changing vendor master data and running the payment …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.