SAP tables for SM66

[Former Member]

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

[surajarafath]

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

imnt sure..you give a try.

[Former Member]

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.

[surajarafath]

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

[Former Member]

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

[surajarafath]

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]

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

[Former Member]

Hi Carlos,

Thanks a lot.

Do you know any specific tables that contains the information?

Best Regards

Muhamad Shukri