select syntax error

[Former Member]

select addrnumber name1 street str_suppl1 city1 region post_code1 country countrycode tel_number 
from adrc join t005t on adrc-country = t005t-land1 into table itab3 for all entries in itab1 where addrnumber = itab1-adrnr 
and t005t-spras = sy-langu.

Error is Field "ADRC-COUNTRY" unknown.

I know the field exists so not sure how to resolve this

[RichHeilman]

select addrnumber name1 street str_suppl1 city1 region
         post_code1 country countrycode tel_number 
                from adrc 
                     inner join t005t
                          on adrc~country = t005t~land1      "<- Use ~
                                 into table itab3
                                         for all entries in itab1 
                                             where adrc~addrnumber = itab1-adrnr   "<- Use ~
                                                 and t005t~spras = sy-langu.     "<- Use ~

Assuming all of your field names are correct, you need to use the ~ when defining the join and referencing the fields in the WHERE clause, you only need to do this when working with joins.

Regards,

Rich Heilman

[Former Member]

Hi,

Please try this.

select addrnumber name1 street str_suppl1 city1 region post_code1 country countrycode tel_number 
from adrc inner join t005t on adrc~country = t005t~land1 
into table itab3 
for all entries in itab1 
where adrc~addrnumber = itab1-adrnr 
  and t005t~spras = sy-langu.

Regards,

Ferry Lianto

[Former Member]

Hi Megan,

As per mentioned above solutions

<b>instead of adrc-country = t005t-land1

mentioned adrc_{country = t005t}land.</b>

Then it wioll work.

Hope this helps you.

Regards,

Kumar.