Table update

[anand_n5]

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

[Former Member]

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

[former_member183073]

Hi Anand,

you can use ST05 and check RFC and SQL Trace.

[Former Member]

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.

[anand_n5]

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

[Former Member]

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

[anand_n5]

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.

[Former Member]

Hi Anand

Have you  had any luck running the ST05 Trace.

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

Regards

Arden

[Former Member]

Hello Mr. Anand a,

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

Regards

Niloy