topic Re: DATA STORE in Application Development and Automation Discussions

DATA STORE

Former Member — Tue, 19 Jan 2010 06:15:50 GMT

Dear All,

I have one query for sm04.I want to know that in sm04,we can see no. of users logged in sap..Now in which table dynamically it will store.when i generate any report i want to dispaly that no of users login.

Regards

shivam.

Re: DATA STORE

Former Member — Tue, 19 Jan 2010 14:55:45 GMT

See program RSM04000_ALV --- form build_list.

Re: DATA STORE

Former Member — Tue, 19 Jan 2010 16:01:26 GMT

Hi Shivam ,

You can use trace ST05 and get the database tables from which records are fetched.

Switch on trace before execution of SM04 and check the DB table list.

Hope this helps you.

Re: DATA STORE

Former Member — Tue, 19 Jan 2010 18:02:08 GMT

Hi Shivam,

You can use Fm TH_USER_LIST to get the list of users currently logged in.

one more alternative,

report abc.

data : uinfo type table of UINFO2 with header line.

data : uniqueusers type table of uinfo2 with header line.

CALL FUNCTION 'TH_LONG_USR_INFO'

EXPORTING

USER = '*'

TABLES

USER_INFO = uinfo.

loop at uinfo.

uniqueusers-user = uinfo-user.

collect uniqueusers.

endloop.

describe table uniqueusers.

write 😕 sy-tfill.

Hope it helps you,

Regards,

Abhijit G. Borkar

Re: DATA STORE

kesavadas_thekkillath — Tue, 19 Jan 2010 18:19:11 GMT

REPORT ZUSERLIST .

Parameters: pa_server like MSXXLIST-NAME.

Data: it_list type table of UINFO .

data:wa type uinfo.

CALL FUNCTION 'TH_USER_LIST'

EXPORTING

APSERVER = pa_server

TABLES

LIST = it_list.

Loop at int_list into wa.

write: wa-BNAME.

ENDLOOP.