Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table

Former Member
0 Likes
1,213

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

Message was edited by: vikas gupta

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,166

are u talking abt HR module ?

check infotype 105

tables : PA0105.

Regards

Prabhu

7 REPLIES 7
Read only

Former Member
0 Likes
1,166

hi Vikas,

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

Regards,

Santosh

Read only

Former Member
0 Likes
1,167

are u talking abt HR module ?

check infotype 105

tables : PA0105.

Regards

Prabhu

Read only

Former Member
0 Likes
1,166

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

Read only

Former Member
0 Likes
1,166

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

Read only

Former Member
0 Likes
1,166

> 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

Read only

Former Member
0 Likes
1,166

Hi

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

Read only

Former Member
0 Likes
1,166

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-b27...

hope this helps,

regards,

keerthi.