TCODE-TABLE relationship(only insert/modify/update/delete)

[Former Member]

Hi,

I would like to know whether a particular transaction(tcode) is updating/modifying which underlying tables. Is it possible?

Here i would be intesrested only in those tables which are getting insert/modify/update/delete states.

I have found one table D010TAB, but this includes all the tables related to a program, it wont give tables which are getting(INSERT/MODIFY/UPDATE/DELETE) states.

Regards

Munish Garg

[SuhaSaha]

Don't think there is any standard SAP tool available for this purpose.

[Former Member]

Check ST05, log activating the SQL trace. you find all the tables acessed/modified in Object name column.

[JerryWang]

Hello friend,

you can use tcode SE30. After you enter SE30 ,nput your transaction code in "In dialog" tab, click execute button, and then run your transaction as usual.Ater your transaction ends, it will return to SE30 automatically. Click tab "DB tables", then all table which are involved in your current transaction is listed here. Enjoy SE30

Best Regards,

Jerry

[Former Member]

hi,

i agree with shital phadake if you activate the SQL trace and then execute the program and then view the trace.

it would tell you al the details that at which point the database is being hit and what all tables are being updated.

wheter insert/update/modify...............

Regards,

Sakshi

[andrea_olivieri]

Hi,

You might consider the Internal Environment Program analysis .

First of all take the program name from the transaction you need to analyze (This could be done using the SE93 tcode).

After that, goto the SE38 transaction and enter the program name.

From the menu choose: Utilities> Internal Environment Program.

Tick the Update / Modify / Delete checkboxes in the Database Operations Frame and press Enter.

Regards,

Andrea

[Former Member]

HI,

Thanks for responses, as it was low priority earlier so i checked your messages now.

I read the support given by you, about activating SQL TRACE, i cannot do that. About "internal Program environment' link in 'Utilities' tab doesn't give me correct info. I have checked for MM01 and VA01.

I have to make a generic program which can fetch this information for any transaction so every time i cannot run each and every transaction. I have recording info of transaction, that is what fields user has touched. But as you all know in recording, not necessarily all the fields are from table, for e.g. for material master(MM01/MM02/MM03), matnr refers to RMMG1-MATNR not mara-matnr. So i dont know how can i fetch the info of tables which includes MARA. I tried doing through data element level but it gives me too many tables because MATNR as a data elements refers to too may tables.

I hope you are clear about my requirement now.

Regards

Munish Garg

[Former Member]

Requirement Dropped