topic SELECT in Application Development and Automation Discussions

SELECT

Former Member — Mon, 29 Oct 2007 04:43:24 GMT

HI,

i have such code tht not fetching data why?

tables: mara.

types: begin of itab occurs 0,

matnr type mara-matnr,

end of itab.

data: itab1 type standard table of itab with header line.

select matnr from mara into itab1.

write: / itab1-matnr.

this code has right syntex but not fetching data from database.?

please provide me most comfortable solution with all possiblities

thanks

rahul

Re: SELECT

Former Member — Mon, 29 Oct 2007 04:44:59 GMT

Hi,

tables: mara.

types: begin of itab,

matnr type mara-matnr,

end of itab.

data: itab1 type standard table of itab with header line.

select matnr from mara into itab1.

write: / itab1-matnr.

endselect.

(or)

select matnr from mara into TABLE itab1.

loop at itab1.

write: / itab1-matnr.

endloop.

rgds,

bharat.

Re: SELECT

Former Member — Mon, 29 Oct 2007 04:46:18 GMT

Hi , rahul.

Try this:

select matnr from mara into table itab1.

loop at itab1.

write: / itab1-matnr.

endloop.

Regards,

feng.

Re: SELECT

Former Member — Mon, 29 Oct 2007 04:47:40 GMT

Hi Rahul,

tables: mara.

types: begin of itab occurs 0,

matnr type mara-matnr,

end of itab.

data: itab1 type standard table of itab with header line.

select matnr from mara into table itab1.

loop at itab1.

write: / itab1-matnr.

endloop.

Re: SELECT

Former Member — Mon, 29 Oct 2007 04:47:55 GMT

Hi,

tables: mara.

types: begin of itab occurs 0,

matnr like mara-matnr,

end of itab.

select matnr from mara into itab-matnr.

loop at itab.

write: / itab-matnr.

endloop.

regards,

paras

Re: SELECT

Former Member — Mon, 29 Oct 2007 04:49:38 GMT

Code should look something like this - I am surprised why your code is not giving any error..

TABLES: mara.

DATA: BEGIN OF itab OCCURS 0,

matnr TYPE mara-matnr,

END OF itab.

SELECT matnr INTO TABLE itab FROM mara .

LOOP AT itab.

WRITE: / itab-matnr.

ENDLOOP.

Anyway Happy abaping ...

Rajiv

Re: SELECT

Former Member — Mon, 29 Oct 2007 04:54:46 GMT

Hi,

Try this,

tables: mara.

types: begin of itab, " occurs 0,

matnr like mara-matnr,

end of itab.

data: itab1 type standard table of itab with header line.

select matnr from mara into itab1.

write: / itab1-matnr.

endselect.

Reward if useful.

Regards,

Ruthra

Re: SELECT

Former Member — Mon, 29 Oct 2007 10:49:12 GMT

u need to end the select statement with ENDSELECT after the write statement.

otherwise

select matnr from mara into table itab1.

loop at itab1.

write: itab1-matnr.

endloop.

plz reward,if it is usefull.

regards,

chandu