topic Re: TCODE-TABLE relationship(only insert/modify/update/delete) in Application Development and Automation Discussions

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

Former Member — Tue, 14 Sep 2010 09:05:07 GMT

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

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

SuhaSaha — Tue, 14 Sep 2010 09:09:35 GMT

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

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

Former Member — Tue, 14 Sep 2010 09:53:12 GMT

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

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

JerryWang — Wed, 15 Sep 2010 06:48:58 GMT

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

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

Former Member — Wed, 15 Sep 2010 07:00:35 GMT

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

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

andrea_olivieri — Wed, 15 Sep 2010 07:16:45 GMT

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

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

Former Member — Fri, 01 Oct 2010 05:58:25 GMT

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

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

Former Member — Fri, 12 Nov 2010 07:49:20 GMT

Requirement Dropped