how to debug transaction posting to database?

[Abdelrahman-Elshafei]

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?

[RaymondGiuseppi]

Did you activate the debug in update task (*)

Regards,

Raymond

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

[Abdelrahman-Elshafei]

yes tried it and it shows me code that occurs after commiting and during the update task itself not the actual sql statements that caused the update

[Former Member]

Hi AAS,

    Let us know for which transaction you need the analysis, so that people can analyse and suggest some ideas.

Regards,

Surendra Gupta.

[Abdelrahman-Elshafei]

NL10N in the IS-H industry

[RaymondGiuseppi]

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.

[Peter_Inotai]

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

Peter

[Abdelrahman-Elshafei]

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