Getting the value from the field stored in the Transaction code.

[Former Member]

Hi,

My query is like this. I am having a t.code SU01D, in this I have to give User name( SY-uname) and get the field value stored in department.(ADDR3_DATA-DEPARTMENT).

How to know where this DEPARTMENT value is stored, so that I can use in a report where I have to give get DEPARTMENT value giving User name as input.

Promise to reward

regards

Mac

[Former Member]

Hellok,

Check the atble <b>ADCP</b>.

Here u need to make use of the fields of ADDRNUMBER & PERSNUMBER from table usr01.

Regards,

Vasanth

[Former Member]

Thanks Vasanth - This info worked for me.

[anversha_s]

hi,

chk the tabel

pa0001

.

take the field

orgeh

pass the perner and orgeh to the table T527x

u will get the description from the table

T527X

. from that

take the field

ORGTX

Regards

Anver

[Former Member]

Hi Madan,

user address related info. is stored in table USR03. The field

ABTLG in table USR03 gives the department info. of a user.

All user related info. is stored in tables starting with 'USR'. so in SE11 you can search with 'USR*' to get list of user info. tables.

Pls. reward points if helpful.

Regards,

Vishnu Priya