Exporting ST03N Data from an SAP System

ST03N data will give you insight into your usage of SAP and help you understand which business processes to focus on

ST03N data will need to be exported from the production SAP system.
  1. Log on to your production SAP system(s).

  2. Execute transaction ST03N.

  3. In the Navigation tree, select Expert Mode.

  4. In the Expert Mode tree, select Workload > <Production SAP Server Name>.

    The Day, Week, and Month folders appear.

  5. Open the Month folder and double-click on the last full month.

    The Analysis Views tree window appears.

  6. In the Analysis Views tree, open the Transaction Profile branch.

  7. Double-click on the Standard sub-branch.

    The Transaction Profile screen appears.

  8. In the Times tab, click the Task Type button and select DIALOG.

  9. Click the All Data tab.

Notes:

ST03N has a limited time frame so some transactions that are rarely used but still important like period end closing transactions, etc. will also need to be extracted. 

In ST03N you can extend the retention data to max which is three months:

ST03N does not collect indirectly called transactions in custom code. This means if custom code uses a call transaction YXZA, the transaction YXZA is NOT recorded in ST03N. 

If you use a lot of Z transactions it would be advisable to also activate TCODE SCMON (ABAP Call Monitor) so you can also see these in ST03N.

If data is already gathered you can already use the results, or you can wait until the data collection time is completed for more accurate information. To display the data, start transaction SCMON and click the Display Data button:

Once you have the data you require you can then export it so it can be loaded into FusionGraph.

  1. Ensure that the description / short text column is visible so it’s clear what each item refers to.
  2. From the toolbar, click the Export  button and select Local file.

    A dialog box appears asking to select a format that you want the data to be saved.

  3. Select Spreadsheet and click the Continue  button.

    A dialog box appears.

  4. If you want to change the directory path, click the Directory Browse button and select the directory where you want to save the file.

  5. In the File Name field, type in a name for the file. The file extension must be .XLS.

  6. Click Generate.

    The file is saved to the selected directory.

Creating a Microsoft Excel spreadsheet:

After you have generated your file, you must convert it to a Microsoft Excel® spreadsheet. Even though the file has the .XLS extension, it is not an Excel spreadsheet. This file is actually a text file. The one remaining step is to convert this text file into an Excel spreadsheet.

To create a Microsoft Excel spreadsheet:

  1. Double-click on the ST03N file that you created.

    Microsoft Excel opens with a warning message.

  2. Click Yes.

  3. In Microsoft Excel, select File > Save As.

  4. Browse to the directory where you want to save the file.

  5. Save the updated file with an Excel Workbook (.XLSX) file extension.

  6. Click Save.

The ST03N file is now ready to be uploaded into FusionGraph.