transaction analizer

[Former Member]

hi all

Is there is any trick to know which tables are update at the standard transaction run and after make changes, means u run transaction ME21 then which tables are updated.

Thanks in advance

Manish

[Former Member]

hi all

Is there is any trick to know which tables are update at the standard transaction run and after make changes, means u run transaction ME21 then which tables are updated.

Thanks in advance

Manish

[Former Member]

Use Transaction SE 49.

[Former Member]

Its not going to be easy, but ST05 (Switch on the trace) and see what are the tables being access / updated.

Any specific reason?

Regards,

Ravi

Note : Please mark all the helpful answers

[Former Member]

Hi Manish ,

for PO u can check EK* in se11.

or search in program for COMMIT work there u will come to know.

Regards

Prabhu

[Former Member]

hi

u can use transaction SE49.

enter the name of ur transaction and then display.

Naveen

[Former Member]

hi manish,

u can use txn SE49 , for analizing ur transaction, program, function group, dialog module also ,

hope it will help u

chetan vishnoi

[Former Member]

hi.

If you know standard transaction or program for purchase order or for any function . you can know the affected tables by that transaction or program USING TRANSACTION

'SE49'.

I am working on 4.6c it does exist in this version.

if does not exist on ur version

then other way to find affected tables by a transaction or program is--

first find the development class for that transaction (like Va01) then goto se80 and enter that development class .it will show all the tables affected .

steps to find Development class for example (Va01).

press F1 to any field then click on tech. info

(ii) double click on program name(SAPMV45B).

(iii) click on object directory entry in GOTO menu.

(iv) from here u will get Development class (VA).

now in se80 u will get all the databasec tables under the node object entry.

hope this will help.

Regards .

vikas

[Former Member]

Hi,

Go to transaction ST05 and activate the SQL trace and run the required transaction. Again go to ST05 transaction, deactivate the trace and now you can look in to the details which tables are accessed.

Regs,

Venkat Ramanan N