Tip of the Month


How to know which data base tables have been accessed while running system report, e.g. balance sheet or Profit & Loss statement?

During User Acceptance tests or tests of newly developed reports for your business analysis (e.g balance sheet or Profit & Loss statement) you need to check the correctness of your report results before using them for your real company business. In some cases you are facing errors which you need to solve where they are coming from. For example you need to check where the data had been extracted from, i.e. from which data base table they originate. In our “Tip of the month” Chen Changqing (Westernacher Consulting China) describes a simple way to check the origin of the report data.

1Start system report, MMBE as example

2Open other window, start transaction ST05

3Click on ”Activate Trace” button, an activation message pops up

4Execute the report, wait until the result screen

5Back to ST05 session, click on “Deactivate Trace” to stop tracing

6Click on”Display Trace” button to display the trace (just “confirm” on the popup screen for selection filter)

7Analyze the trace report. “Obj. name” column lists the system data tables which have been read from or written into. “Statement” column lists the parameters which have been used.