topic Re: Updated Tables in Application Development and Automation Discussions

Updated Tables

Former Member — Tue, 12 Feb 2008 12:01:22 GMT

Assume that 1 record is inserted in a Table.......

How to find out all the updated tables related to that record.......

reward points will be there if it is useful........

regards

Ganesh Reddy

Re: Updated Tables

Former Member — Tue, 12 Feb 2008 12:07:16 GMT

impossible to that...

just identify the transaction throught that record has been uploaded..

then u after entering saving the record...

switch on to the debugging mode...

this is one way to find out the relevant tables...

once u know the table names,

then note down the key fields for the inserted record,

by fetching records for the key fields, u can find out what u actually need...

tk?

Re: Updated Tables

Former Member — Tue, 12 Feb 2008 12:10:42 GMT

Hi Ganesh Reddy,

It is possible but some difficult easiest way is use SQL Trace ( Tcode is *ST05 ) When you update your record.

Plzz reward if it is useful,

Mahi.

Re: Updated Tables

Former Member — Tue, 12 Feb 2008 12:14:25 GMT

Hi,

Better to go for SQL Trace to find out the changes done to all the tables when you update a record.

For more information on SQL Trace go thro the below blog

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

Regards,

Chandru

Re: Updated Tables

Former Member — Tue, 12 Feb 2008 12:17:31 GMT

GANESH

THIS IS CONCEPT OF ARCHIVEING CONCEPT

T.CODE : SARA

ENTER BOJECT NAME LIKE SD_VBAK

AND PRESS DATABASE TABLES

WE CAN GET TABLES FROM WHICH DATA IS ARCHIVED

LIKE VBAK

VBAP

VBEP ETC

PLZ REWARD POINTS IF USEFUL

REGARDS

HEMASEKHARA REDDY S

Re: Updated Tables

Former Member — Tue, 12 Feb 2008 12:18:11 GMT

Hi,

You can do that by going to tcode ST05.

Select the check box "QL TRACE ".

Then Click "ACTIVATE TRACE".

Then run your program.

Then come back to ST05.

Click " DEACTIVATE TRACE".

Then click "DISPLAY TRACE".

It will give you a thorough analysis of all your select query and other SQL statements. and inturn you will be able to find the various tables updated as well.

Reward if helpful.

Regards.