topic Re: Error in Application Development and Automation Discussions

Error

Former Member — Fri, 07 Sep 2007 09:39:23 GMT

Hi, I am new in this industry and trying to practice ITABs. I'm encountering syntax error as follows:- UNKNOWN COLOUMN NAME "EBAN-MATNR" NOT DETERMINE UNTIL RUNTIME ERROR, YOU CANNOT SPECIFY THE FIELD LIST. Please assist. Thanks

REPORT zitabtest1 NO STANDARD PAGE HEADING.

TABLES : eban.

DATA : BEGIN OF itab OCCURS 0,

matnr LIKE eban-matnr, "Material Number"

menge LIKE eban-menge, "Quantity"

END OF itab.

SELECT-OPTIONS : matnr FOR eban-matnr.

SELECT Eban-Matnr Eban-Menge INTO CORRESPONDING FIELDS OF itab

from EBAN UP TO 30 ROWS WHERE Matnr NE space.

endselect.

ULINE /(40).

WRITE : / sy-vline,

(4) 'sno',

sy-vline,

(18) 'material',

sy-vline,

(10) 'Quantity',

sy-vline.

ULINE /(40).

LOOP AT itab.

WRITE 😕 sy-vline,

(4) sy-tabix LEFT-JUSTIFIED,

sy-vline,

(18) itab-matnr,

sy-vline,

(10) itab-menge DECIMALS 0,

40 sy-vline.

ENDLOOP.

ULINE /(40).

Re: Error

Former Member — Fri, 07 Sep 2007 09:41:25 GMT

Hi,

Change your select query,

SELECT Matnr Menge INTO CORRESPONDING FIELDS OF itab

from EBAN UP TO 30 ROWS WHERE Matnr NE space.

endselect.

Reward if helpful.

Re: Error

Former Member — Fri, 07 Sep 2007 09:42:51 GMT

in the select query do the changes like this

SELECT Matnr Menge INTO CORRESPONDING FIELDS OF itab

from EBAN UP TO 30 ROWS WHERE Matnr NE space.

endselect.

Re: Error

Former Member — Fri, 07 Sep 2007 09:43:09 GMT

hi,

SELECT Eban-Matnr Eban-Menge INTO CORRESPONDING FIELDS OF itab

from EBAN UP TO 30 ROWS WHERE Matnr NE space.

endselect. ** this select is wrong

donnot use Eban-Matnr Eban-Menge ,, use

SELECT Matnr Menge INTO CORRESPONDING FIELDS OF itab

from EBAN UP TO 30 ROWS WHERE Matnr NE space.

endselect.

I will let you know the difference..

When you are fetching the data from DBTABLE.. you need to just give the fields (matnr or menge) and not DBTABLE-FIELD (eban-matnr etc..)..

rewards if useful,

regards,

nazeer

Re: Error

former_member404244 — Fri, 07 Sep 2007 09:43:19 GMT

Hi,

do like this

SELECT Matnr Menge INTO table itab

from EBAN UP TO 30 ROWS

WHERE Matnr NE space.

endselect.

Regards,

Nagaraj

Re: Error

Former Member — Fri, 07 Sep 2007 09:43:47 GMT

SELECT Matnr Menge INTO CORRESPONDING FIELDS OF itab

from EBAN UP TO 30 ROWS WHERE Matnr NE space.

endselect.

Re: Error

Former Member — Fri, 07 Sep 2007 09:58:28 GMT

Thanks a million.

Re: Error

Former Member — Fri, 07 Sep 2007 09:59:25 GMT

Thank you for the immediate reply.

Re: Error

Former Member — Fri, 07 Sep 2007 10:00:48 GMT

Thanks.

Re: Error

Former Member — Fri, 07 Sep 2007 10:01:35 GMT

thanks alot.

Re: Error

Former Member — Fri, 07 Sep 2007 10:02:15 GMT

thanks