Updated Tables

[Former Member]

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

[Former Member]

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?

[Former Member]

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.

[Former Member]

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

[Former Member]

HI

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

[Former Member]

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.