topic TRANSACTION TABLE in Application Development and Automation Discussions

TRANSACTION TABLE

Former Member — Tue, 28 Mar 2006 23:16:25 GMT

Hello,

Do you know if there is a table that stores the transaction´s name that are running at the time?

Thanks

Gabriel P.

Re: TRANSACTION TABLE

RichHeilman — Tue, 28 Mar 2006 23:21:28 GMT

To get a rough idea, you can see what users are currently running using the transaction code SM04.

Regards,

rich Heilman

Re: TRANSACTION TABLE

Former Member — Tue, 28 Mar 2006 23:22:07 GMT

Hi,

We have a table called TSTC, which stores all the transactions.

Regards,

Sek s

Re: TRANSACTION TABLE

suresh_datti — Tue, 28 Mar 2006 23:22:39 GMT

or you can also use the TCode STAT to get the local Transaction statistics..

Regards,

Suresh Datti

Re: TRANSACTION TABLE

Former Member — Tue, 28 Mar 2006 23:24:45 GMT

Hello Rich,

I need to find what transactions are running, becuase I need to lock the tx in case is already running, I tryed with ENQUEUE AND DEQUEUE but it didn´t work. I need to lock tx MIRO.

Thanks,

Gabriel

Re: TRANSACTION TABLE

RichHeilman — Tue, 28 Mar 2006 23:32:15 GMT

SM04 uses a c function to get this data. Here is the logic. This may not be useful as it will not help when user has mulitple sessions.



report zrich_0001 .

data: begin of usr_tabl occurs 10.
        include structure uinfo.
data: end of usr_tabl.

data: th_opcode(1)                    type x.

constants: opcode_list                     like th_opcode value 2.

refresh usr_tabl.

call 'ThUsrInfo' id 'OPCODE' field opcode_list
  id 'TAB' field usr_tabl-*sys*.

sort usr_tabl by mandt bname.

loop at usr_tabl.

  write:/ usr_tabl-bname, usr_tabl-tcode.
endloop.

Regards,

Rich Heilman

Re: TRANSACTION TABLE

RichHeilman — Tue, 28 Mar 2006 23:35:35 GMT

Just wondering how you would lock a transaction if it is already running. The lock probably wouldn't take effect on the other session untill the user backs out and re-enters the transaction. You can lock transaction via SM01.

Regards,

Rich Heilman

Re: TRANSACTION TABLE

RichHeilman — Tue, 28 Mar 2006 23:38:52 GMT

Just tested it, if someone is already in the transaction, locking it will do no good untill they back out of the transaction and try to reenter.

Regards,

Rich Heilman

Re: TRANSACTION TABLE

Former Member — Wed, 29 Mar 2006 00:30:39 GMT

Hi Rich,

Thanks again for answering, the code you gave me worked, but you r rigth, if the user has several modes, it does´nt work right, I tryed to do it with TX you gave me, but I have no permission to access it, I guess a usual user either.

Do you know any other way to lock the acces to a transaction?

Thanks again,

Gabriel

Re: TRANSACTION TABLE

RichHeilman — Wed, 29 Mar 2006 01:50:28 GMT

Not a big fan of directly updating a database, as I don't someone in another post tonight not too, but in this case if you can't use the SM01, you can do the underlying code, essentially, this is what it is doing. Give it a try.



report zrich_0001 .


data: xtstc type tstc.

parameters: p_lock radiobutton group grp1,
            p_unlk radiobutton group grp1.

select single * from tstc into xtstc
               where tcode = 'MIRO'.
if p_lock = 'X'.
  xtstc-cinfo = '24'.    "Lock it
else.
  xtstc-cinfo = '04'.    "Unlock it
endif.
modify tstc from xtstc.

Regards,

Rich Heilman

Re: TRANSACTION TABLE

Former Member — Mon, 21 May 2007 18:03:18 GMT

Hi Rich,

My requirement is to retrieve all transaction from multiple sessions. Please

tell how to retrieve this.

Thanks.

With Regards,

Gandhi Subramani