topic Re: View in Application Development and Automation Discussions

View

Former Member — Thu, 19 Jun 2008 10:19:11 GMT

Hi,

I need to fetch the data from 2 fields in a view v_t009.Can we use a view in the select statement like a table?

Former Member — Thu, 19 Jun 2008 10:19:59 GMT

Hi,

u can use

Former Member — Thu, 19 Jun 2008 10:24:15 GMT

hiiii

yes you can use SELECT query on views.

reward if useful

thx

twinkal

Former Member — Thu, 19 Jun 2008 10:24:26 GMT

Yes hema you can fetch data from a view.

Regards

Former Member — Thu, 19 Jun 2008 10:37:45 GMT

hi check this..the view must be database view

data: itab type table of MARA1 with header line .

tables:MARA1 .

select * from MARA1 into table itab up to 3 rows.

loop at itab.

write:/ itab-matnr.

endloop.