Skip to content

Instantly share code, notes, and snippets.

@js1972
Created June 20, 2017 05:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save js1972/5cf013a5af4943be148aeda5f23d326e to your computer and use it in GitHub Desktop.
Save js1972/5cf013a5af4943be148aeda5f23d326e to your computer and use it in GitHub Desktop.
Usage analysis of ABAP t-codes and programs
report ztcode.
parameters: month type dats default sy-datum obligatory,
user type usr02-bname obligatory default sy-uname.
types: begin of zusertcode,
operation type char30,
type type char10,
count type swncshcnt,
end of zusertcode.
types: tt_zusertcode type standard table of zusertcode with key operation type.
data: lt_usertcode type swnc_t_aggusertcode,
ls_result type zusertcode,
lt_result type tt_zusertcode.
constants: cv_tcode type char30 value 'Tcode',
cv_report type char30 value 'Report',
cv_count type char5 value 'Count'.
start-of-selection.
call function 'SWNC_COLLECTOR_GET_AGGREGATES'
exporting
component = 'TOTAL'
periodtype = 'M'
periodstrt = month
tables
usertcode = lt_usertcode
exceptions
no_data_found = 1
others = 2.
delete lt_usertcode where tasktype <> '01'.
loop at lt_usertcode assigning field-symbol(<user>) where account = user.
clear: ls_result.
ls_result-operation = <user>-entry_id.
ls_result-type = <user>-entry_id+72.
ls_result-count = <user>-count.
collect ls_result into lt_result.
endloop.
sort lt_result by count descending.
write: 10 cv_tcode, 20 cv_report, 60 cv_count color col_negative.
loop at lt_result assigning field-symbol(<result>).
if <result>-type = 'T'.
write: / <result>-operation color col_total under cv_tcode,
<result>-count color col_positive under cv_count.
else.
write: / <result>-operation color col_group under cv_report,
<result>-count color col_positive under cv_count.
endif.
endloop.
@kgorin8
Copy link

kgorin8 commented May 16, 2018

stealing. nice one

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment