topic relation between tables USR02 and ADDR3_DATA in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/relation-between-tables-usr02-and-addr3-data/m-p/3209282#M765086 <HTML><HEAD></HEAD><BODY><P>hello gurus,</P><P></P><P>I need to get :</P><P>last name,</P><P>first name,</P><P>Function,</P><P>Dept,</P><P>Room no.</P><P>from ADDR3_DATA using USR02-BNAME.</P><P></P><P>what is the relation between the 2 tables and how should i join it?</P></BODY></HTML> Tue, 18 Dec 2007 16:00:33 GMT Former Member 2007-12-18T16:00:33Z relation between tables USR02 and ADDR3_DATA https://community.sap.com/t5/application-development-and-automation-discussions/relation-between-tables-usr02-and-addr3-data/m-p/3209282#M765086 <HTML><HEAD></HEAD><BODY><P>hello gurus,</P><P></P><P>I need to get :</P><P>last name,</P><P>first name,</P><P>Function,</P><P>Dept,</P><P>Room no.</P><P>from ADDR3_DATA using USR02-BNAME.</P><P></P><P>what is the relation between the 2 tables and how should i join it?</P></BODY></HTML> Tue, 18 Dec 2007 16:00:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/relation-between-tables-usr02-and-addr3-data/m-p/3209282#M765086 Former Member 2007-12-18T16:00:33Z Re: relation between tables USR02 and ADDR3_DATA https://community.sap.com/t5/application-development-and-automation-discussions/relation-between-tables-usr02-and-addr3-data/m-p/3209283#M765087 <HTML><HEAD></HEAD><BODY><P>Check this program ..you'll get good idea....</P><P></P><P><A href="http://www.geocities.com/mpioud/Z_LIST_USER_PROFILES.html" target="test_blank">http://www.geocities.com/mpioud/Z_LIST_USER_PROFILES.html</A></P></BODY></HTML> Tue, 18 Dec 2007 16:03:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/relation-between-tables-usr02-and-addr3-data/m-p/3209283#M765087 Former Member 2007-12-18T16:03:18Z Re: relation between tables USR02 and ADDR3_DATA https://community.sap.com/t5/application-development-and-automation-discussions/relation-between-tables-usr02-and-addr3-data/m-p/3209284#M765088 <HTML><HEAD></HEAD><BODY><P>Use this BAPI</P><P>&gt;BAPI_USER_GET_DETAIL</P></BODY></HTML> Tue, 18 Dec 2007 16:10:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/relation-between-tables-usr02-and-addr3-data/m-p/3209284#M765088 Former Member 2007-12-18T16:10:12Z