Skip to Content
avatar image
Former Member

List of modified tables for a given Transaction

Hi Experts,

My Req : I need to get the list of tables which are modified/updated when I give the transaction code.

I have tried using RS_PROGRAM_TABLES. But it is giving run time error for some Tcodes saying lines exceeding 72 characters. I have nearly 2000 Tcodes for which the updated table names to be identified. I have tried ST05. But my client needs only the table name for all the Tcodes as we get output in RS_PROGRAM_TABLES.

Is there any other alternative to find this? Kindly help me.

Add comment
10|10000 characters needed characters exceeded

  • I share Jelena's view, this is not a realistic requirement nor will you get much meaningful (or even accurate) info out of such an analysis.

    Tell us what you actually need this info for, I am 99% certain that there is a better way than what you're asking here.

  • Get RSS Feed

2 Answers

  • Oct 05, 2017 at 07:14 PM

    The answer is 42. Seriously, you were given a practically impossible (and completely useless IMHO) task. For example, how would one even answer "what tables are updated by VA01?" Sure, there is VBAK/VBAP but what if there is a text added? Or VC? Or it's a third party scenario? There are tons of variations.

    What exactly is the purpose of this exercise?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 05, 2017 at 08:11 PM

    I suggest a system approach rather than a code analysis approach.

    Use transaction ST05 to activate the "SQL Trace". Run a full set of data manipulation operations in the transaction of interest. Go back to ST05 and Deactivate & then Display the trace results.

    All database tables that were modified by your actions will show up as INSERT/MODIFY/UPDATE commands in the trace.

    There may be some issues with UPDATE TASK processing outside the scope of this trace. In general, this will work.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      If I had to do this, I would try same way as Juan.

      But keep in mind that you can't anticipate dynamic update. For example in HCM programs, infotypes (tables PA*) are updated dynamically in chains depending on customizing. For example, if I call some methods / function module to update infotype '0424' (table PA0424) it will update too infotype '0080' (PA0080) and '2001' (PA2001) dynamically.

      Best regards