Consultor Sap Basis

Steps Required for Sap-Auditing

1. List the SAP Users which have not done login since last month.
2. Copy User’s Profile & roles which are to be deleted.
3. Delete Users which have notlogin above month
4. With the help of RZ10 change parameter to stop multiple login
5. With se16 User table usr41_mld for getting highest peak & counter.
6. Save above file in your localPC.
7. With the help below Zprogram we can remove exceeds counter & peak
As below
*&---------------------------------------------------------------------*
*& Report ZTMP_SU41*
*& *
*&---------------------------------------------------------------------*
*&*
*& **&---------------------------------------------------------------------*

report ztmp_su41
message-id z0.
tables :usr41_mld.
data : begin of itab occurs 0,
bname like usr41_mld-bname,
cal_year like usr41_mld-cal_year,
peak likeusr41_mld-peak ,
counter like usr41_mld-counter,
first_date like usr41_mld-first_date,
first_time like usr41_mld-first_time,
last_date like usr41_mld-last_date,
last_time likeusr41_mld-first_time,
peak_date like usr41_mld-peak_date,
peak_time like usr41_mld-first_time,
end of itab.
call function 'UPLOAD'
exporting
* CODEPAGE = ''
filename = 'C:\USR41_MLD.TXT'
filetype = 'DAT'
* HEADLEN = ' '
* LINE_EXIT = ' '
* TRUNCLEN= ' '
* USER_FORM = ' '
* USER_PROG = ' '
* DAT_D_FORMAT = ' '
* IMPORTING
* FILELENGTH =...