topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Wed, 02 Aug 2006 12:09:26 GMT

Hello All,

Please let me know the table name where employee number as well as SAP useid is in the same table.

Table USR21 is not giving the correct result.

USRID in sap mainly like UPT2KOR.

But in the PA0105 it is like number not Alpha numaric text.

Regards

Vikas

Message was edited by: vikas gupta

Re: Table

Former Member — Wed, 02 Aug 2006 12:11:48 GMT

hi Vikas,

Look for all USR* tables ... it is in one of these tables only..

Regards,

Santosh

Re: Table

Former Member — Wed, 02 Aug 2006 12:11:55 GMT

are u talking abt HR module ?

check infotype 105

tables : PA0105.

Regards

Prabhu

Re: Table

Former Member — Wed, 02 Aug 2006 12:15:04 GMT

Its in PA infotype i.e PA0105 (Subtype 0001)

Re: Table

Former Member — Wed, 02 Aug 2006 12:17:52 GMT

Hi Vikas,

Use table pa0105:-

Set value of usrty = '0001'

to get the values of UsrID.

Hope this helps

Reward if helpful.

Regards

Sachin Dhingra

Re: Table

Former Member — Wed, 02 Aug 2006 12:47:50 GMT

> Hello All,

> Please let me know the table name where employee

> number as well as SAP useid is in the same table.

> Table USR21 is not giving the correct result.

> USRID in sap mainly like UPT2KOR.

> But in the PA0105 it is like number not Alpha numaric

> text.

> Regards

> Vikas

Message was edited by: vikas gupta

Re: Table

Former Member — Wed, 02 Aug 2006 13:48:10 GMT

The SAP user-id & employee-id are maintained in table <b>PA0105</b>.

Fields:

PERNR - Employee-id

USRID - SAP user-id for the employee.

The table will be populated only if the entries for the employee are maintained using the transaction PA30 for Infotype - 105 (or) communication

Hope this helps!

best regards,

Thangesh

Re: Table

Former Member — Wed, 02 Aug 2006 14:01:38 GMT

Hi vikas,

check the bapi

bapi_user_getlist

bapi_user_get_detail

also check the link:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/94c377c2-0701-0010-4992-b27dab0aece2

hope this helps,

regards,

keerthi.