BASIS Report Custom development ALV report

Segregation of Duties (SoD) Conflict Report by User

Short answer: A custom ALV report that lists users who can run conflicting activities together (for example changing vendor master data and running the payment program) and shows which role grants each side. The rule set follows the company's own control matrix, so risky users are visible in a single run before an audit.

Estimated effort
M · 5–8 working days
System
ECC and S/4HANA
Tables
8
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

The critical authorization combinations report in SUIM can find conflicts, but it expects the rules to be maintained technically in SUIM's own maintenance screens; the result does not show on one line which role grants each side of the conflict, whether the assignment comes from a composite role and when the role assignment expires. Auditors therefore merge PFCG and SUIM output in Excel. The custom report uses a rule set written in business terms, gives the role source per line and can distribute the result by email.

Who uses it? SAP authorization administrators, internal audit and internal control teams, IT security officers.

Closest standard alternatives

  • SUIM User Information System. The critical combinations report finds conflicts; rules need technical maintenance and the role source and assignment validity are not on the same line.
  • PFCG Role Maintenance. Shows the content and users of one role; it does not analyze conflicts across users.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
USR02User Logon DataUser type, user group, validity, lock status and last logon (driving table)—ECC + S/4
AGR_USERSAssignment of Roles to UsersRole assignments valid on the key date and the composite role flagAGR_USERS-UNAME = USR02-BNAMEECC + S/4
AGR_1251Authorization Data for RolesS_TCODE values and critical object activities in the rolesAGR_1251-AGR_NAME = AGR_USERS-AGR_NAMEECC + S/4
TSTCSAP Transaction CodesExpansion of transaction code ranges and wildcardsTSTC-TCODE BETWEEN AGR_1251-LOW AND AGR_1251-HIGHECC + S/4
TSTCTTransaction Code TextsDescription of the conflicting transactionsTSTCT-TCODE = TSTC-TCODE AND TSTCT-SPRSL = SY-LANGUECC + S/4
AGR_TEXTSRole TextsRole descriptionAGR_TEXTS-AGR_NAME = AGR_USERS-AGR_NAME AND AGR_TEXTS-SPRAS = SY-LANGU AND AGR_TEXTS-LINE = 00000ECC + S/4
USR21User Name to Address Key AssignmentPerson number of the userUSR21-BNAME = USR02-BNAMEECC + S/4
ADRPPersons (Business Address Services)Full name of the userADRP-PERSNUMBER = USR21-PERSNUMBERECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_UNAMEUserRange / multipleUSR02-BNAMENoAYILMAZ
S_CLASSUser groupRange / multipleUSR02-CLASSNoFIN
S_USTYPUser type (default: A dialog)Range / multipleUSR02-USTYPNoA
S_AGRRoleRange / multipleAGR_USERS-AGR_NAMENoFI_AP_*
P_KEYDTKey date (default: today)Single value—Yes17.11.2026
P_RISKMinimum risk level (High, Medium, Low)Single value—NoOrta
P_OBJCHKObject-level check (activity values)Checkbox—NoX
P_LOCKDInclude locked usersCheckbox—No—

Output columns

#ColumnSource
1UserUSR02-BNAME
2Full nameADRP-NAME_TEXT
3User groupUSR02-CLASS
4RuleCalculated Conflict description from the rule set
5RiskCalculated Risk level of the rule; Low when the object check fails
6Side A transactionAGR_1251-LOW
7Side A roleAGR_USERS-AGR_NAME
8Side B transactionAGR_1251-LOW
9Side B roleAGR_USERS-AGR_NAME
10Via composite roleAGR_USERS-COL_FLAG
11Role valid toAGR_USERS-TO_DAT
12Last logonUSR02-TRDAT

Sample output

UserFull nameUser groupRuleRiskSide A transactionSide A roleSide B transactionSide B roleVia composite roleRole valid toLast logon
AYILMAZAyşe YılmazFINVendor master + payment runHighXK02FI_AP_MASTERDATAF110FI_AP_PAYMENT12/31/202611/16/2026
MDEMIRMehmet DemirPURCreate purchase order + goods receiptMediumME21NMM_PUR_BUYERMIGOMM_WH_CLERKX12/31/999911/17/2026
KAYAZZeynep KayaSALCustomer credit limit + billing cancellationHighFD32FI_AR_CREDITVF11SD_BILLING03/31/202711/12/2026
BCELIKBurak ÇelikFINPost vendor invoice + payment runLowMIROMM_IV_CLERKF110FI_AP_DISPLAY_ALLX12/31/999911/03/2026
A view built with fictional sample data; not real system data.

How does the report work?

  1. The rule set is read: each rule consists of two function groups (A and B), each group is a list of transaction codes and the rule carries a risk level. Rules are kept in a small maintenance table delivered with the report; common P2P, O2C and R2R conflicts are pre-filled at installation.
  2. Users in the selection are read from USR02; by default only dialog users (USTYP = A) that are not locked (UFLAG = 0) and valid on the key date (GLTGV ≤ date ≤ GLTGB, or GLTGB empty) are included.
  3. Role assignments valid on the key date are read from AGR_USERS (FROM_DAT ≤ date ≤ TO_DAT). Single roles that come through a composite role are flagged with COL_FLAG and shown separately.
  4. For each role, the TCD field of object S_TCODE (DELETED blank) is read from AGR_1251; LOW–HIGH ranges and values containing * are expanded against the transaction codes in TSTC.
  5. Each user’s effective transaction set is compared with the rules: if the user has at least one transaction from group A and at least one from group B, a conflict is written; the first granting role and transaction is kept for each side.
  6. With “Object-level check” selected, the critical object and activity values defined in the rule (for example ACTVT 01/02) are also checked in AGR_1251; lines with the transaction but without the activity are downgraded to low risk.
  7. The full name is added from USR21 and ADRP, and the role description from AGR_TEXTS. The result is shown in ALV with subtotals per user and rule.

Performance notes

Read AGR_1251 only for the roles of the selected users and with the filter OBJECT = 'S_TCODE'. Expand wildcard values against TSTC once and keep them in memory. On systems with thousands of users, run the report as a nightly background job.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the role name displays the role in PFCG.
  • Export to Excel
  • Runs as a background job
  • Send the result by email A summary can be sent to internal audit at each quarter end.

Authorization objects

  • S_USER_GRPDisplay authorization for user data by user group
  • S_USER_AGRDisplay authorization for roles and their content

Frequently asked questions

Who defines the rule set, and how?

Rules come from the internal control matrix and are kept in business terms in the maintenance screen delivered with the report: each rule has a name, A and B transaction lists and a risk level. Common purchasing, sales and finance conflicts are pre-filled at installation and the company adjusts them to its own matrix.

How do users with the SAP_ALL profile appear?

Users who carry SAP_ALL directly through UST04 produce a conflict for every rule. The report flags them separately at the top so they can be handled as one finding instead of hundreds of lines.

Are Fiori apps also checked on S/4HANA?

The report works on transaction codes and authorization object values, which also apply to the authorization checks behind Fiori apps. Catalog and group assignments can be added to the rule set through their transaction equivalents.

Packages that include this solution

BASIS Package Custom

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, …

6 components · v1.0

Related reports

BASIS Program Custom Background program

Automatic Lock of Inactive Users Program

A custom background program that first warns dialog users who have not logged on for a given period by email, locks them with an administrator lock …

USR02 · USR21 · ADR6 · AGR_USERS

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.

Related report: Segregation of Duties (SoD) Conflict Report by User