topic Re: internal table error in Application Development and Automation Discussions

internal table error

Former Member — Sun, 31 Aug 2008 13:15:43 GMT

hi,

i have started learning sap abap recently.

i have written a report but at the time of activating it is showing

error

"the work area it_itab is not long enough".

and my report is

REPORT ZPROG2.

TABLES: ZTABLE2.

DATA:BEGIN OF IT_ITAB OCCURS 0,

EMPNO LIKE ZTABLE2-DEPTNO,

END OF IT_ITAB.

SELECT * FROM ZTABLE1 INTO TABLE IT_ITAB.

END SELECT.

LOOP AT IT_ITAB.

WRITE:/ IT_ITAB .

ENDLOOP.

please give me the solution i will be thankfull.

Re: internal table error

Former Member — Sun, 31 Aug 2008 13:20:14 GMT

YOU NEED TO SELECT DATA ACCORDING TO YOUR INTERNAL TABLE DESIGN,

REPORT ZPROG2.

TABLES: ZTABLE2.

DATA:BEGIN OF IT_ITAB OCCURS 0,

EMPNO LIKE ZTABLE2-DEPTNO,

END OF IT_ITAB.

SELECT DEPTNO  FROM ZTABLE1 INTO TABLE IT_ITAB. "<===CORRECTION
END SELECT.

LOOP AT IT_ITAB.
WRITE:/ IT_ITAB-EMPNO .
ENDLOOP.

Re: internal table error

Former Member — Sun, 31 Aug 2008 13:44:07 GMT

Hi Dev Kumar

Don't use endselect.

u will get the proper result.

Re: internal table error

uwe_schieferstein — Sun, 31 Aug 2008 16:59:00 GMT

Hello Kumar

Using an itab to select data you must not used the ENDSELECT statement (exception: APPENDING itab).

In addition, if you only want to select specific fields then add the following option to the select statement:

SELECT * FROM ZTABLE1 INTO CORRESPONDING FIELDS OF TABLE IT_ITAB.
""END SELECT.  " => not required because you make an array fetch

Regards

Uwe

Re: internal table error

kesavadas_thekkillath — Mon, 01 Sep 2008 04:19:08 GMT

YOu cannot pour 10 cups of cofee into a single cup...

Its the same situation here....select only the needed fields....

Re: internal table error

Former Member — Mon, 01 Sep 2008 04:23:39 GMT

Hi,

First remove * from your select query. Select only empno into your internal table because you have declared your internal table that way. Second thing your target area is an internal table(INTO TABLE it_tab), so don't use ENDSELECT.

SELECT-----ENDSELECT is only used in situation when your target firls is a workarea.

when you select data from a ztable into an internal table, data comes into your internal table in one go this is called array fetch. So no need to use ENDSELECT.

Regards

Abhijeet

Re: internal table error

Former Member — Mon, 01 Sep 2008 04:25:14 GMT

Hi Dev,

Select only the field EMP_NO from the table IT_ITAB, because your ZTABLE1 might be containing more than one fields. In your select statement you are selecting *, ie., all fields into table IT_ITAB which has only one field.

Do not use ENDSELECT and always try to use WHERE condition in a Select statement.

Regards,

Chandra Sekhar

Re: internal table error

Former Member — Mon, 01 Sep 2008 04:29:25 GMT

Hi,

ur select querry should be like

select EMPNO

from ztable1

into table it_tab.

no need of endselect....

or u can use into corresponding fields ,

that is like..

select *

from ztable1

into corresponding fields of table it_tab.

Re: internal table error

Former Member — Tue, 02 Sep 2008 13:34:06 GMT

hi kumar,

EMPNO LIKE ZTABLE2-DEPTNO,

END OF IT_ITAB.

SELECT * FROM ZTABLE1 INTO TABLE IT_ITAB

*you are defining internal table for only dept-no field in the table ztable2.

so your itab space can only have space to occupy deptno field.

but in select stmt you are selecting all the fields from ztable2,which has no space to occupy in your internal table. so you better removw * from your select stmtand specify deptno.

regards

manju

Re: internal table error

Former Member — Tue, 02 Sep 2008 13:35:12 GMT

hi kumar,

EMPNO LIKE ZTABLE2-DEPTNO,

END OF IT_ITAB.

SELECT * FROM ZTABLE1 INTO TABLE IT_ITAB

*you are defining internal table for only dept-no field in the table ztable2.

so your itab space can only have space to occupy deptno field.

but in select stmt you are selecting all the fields from ztable2,which has no space to occupy in your internal table. so you better remove * from your select stmtand specify deptno.

regards

manju

Re: internal table error

Former Member — Tue, 02 Sep 2008 13:35:47 GMT

hi kumar,

*you are defining internal table for only dept-no field in the table ztable2.

so your itab space can only have space to occupy deptno field.

but in select stmt you are selecting all the fields from ztable2,which has no space to occupy in your internal table. so you better remove * from your select stmtand specify deptno.

regards

manju

Re: internal table error

Former Member — Tue, 02 Sep 2008 13:36:12 GMT

hi kumar,

*you are defining internal table for only dept-no field in the table ztable2.

so your itab space can only have space to occupy deptno field.

but in select stmt you are selecting all the fields from ztable2,which has no space to occupy in your internal table.

*so you better remove * from your select stmtand specify deptno.

regards

manju