topic Re: Table to find the userid detials in Application Development and Automation Discussions

Table to find the userid detials

Former Member — Tue, 25 Jul 2006 05:29:58 GMT

For the Request for Quotation we can find the userid who created it in EKKO-ERNAM, can u tell me how to find the user id detials like phone number and fax number etc. What is the table from which i can get these details for the phone number and fax details etc.

Re: Table to find the userid detials

Laxmana_Appana_ — Tue, 25 Jul 2006 05:32:07 GMT

Hi,

Check the table USR21 , from this table take address number , from ADR3 and ADR2 get fax and phone numbers using address number.

fields : TELNR_LONG, FAXNR_LONG

Ex:

select single *

from usr21

inner join adr3

on usr21_{addrnumber = adr3}addrnumber

and usr21_{persnumber = adr3}persnumber

where usr21~bname = EKKO-ERNAM

Regards

Appana

Re: Table to find the userid detials

Former Member — Tue, 25 Jul 2006 05:33:25 GMT

when u make po (me23n)in header there is a tab for that if u maintain it than it will come ..

just check from where it is store by clicking f1

Re: Table to find the userid detials

Former Member — Tue, 25 Jul 2006 05:34:01 GMT

hi Anitha,

use these table for infos about user

USR01 User master record (runtime data)

USR02 Logon Data (Kernel-Side Use)

USR03 User address data

USR04 User master authorizations

USR05 User Master Parameter ID

USR06 Additional Data per User

if u find it useful plz mark the points

Regards,

Naveen

Re: Table to find the userid detials

Former Member — Tue, 25 Jul 2006 05:35:01 GMT

Hi,

Check the table.


Transp. table      <b>EKAN</b>             Active                                     
Short Description  Vendor Address: Purchasing Document

Regards,

Re: Table to find the userid detials

Former Member — Tue, 25 Jul 2006 05:35:01 GMT

Hi Anitha,

You can see all the detail of user from table USR02 this the table from where you can find maximum records related to user as there:

BNAME is the User name in user master record.

Regaerd.

Ankur Garg.

Re: Table to find the userid detials

former_member628175 — Tue, 25 Jul 2006 05:35:55 GMT

Hi ,

Try USR01-USR05 tables . Stores all the user details

Thanks,

Shounak

Re: Table to find the userid detials

Former Member — Tue, 25 Jul 2006 05:39:36 GMT

try this table 'USR21'

with regards

chetan vishnoi