Need help...

[Former Member]

Hi Experts,

Can any one tell me how to display the address of a company if the company code is given.

Raj

[Former Member]

yu mean to disaply in report or in scripts

[Former Member]

Hi Warun,

yes i want to display in a report.

Raj

[Former Member]

Try something like this:

SELECT STREET CITY1 REGION POST_CODE1 COUNTRY

INTO TABLE ITAB

FROM ADRC INNER JOIN T001

ON ADRC_{ADDRNUMBER = T001}ADRNR

WHERE T001~BUKRS = P_BUKRS.

[Former Member]

Look at table T001. You can get address from ADRC for T001-ADRNR.

[Former Member]

company code means bukrs is the field name to display company code

[Former Member]

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..