topic Re: Need help... in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519222#M238590 <HTML><HEAD></HEAD><BODY><P>yu mean to disaply in report or in scripts</P></BODY></HTML> Wed, 06 Sep 2006 15:43:35 GMT Former Member 2006-09-06T15:43:35Z Need help... https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519221#M238589 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P> Can any one tell me how to display the address of a company if the company code is given.</P><P></P><P></P><P></P><P>Raj</P></BODY></HTML> Wed, 06 Sep 2006 15:41:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519221#M238589 Former Member 2006-09-06T15:41:14Z Re: Need help... https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519222#M238590 <HTML><HEAD></HEAD><BODY><P>yu mean to disaply in report or in scripts</P></BODY></HTML> Wed, 06 Sep 2006 15:43:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519222#M238590 Former Member 2006-09-06T15:43:35Z Re: Need help... https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519223#M238591 <HTML><HEAD></HEAD><BODY><P>Look at table T001. You can get address from ADRC for T001-ADRNR.</P></BODY></HTML> Wed, 06 Sep 2006 15:43:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519223#M238591 Former Member 2006-09-06T15:43:36Z Re: Need help... https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519224#M238592 <HTML><HEAD></HEAD><BODY><P>company code means bukrs is the field name to display company code</P></BODY></HTML> Wed, 06 Sep 2006 15:44:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519224#M238592 Former Member 2006-09-06T15:44:18Z Re: Need help... https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519225#M238593 <HTML><HEAD></HEAD><BODY><P>Hi Warun,</P><P> yes i want to display in a report.</P><P></P><P></P><P>Raj</P></BODY></HTML> Wed, 06 Sep 2006 15:52:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519225#M238593 Former Member 2006-09-06T15:52:23Z Re: Need help... https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519226#M238594 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P>SELECT STREET CITY1 REGION POST_CODE1 COUNTRY</P><P> INTO TABLE ITAB</P><P> FROM ADRC INNER JOIN T001</P><P> ON ADRC<SUB>ADDRNUMBER = T001</SUB>ADRNR</P><P> WHERE T001~BUKRS = P_BUKRS.</P></BODY></HTML> Wed, 06 Sep 2006 15:56:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519226#M238594 Former Member 2006-09-06T15:56:39Z Re: Need help... https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519227#M238595 <HTML><HEAD></HEAD><BODY><P>take that field bukrs give that in selection-screen and take the address of company and fetch the data from the table and give that condition bukrs in select..</P></BODY></HTML> Wed, 06 Sep 2006 15:57:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help/m-p/1519227#M238595 Former Member 2006-09-06T15:57:22Z