topic Re: Can i call module pool program list to memory in Application Development and Automation Discussions

Can i call module pool program list to memory

Former Member — Sun, 28 Oct 2007 10:37:04 GMT

Hi friends,

can can one tell me how to call a module pool prgram and pass its list to memory,

Thanks in advance,

Re: Can i call module pool program list to memory

former_member195698 — Sun, 28 Oct 2007 10:40:50 GMT

Hi,

A module pool program is not used for Reporting purpose. A module pool program is used for Updating data. For reporting purpose we use program of type 'executable' (Report program)

Regards,

Abhishek

Re: Can i call module pool program list to memory

Former Member — Sun, 28 Oct 2007 10:48:24 GMT

In my requirement i have to get the data from module pool program : TCODE : SM20N : this tcode shows user logon history data, which i have to capture in my program, iam not able to find the user logon history data in any of the tables so i want to call this TCODE and bring the data to my program for further processing of the data.

Please let me know your valuable suggestions ,

Thanks,

Re: Can i call module pool program list to memory

Former Member — Sun, 28 Oct 2007 10:56:04 GMT

Have you checked the tables

USR02, USR03 and USR01 correctly for the user Logon details data

check it once again all the fields

What exact fields do you require?

You can also use the BAPI/fun module

BAPI_USER_GET_DETAIL

Regards

Anji

Re: Can i call module pool program list to memory

Former Member — Sun, 28 Oct 2007 11:06:37 GMT

BAPI_USER_GET_DETAIL

This function module gives the details of user : but it is not giving the pervious user lonon date and time details : like date time and how many times he logged on in single day with terminals,

the tables usr02,usr03,USH02,USR41 Etc

All this table does not show how many times a user logged in a single day with terminals

Please let me know as soon as possible :

Re: Can i call module pool program list to memory

former_member195698 — Sun, 28 Oct 2007 11:22:05 GMT

What you can do is to Run the transaction with SQL Trace on. (Using ST05).

Then run the Transaction and check the trace list for the SQL Trace.

Check the Details in the Trace, it will list the tables which are hit during the run of the transaction. Check the details of the tables and the data in the tables.

In this way you will be able to find the required table.

Running the Transaction through SE30 also, you can get the details of the tables and the FM's that are called.

You might be able to get even the required FM also.

Reward points if useful

Regards,

Abhishek

Message was edited by:

Abhishek Jolly

Re: Can i call module pool program list to memory

Former Member — Sun, 28 Oct 2007 11:27:29 GMT

i have done the same but could not able to find the table.

Thanks, please let me know if have some suggestion

Re: Can i call module pool program list to memory

Former Member — Sun, 28 Oct 2007 12:09:08 GMT

Hi Madhu,

Check the transaction

SUIM

it will all the details by user/Tcode/time etc

or you have to check the fun modules

SAPWL_WORKLOAD_GET_STATISTIC

SAPWL_STATREC_READ_FILE

they will give the user wise details/hits to a tcode/program etc

Reward if useful

Anji

Re: Can i call module pool program list to memory

Former Member — Thu, 01 Nov 2007 15:52:05 GMT

can any tell me FSV node results

Thanks in advance