relation ship between table USR02 and ADRP

[Former Member]

Hi all,

My requirement is to dispaly the userid , username, address and email id.

iam unable to find the realtionship between table USR02 ( which maintains userid's) and ADRP( which has user name, etcs).

Please tell the how to fetch the name , address and email id data for perticular userid

urgent.

thanks in advance

ramprasad

[Former Member]

Use SQVI to find the table relation ships.:

Gr8 tool indeed..

Let me know if you want steps etc.

Regards

Tushar M

[Former Member]

Could you please tell me the step to find out the relation between 2 tables by using SQVI tool.

Thanks & Regards,

Ramprasad Duduka

[Former Member]

Hi,

There is no direct relationship

But go from USR02 -> USR21

and from USR21 -> ADRP.

Regards,

Atish

[Former Member]

Using userid U can get the personnel number from PA0105 ..

pass this PERSNUMBER to ADRP and get other details.

select pernr from pa0105 .....

where USRID = USR02-USRID.