topic Re: select syntax error in Application Development and Automation Discussions

select syntax error

Former Member — Mon, 19 Mar 2007 21:58:35 GMT

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

Re: select syntax error

RichHeilman — Mon, 19 Mar 2007 22:06:04 GMT

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

Re: select syntax error

Former Member — Mon, 19 Mar 2007 22:06:35 GMT

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

Re: select syntax error

Former Member — Tue, 20 Mar 2007 08:26:38 GMT

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.