Friday, December 28, 2007

SAP helpful reports, transactions and tables

Reports and Programs

· RTTREE_MIGRATION: Conversion of Report Trees to Area Menus

· PFCG_TIME_DEPENDENCY: user master comparison (background)

· RSUSR* reports (use SE38 and do a possible-values list for RSUSR* to see all available security reports), including:

v RSUSR002 – display users according to complex search criteria

v RSUSR010 – Transactions that can be executed by users, with Profile or Authorization

v RSUSR070 – Activity groups by complex search criteria

v RSUSR100 – Changes made to user masters

v RSUSR101 – Changes made to Profiles

v RSUSR102 – Changes made to Authorizations

v RSUSR200 – Users according to logon date and password change, locked users.

Transactions

· SUIM : various handy reports

· SU10 : Mass user changes

· PFCG: Profile Generator

· PFUD: User master comparison

· SU01: User master maintenance

· ST01: System trace

· ST22: ABAP dumps

· SUCU / SE54: Maintain authorization groups for tables / views

· PPOMW: Enjoy transaction to maintain the HR organizational plan

· PO10: Expert maintenance of Organizational Units and related relationships

· PO13: Expert maintenance of Positions and related relationships

· STAT: System statistics, including which tcodes are being used by which users

Tables

Table

Use

UST12

Authorizations and Tcodes per Profile

UST04

Assignment of users to Profiles

AGR_USERS

Assignment of roles to users

USOBT_C

Authorizations associated with a transaction

USR02

Last logon date, locked ID’s

AGR_TCODES

Assignment of roles to Tcodes (4.6 tcodes)

USH02

Change history for users (e.g. who last changed users via SU01)

USH04

Display history of who made changes to which User Ids

USR40

Non-permitted passwords

USR41

Users with logon information (multiple

No comments:

Blog Archive