topic Re: Transaction or program for mysterious table... in Application Development and Automation Discussions

Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 09:51:00 GMT

Hello,

I have a table that is being populated when a transaction is executed. However, we don't know which trasaction or program that is. Is there a way to find how this table is being populated.

Many thanks in advance !

Edited by: Julius Bussche on Jan 8, 2010 9:50 PM

Please use meaningfull subject titles

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 09:54:59 GMT

Try to switch on the trace using transaction code ST05 and execute the transaction and go back to ST05 and switch off the trace and click on display trace to see the tables which are getting triggred while executing the transaction code.

Click on F1 help where you will able to see the data element and then where used list to check in which table this data element is use.

Regards

Srilaxmi

Edited by: Julius Bussche on Jan 8, 2010 9:53 PM

)%->05;-)

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 09:59:44 GMT

Do a Where used List on the program where u even inlcude the program in which the table is being used..

and find it..

BTW lemme know if its a custom or SAP tables

Re: Transaction or program for mysterious table...

kesavadas_thekkillath — Fri, 08 Jan 2010 10:02:20 GMT

Please use proper subjects for your questions.

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 10:03:14 GMT

Hi Shweta ,

Use Where Use list on table .

Some analysis will be required , to know the exact program/transaction.

Hope this helps you.

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 10:03:47 GMT

Thanks for your answer but we don't know the transaction itself. we are trying to find the txn using the table.

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 10:06:21 GMT

we did where used list but that didn't help. Yes, it is a custom table.

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 10:12:44 GMT

Shweta ,

Execute this report RS_ABAP_SOURCE_SCAN .

Put String searched for as your table name and execute.

This will give you program in which table is used.

Do analysis and where use list of program and get the T code.

Hope this helps you.

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 10:30:40 GMT

Hi Swetha,

Go to transaction SE11, give your table name and then look for 'where used' , In this you can select all the check box so that search area can be increased.

Hope this will help you.

Rani

Re: Transaction or program for mysterious table...

Clemenss — Fri, 08 Jan 2010 11:14:00 GMT

Hi swetha,

wnen you pouplate the table, put the values of sy-tcode and sy-repid into additional fields. You can also store sy-uname, sy-datum, sy-uzeit, sy-zonlo. Sy-zonlo is impotant if your users are distributed in different time zones.

Regards

Clemens

Re: Transaction or program for mysterious table...

Clemenss — Fri, 08 Jan 2010 11:18:15 GMT

Ooops, may that was a misunderstanding.

If you say you have table entries you don't know where they come from, you can create a background job that does noting but read the table say, every minute, and send an alert as soon as a suspicious entry has been written. If you do not have too many users active/jobs runnig at that time, you may find out where it comes from.

Regards,

Clemens

Re: Transaction or program for mysterious table...

Former Member — Fri, 08 Jan 2010 20:58:16 GMT

Another tip is to take a look in version management to see which other objects were transported together with the table, or based on the custom table name, take a look in the same package or namespace for programs and FM's.

Depending on the fields of the table, you can also try the where-used-list from transaction SE16N instead of SE11.

If worste-comes-worse then you will need to look for DB triggers...

Cheers,

Julius

Re: Transaction or program for mysterious table...

Former Member — Wed, 08 Sep 2010 01:57:55 GMT

done..