Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Transaction or program for mysterious table...

Former Member
0 Likes
1,729

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,699

Hi

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;-)

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

12 REPLIES 12
Read only

Former Member
0 Likes
1,700

Hi

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;-)

Read only

0 Likes
1,699

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

Read only

0 Likes
1,699

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

Read only

0 Likes
1,699

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

Read only

0 Likes
1,699

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.

Read only

kesavadas_thekkillath
Active Contributor
0 Likes
1,699

Please use proper subjects for your questions.

Read only

Former Member
0 Likes
1,699

Hi Shweta ,

Use Where Use list on table .

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

Hope this helps you.

Read only

Former Member
0 Likes
1,699

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

Read only

Clemenss
Active Contributor
0 Likes
1,699

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

Read only

Clemenss
Active Contributor
0 Likes
1,699

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

Read only

Former Member
0 Likes
1,699

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

Read only

Former Member
0 Likes
1,699

done..