Report with tcodes utilization on per user & per date basis

ekekakos picture ekekakos · Nov 24, 2017 · Viewed 9.4k times · Source

We want to create a report with Select Criteria DATE & USER and we display the Transactions that run per user & per date.

I know the transaction ST03N but it does not extract the data as I want (DATE-USER-TCODES).

Does anyone know where to find these data, which tables?

Thanks in advance Elias

Answer

Suncatcher picture Suncatcher · Nov 24, 2017

Everything is in ST03N:

  1. Select target system from the list in the very top menu
  2. Expand the list of periods (day, month, total) and select the necessary leaf in the necessary node

enter image description here

  1. After double-click (important!) on that leaf the window will appear in the bottom-left corner. In that window one can choose the necessary stats. Here we need to select User and Settlement Statistics and User Profile below.
  2. After double-click on the necessary stat, windows in the right will be filled with data.
  3. Here we need to double-click again on the target user and all his tcodes on the selected date will be displayed in the popup.

enter image description here

P.S. If you miss User and Settlements Statistics node in your system, then some of the Performance Collectors are not set up properly on your system.