topic Re: Syntax error in Application Development and Automation Discussions

Syntax error

Former Member — Tue, 20 Mar 2007 13:52:12 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

into table itab3

for all entries in itab1

where addrnumber = itab1~adrnr

and t005t_{spras = sy}langu.

I am getting error Unknown column name "COUNTRYCODE". not determined until runtime, you cannot specify a field list.

Re: Syntax error

Former Member — Tue, 20 Mar 2007 13:54:19 GMT

Hi!

In ADRC, there is no COUNTRYCODE, only COUNTRY field.

Simply delete it from your code.

Regards

Tamá

Re: Syntax error

Former Member — Tue, 20 Mar 2007 13:55:58 GMT

select addrnumber name1 street str_suppl1 city1 region post_code1 adrc~country tel_number

from adrc inner join t005t on adrc_{country = t005t}land1

into table itab3

for all entries in itab1

where addrnumber = itab1~adrnr

and t005t_{spras = sy}langu.

regards

madhu

Message was edited by:

Madhumitha Vasudevan

Re: Syntax error

Former Member — Tue, 20 Mar 2007 13:57:22 GMT

Hi,

There is no country code field available neither in table ADRC or T005T. Please check your mapping or requirement.


select addrnumber name1 street str_suppl1 city1 region post_code1 country  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      <-- add adrc~
and t005t~spras = sy~langu.

Regards,

Ferry Lianto

Re: Syntax error

Former Member — Tue, 20 Mar 2007 13:57:47 GMT

Hi,

If you look at the table ADRC, you can not find the Column Countrycode,

Regards

Sudheer

Re: Syntax error

Former Member — Tue, 20 Mar 2007 14:00:25 GMT

data: begin of itab3 occurs 0,
      adrnr like adrc-addrnumber,
      name1 like adrc-name1,
      address1 like adrc-street,
      address2 like adrc-str_suppl1,
      city like adrc-city1,
      state like adrc-region,
      zip like adrc-post_code1,
      countrytxt like t005t-landx,
      country like adrc-country,
      telnum like adrc-tel_number,
      end of itab3,
      wa_itab3 like itab3.

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

I need to get the text of the country from table t005t so i am using a join. I still get the error Unknown column name "COUNTRYTXT". not determined until runtime, you cannot specify a field list.

Re: Syntax error

Former Member — Tue, 20 Mar 2007 14:03:28 GMT

data: begin of itab3 occurs 0,

adrnr like adrc-addrnumber,

name1 like adrc-name1,

address1 like adrc-street,

address2 like adrc-str_suppl1,

city like adrc-city1,

state like adrc-region,

zip like adrc-post_code1,

landx like t005t-landx,

country like adrc-country,

telnum like adrc-tel_number,

end of itab3,

wa_itab3 like itab3.

select addrnumber name1 street str_suppl1 city1 region post_code1 landx country tel_number

from adrc inner join t005t on adrc_{country = t005t}land1

into table itab3

for all entries in itab1

where addrnumber = itab1~adrnr

and t005t_{spras = sy}langu.

regards,

madhu

Re: Syntax error

Former Member — Tue, 20 Mar 2007 14:04:18 GMT

Hi,

Please try this.


select adrc~addrnumber 
       adrc~name1 
       adrc~street 
       adrc~str_suppl1 
       adrc~city1 
       adrc~region 
       adrc~post_code1 
       t005t~landx
       adrc~country  
       adrc~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: Syntax error

Former Member — Tue, 20 Mar 2007 14:05:13 GMT

Hi Megan,

Might be you have declared "countrycode" in other name, so please verify the table once before making the join and then proceed.

The only possibility of getting the error is that you have given different name for it, please check it and then check it.

Thanks and regards

Vipin Das

Re: Syntax error

Former Member — Tue, 20 Mar 2007 14:06:04 GMT

Madhu .. that does not work .. instead of landx variable i am using countrytxt but doing the same thing that u mention

Re: Syntax error

Former Member — Tue, 20 Mar 2007 14:09:22 GMT

select addrnumber name1 street str_suppl1 city1 region post_code1 landx country tel_number

from adrc inner join t005t on adrc_{country = t005t}land1

into table itab3

for all entries in itab1

where addrnumber = itab1~adrnr

and t005t~spras = sy-langu. " chk sy-langu

use -(hypen) instead of ~ tilda

regards

madhu