topic relation ship between table USR02 and ADRP in Application Development and Automation Discussions

relation ship between table USR02 and ADRP

Former Member — Fri, 07 Mar 2008 11:46:45 GMT

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 — Fri, 07 Mar 2008 11:50:21 GMT

Use SQVI to find the table relation ships.:

Gr8 tool indeed..

Let me know if you want steps etc.

Regards

Tushar M

Former Member — Fri, 07 Mar 2008 11:50:43 GMT

Hi,

There is no direct relationship

But go from USR02 -> USR21

and from USR21 -> ADRP.

Regards,

Atish

Former Member — Fri, 07 Mar 2008 11:55:07 GMT

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.

Former Member — Mon, 10 Mar 2008 08:14:00 GMT

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

Thanks & Regards,

Ramprasad Duduka