topic Re: User ID in Application Development and Automation Discussions

User ID

Former Member — Wed, 03 May 2006 10:29:50 GMT

Hi,

Is there any way by which you can get the user id from the country code?

I tried in SU01 but was unsuccessful.

Please provide a method by which I could get the user id for a specific country code?

Regards,

Gayathri

Former Member — Wed, 03 May 2006 10:36:28 GMT

Check out the table USR05,USR02.

MAY BE IT IS USEFUL FOR U....

Former Member — Wed, 03 May 2006 10:37:49 GMT

Try to use the BAPI BAPI_USER_GET_DETAIL

Anyway the address data should be in ADRC table, you can find the ID address in USR21 table:

So:

DATA T_ID_ADDRESS LIKE STANDARD TABLE OF USR21 WITH HEADER LINE.

DATA: T_ADRC LIKE STANDARD TABLE OF ADRC.

SELECT * FROM USER21 INTO TABLE T_ID_ADDRESS.

IF SY-SUBRC = 0.

SELECT * FROM ADRC INTO TABLE T_ADRC

FOR ALL ENTRIES IN T_ID_ADDRESS

WHERE ADDRNUMBER = T_ID_ADDRESS-ADDRNUMBER

AND COUNTRY = <LAND>.

LOOP AT T_ID_ADDRESS.

READ TABLE T_ADRC TRANSPORTING NO FIELDS

WITH KEY ADDRNUMBER = T_ID_ADDRESS-ADDRNUMBER.

IF SY-SUBRC <> 0.

DELETE T_ID_ADDRESS.

ELSE.

WRITE: / T_ID_ADDRESS-BNAME.

ENDIF.

ENDLOOP.

ENDIF.

Max

Former Member — Wed, 03 May 2006 10:39:52 GMT

chk this

USR03 where LAND1 is the country code

Former Member — Wed, 03 May 2006 10:42:00 GMT

One country can have multiple user id's, how can you choose only one user id.

regards,

Ravi