useful transaction
TRANSCRIPT
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 1/8
System Administration Made Easy A –1
$SSHQGL[$8VHIXO7UDQVDFWLRQV
&RQWHQWV
Useful Transactions............................................................................................... A –2
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 2/8
Appendix A: Useful Transactions
Useful Transactions
Release 4.6A/BA –2
8VHIXO7UDQVDFWLRQV
System ad ministrators may find the following transactions useful. Although man y of the
transactions are n ot discussed in this guid ebook, we are listing them for your convenience.
Many of these transactions are for more “ad vanced” fun ctions than targeted in the scope of
this guidebook.
7UDQVDFWLRQ&RGH6ZLWFKHV
/n<trans code> /nspad Exit the current transaction and
start the new tr ansaction
/o<trans code> /ospad Open a new session (window) and
start the new tr ansaction
7UDQVDFWLRQ&RGH7DEOHThe following are d efinitions of two of the column headers.
< Dangerous
These transactions are p otentially dam aging or fatal to the system if executed
incorrectly.
As a general ru le, most of the Basis transactions are potentially dam aging. Access to
these transactions shou ld be restricted in a ll systems. Access to some of these
transactions should be even further restricted in the produ ction system.
< Performance Impact
These transactions could h ave a p otentially adverse imp act to system p erformance if
executed . Traces and table display are th e transactions of concern here.
The problem with a table display occurs wh en the qu ery does a “full table scan” for d ata.
When d one on a large table, this query h as serious imp act on performan ce because the
system searches every record in the table to find th ose that meet th e search criteria.
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 3/8
Appendix A: Useful Transactions
Useful Transactions
System Administration Made EasyA –3
Transaction Description Dangerous Performanceimpact
AL02 Database Alert Monitor
(not supp orted for MS SQL Svr 7.0)
AL03 Operating System Alert Monitor
AL05 Workload Alert Monitor
AL08 Curren t active user s (in system)
AL11 Display operating system file from CCMS
AL12 Display table buffer (buffer synchronization )
BALE ALE adm inistration and mon itoring
DB01 Exclusive waits in Oracle database
DB02 Database performan ce; tables and index
DB03 Param eter changes in database
DB05 Ana lysis of table with resp ect to ind exed fields
DB12 Backu p logs
DB13 DBA plan ning calendar
DB14 DBA logs
DB20 Generate table statistics
OSS1 Online Service System logon
RZ01 Graph ical background job sched uling mon itor
RZ02 Netw ork grap hical display of instance
RZ03 Server status, alerts, maintain operations mod e
RZ04 Maintain operations mod e and instance
RZ06 Mainta in alert threshold
RZ08 CCMS Alert Monitor
RZ10 Mainta in system profiles X
RZ11 Display profile parameter attributes
RZ20 Alert Monitor 4.0
RZ21 Mainta in settings for Alert Monitor 4.0
SA38 ABAP reporting
SCAM CATT man agement
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 4/8
Appendix A: Useful Transactions
Useful Transactions
Release 4.6A/BA –4
Transaction Description Dangerous Performanceimpact
SCAT Comp uter Aided Test Tool
SCC1 Client copy tran spor t X
SCC3 Client copy log
SCC4 Client copy adm inistration X
SCC5 Delete clients X
SCC6 Client imp ort X
SCC7 Client imp ort – post processing
SCC8 Client export
SCC9 Remote client copy X
SCCL Local client copy X
SCMP Table comp arison
SCU3 Table history
SE01 Transp ort organ izer
SE03 Workbench organ izer: tools
SE06 Set up workben ch organ izer
SE09 Workbench organ izer
SE10 Customizing organ izerSE11 Data Dictionary maintenance X
SE12 Data Dictionary d isplay
SE14 Utilities for ABAP Dictionary tables X
SE15 Repository Info System
SE16 Display table content X X
SE17 Genera l table disp lay X
SE38 ABAP ed itor X
SECR Audit Information System
SEU R/ 3 Repository Browser
SFT2 Mainta in pu blic holiday calendar
SFT3 Mainta in factory calenda r
SICK Installation check
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 5/8
Appendix A: Useful Transactions
Useful Transactions
System Administration Made EasyA –5
Transaction Description Dangerous Performanceimpact
SM01 Lock tran sactions X
SM02 System messages
SM04 Overview of users
SM12 Database locks X
SM13 Upd ate terminates X
SM18 Secur ity Audit: Delete Old Audit Logs
SM19 Secur ity Audit: Ad minister Audit Profile (for
SM20)
SM20 System (Security) Audit Log
SM21 System log
SM30 Mainta in tables (not all tables can use SM30) X
SM31 Maintain tables X
SM35 Batch input mon itoring
SM36 Sched ule backgrou nd jobs
SM37 Overview of background jobs
SM39 Job analysis
SM49 External operating system comman ds, execute
(see related SM69)
SM50 Work process overv iew
SM51 Instance overv iew
SM56 Reset or check nu mber ran ge buffer X
SM58 Error log for asynchronou s RFC
SM59 RFC connection, ma intain
SM63 Opera tions mod e, maintain
SM64 Event trigger
SM65 Backgrou nd processing analysis tool
SM66 Global work process overv iew
SM69 External operating system comman ds, maintain
(see related SM49)
SMLG Maintain logon group s
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 6/8
Appendix A: Useful Transactions
Useful Transactions
Release 4.6A/BA –6
Transaction Description Dangerous Performanceimpact
SMX Display own jobs
SNRO Maintain nu mber range objects X
SP00 Spool
SP01 Spool control
SP02 Display outp ut requests
SP11 TemSe (temp orary sequential objects) contents
SP12 TemSe ad min istration
SPAD Spool ad ministration (printer setup)
SPAM SAP Patch Manager
SPAU Intersection SAP transp ort/ customer
modifications
SPCC Spool; consistency check
SPDD Intersection SAP transp ort/ customer
mod ifications, DDIC
SPIC Spool; installation check
ST01 SAP system trace X
ST02 Buffer stat istics
ST03 Workload analysis
ST04 Database per formance ana lysis
ST05 SQL trace X
ST06 Op erating system mon itor
ST07 Ap plication mon itor
ST08 Network mon itor
ST09 Network Alert mon itor
ST10 Table call stat istics – statistics on table accesses
ST11 Display dev eloper trace X
ST12 Ap plication mon itor
ST14 Application ana lysis – statistics related to business
document volum e
ST22 ABAP dum p ana lysis
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 7/8
Appendix A: Useful Transactions
Useful Transactions
System Administration Made EasyA –7
Transaction Description Dangerous Performanceimpact
ST4A Oracle: analyze the shared cursor cache
STAT Local tran saction statistics
STMS Transport Managem ent System X
STUN Performance monitoring men u
STZAC Customizing Time Zones
SU01 User ma intenance X
SU01D Display users
SU02 Mainta in au thor ization profiles X
SU03 Maintain auth orizations X
SU10 Mass chang e to user record s X
SU12 Delete ALL Users X
SU2 Maintain user parameters
SU22 Au thor ization object check in tran sactions
SU3 Maintain own user parameters
SU53 Display auth orization checked values
TU02 Param eter changes – display active pa rameters
and history of changes
7/31/2019 Useful Transaction
http://slidepdf.com/reader/full/useful-transaction 8/8
Appendix A: Useful Transactions
Useful Transactions
Release 4.6A/BA –8