Table to find the userid detials

[Former Member]

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.

[Laxmana_Appana_]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Check the table.

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

Regards,

AS

[Former Member]

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.

[former_member628175]

Hi ,

Try USR01-USR05 tables . Stores all the user details

Thanks,

Shounak

[Former Member]

hi

try this table 'USR21'

with regards

chetan vishnoi