topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Mon, 28 Aug 2006 10:34:55 GMT

Hi All..

There is a field in ztable called "zreqtype" with char 20 length.

i have defined an internal table itab with all fields same as in ztable.

Now if i write select statement, i am facing following Problems..

1. If i write as follows, i can't retrieve the data from ztable-zreqtype. But i will get other fields of that row..

select * from ztable into corresponding fields of table itab where zreqno = s_reqno.

The extracted fields will be made to display in an ALV output..

2. If i write it as...

select reqtype from ztable into corresponding fields of table itab where zreqno = s_reqno.

I will be able to retrieve the "Zreqtype" field...

BUT the same data don't display in ALV Output...

What to do now...??

plz help me out...

Re: Select Statement

Former Member — Mon, 28 Aug 2006 10:37:46 GMT

DATA:BEGIN OF ITAB OCCURS 0.

INCLUDE STRUCTURE ZTZBLE.

DATA:END OF ITAB.

select * from ztable into table itab where zreqno = s_reqno.

TO DISPLAY IN ALV CHECK..

zreqtype</b>---->IT IS IN CAPITAL LETTER

Re: Select Statement

Former Member — Mon, 28 Aug 2006 10:45:29 GMT

Kishan,

System is throwing error " The work area itab is not long enough"..

???????????

Re: Select Statement

Former Member — Mon, 28 Aug 2006 10:46:33 GMT

hi,

Check if you included the MANDT field which is existing in z table in the internal tbale itab or not?

Regards,

Sailaja.

Re: Select Statement

Former Member — Mon, 28 Aug 2006 10:50:16 GMT

hi,

DATA: begin of ITAB.

include structure ZTABLE.

DATA: end of itab.

then

SELECT * FROM ZTABLE INTO ITAB WHERE <cond>

Now you will able to see all the fields.

Regards,

srikanth

Message was edited by: Srikanth Kidambi

Re: Select Statement

Former Member — Mon, 28 Aug 2006 11:05:22 GMT

good

how you have declared the internal table,thats makes the difference, if you have not declared using the like statement, than your select statement give you the error.

check out that first,

than your select statement are correct, but the thing is how you are displaying them though the ALV report, have you declared the field catalogue properly.

check your field catalogoue.

thanks

mrutyun