Skip to Content

how to debug transaction posting to database?

Hi,

   I have a requirement to find where in a transaction the data is actually reflected into the database, ideally i need to find the insert/update statements that update the db table after all the processing is done, i have tried to breakpoint at statement insert dbtab or update dbtab and got nothing, i also tried the debugger scripts that should stop at change of db table and got nothing as well, is there any way i can find the part of code that actually does the updating in the database?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 02, 2015 at 12:28 PM

    Did you activate the debug in update task (*)

    Regards,

    Raymond

    (*) ABAP Test and Analysis Tools : Debugger, New ABAP Debugger, Settings.

    Add comment
    10|10000 characters needed characters exceeded

    • during the update task itself not the actual sql statements

      very strange, usually database update are processed during execution of some update task FM, are you sure, if yes provide more information.

  • Nov 02, 2015 at 12:53 PM

    You might try to activate SQL trace with ST05 and check where DB access is done.

    Peter

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2015 at 01:45 PM

    Thank you guys i was able to find the function by causing the update work process to crash by terminating the debugger during the update process and then checking tcode SM14 which contains info about the crashed update processes including the update function module that was executing

    Add comment
    10|10000 characters needed characters exceeded