Application Development 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: 

SAP tables for SM66

Former Member
0 Kudos
1,214

Dear Gurus,

I am in the middle of developing a monitoring tools to monitor SM66 (total number of usage, status, error, time) and i need to know which tables i should use.

Please advise if you have an example query for me to use to build up this monitoring page.

The tools that i am using right now is UC4 and basically to call a SQL statement from the DB and do the processing in UC$.

Please help.

Best Regards

Muhamad Shukri

7 REPLIES 7

surajarafath
Contributor
0 Kudos
392

I think You can try with TRDIR TFDIR... but i think the table names will be dynamic..

imnt sure..you give a try.

0 Kudos
392

I have tried to look for the content in the table provided by you.

However, the component seems to be not complete and it is not the kind of information that i am looking for.

Is there any other tables that might relates to SM66? Eventhough its dynamic, i believe there must be a way to retrieve the information.

0 Kudos
392

I am not very sure what kind of information you required. may be try out this FM 'STUM_WP_TOTAL_ACTIVITY'.

0 Kudos
392

Thanks Playsuji for your fast reply.

However, i am not looking for ABAP FM. All i need is the table name that contains the information in SM66. Even it involves multiple table.

Regards

Muhamad Shukri

0 Kudos
392

I think every data what you need is based on the runtime, and i afraid it is not stored anywhere. It will be only available at run time. May be that FM will return current status. I am sorry i dont have any better news from me rather than this, may be some other person.

former_member214857
Contributor
0 Kudos
392

Hi Muhamad

You can use code below to collect Work Process information table

CALL FUNCTION 'TH_WPINFO'
      EXPORTING
           WITH_CPU              = WITH_CPU
      TABLES
           WPLIST                = WPLIST
      EXCEPTIONS
           SEND_ERROR            = 02.

Best regards

0 Kudos
392

Hi Carlos,

Thanks a lot.

Do you know any specific tables that contains the information?

Best Regards

Muhamad Shukri