topic Table update in Application Development and Automation Discussions

Table update

anand_n5 — Wed, 11 Mar 2015 11:51:23 GMT

Hi all

I need help in finding the table update am executing rfc after which some table are updated based on the functionality of the RFC now the issue is am not able to find out which table got updated and what are the values got updated into the table somehow am able to find the tables based on the rfc functionality but don't know exactly which table got updated if updated how can i check when it got updated please help with this am totally stuck,

i tried with setting up change log but couldn't able to set it is there any other way through which i can find out exactly which table got updated and when .

thanks in advance
Anand

Re: Table update

Former Member — Wed, 11 Mar 2015 12:25:06 GMT

Hi Anand

You can use an SQL Trace. Try transaction ST05 to activate the trace, then run the RFC. Then analyse the update results.

Regards

Arden

Re: Table update

former_member183073 — Wed, 11 Mar 2015 12:26:58 GMT

Hi Anand,

you can use ST05 and check RFC and SQL Trace.

Re: Table update

Former Member — Wed, 11 Mar 2015 12:31:58 GMT

Start St05 trace buffer before executing you RFC and deactivate after it. Check the Trace log .

You'l definitely find which tables are updated in the log.

Re: Table update

anand_n5 — Thu, 12 Mar 2015 06:21:21 GMT

I got ur point i checked through the SQL trace i got a list but it's bit messy how can i identify the updated tables in the list there are number of tables.

Thanks In Advance

Anand

Re: Table update

Former Member — Thu, 12 Mar 2015 06:50:48 GMT

Hi Anand

In the "Statement" Column, search for Insert and Update Statements.

The volume of output from the trace is unfortunately verbose, as you gain more experience working with it, you'll find it easier to identify the information of more relevance.

Regards

Arden

Re: Table update

anand_n5 — Fri, 27 Mar 2015 11:02:06 GMT

thanks for the information Arden,

I checked through the statement wise like update and insert but i couldn't find any values, is there any way through which we can debug the code and can check which are the tables got updated because the problem here is some tables are not defined in the source code but in background they are getting updated how can i find out this updated tables please help me with this issue.May be am not good debugging could you please help me suggesting any good steps for debugging apart from usual debugging steps and rules.

Re: Table update

Former Member — Fri, 27 Mar 2015 22:43:54 GMT

Hi Anand

Have you had any luck running the ST05 Trace.

It is a great tool for the issue you are encountering.

Regards

Arden

Re: Table update

Former Member — Sat, 28 Mar 2015 18:13:23 GMT

Hello Mr. Anand a,

You can check ST05 to activate the trace, then run the RFC. Then analyze the result.

Regards

Niloy