topic Database Table for all users in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447909#M1413288 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have made a report where in I want to check the performance of one of my FM which has an importing parameter as user_id.</P><P></P><P>I want to run this report for all the SAP user_id. Which database table should I refer to perform the 'select' quiry to get all SAP user ids.?</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Varun.</P></BODY></HTML> Mon, 23 Nov 2009 07:55:29 GMT Former Member 2009-11-23T07:55:29Z Database Table for all users https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447909#M1413288 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have made a report where in I want to check the performance of one of my FM which has an importing parameter as user_id.</P><P></P><P>I want to run this report for all the SAP user_id. Which database table should I refer to perform the 'select' quiry to get all SAP user ids.?</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Varun.</P></BODY></HTML> Mon, 23 Nov 2009 07:55:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447909#M1413288 Former Member 2009-11-23T07:55:29Z Re: Database Table for all users https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447910#M1413289 <HTML><HEAD></HEAD><BODY><P>USR02...</P></BODY></HTML> Mon, 23 Nov 2009 07:57:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447910#M1413289 Former Member 2009-11-23T07:57:35Z Re: Database Table for all users https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447911#M1413290 <HTML><HEAD></HEAD><BODY><P>Thanks..</P></BODY></HTML> Mon, 23 Nov 2009 08:00:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447911#M1413290 Former Member 2009-11-23T08:00:21Z Re: Database Table for all users https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447912#M1413291 <HTML><HEAD></HEAD><BODY><P>Double-click on the parameter definition, you will find a data-element and then the domain XUBNAME which has a value table USR02.</P><P></P><P>Regards,</P><P>Raymond</P></BODY></HTML> Mon, 23 Nov 2009 08:01:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447912#M1413291 RaymondGiuseppi 2009-11-23T08:01:02Z Re: Database Table for all users https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447913#M1413292 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks for the table name.</P><P></P><P>I have a doubt here. I performed SELECT * (without any condition)on USR02 and it returned 98423 entries.But isn't all SAP user ids (globally) is much more than this number?</P><P>Did I miss something?</P><P></P><P>Kindly guide.</P><P></P><P>Thanks,</P><P>Varun.</P></BODY></HTML> Mon, 23 Nov 2009 08:12:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table-for-all-users/m-p/6447913#M1413292 Former Member 2009-11-23T08:12:07Z