topic Re: fetching data from view??? in Application Development and Automation Discussions

fetching data from view???

Former Member — Wed, 08 Jul 2009 11:46:07 GMT

how to fetch dat from view?

i am writing

select single a b c from view_name into wa_xyz .

then it is showing some error...

plz help me

Re: fetching data from view???

Former Member — Wed, 08 Jul 2009 11:49:07 GMT

use

data : begin of wa_stru,

end of wa_stru.

select a b c into wa_stru

from view

where cond.

this for structure.

data : it_stru type standard table of wa_stru.

select a b c into table it_stru

from view

where cond.

it is same as we use tables.

Edited by: sarbpreet multani on Jul 8, 2009 5:24 PM

Re: fetching data from view???

Former Member — Wed, 08 Jul 2009 11:51:26 GMT

Hi ,

what is the error you are getting.

Thanks,

Rajeshwar

Re: fetching data from view???

kesavadas_thekkillath — Wed, 08 Jul 2009 11:51:57 GMT

what error.

Possible solutions - guessing

declare

tables:<view_name>.

select single a b c from view_name into (wa_xyz-a, wa_xyz-b,wa_xyz-c).

Re: fetching data from view???

Former Member — Wed, 08 Jul 2009 11:55:00 GMT

Hi,

Please let me know the error.

SELECT SINGLE * FROM view name INTO WA_area WHERE condition.

Regards,

Aditya

Re: fetching data from view???

Former Member — Wed, 08 Jul 2009 12:55:01 GMT

Hi,

Try using


select single a b c 
       from view_name 
       into corresponding fields of wa_xyz .

Hope this helps.

Regards,

Dhasarathy.

Re: fetching data from view???

Former Member — Wed, 08 Jul 2009 13:41:43 GMT

HI,

Try this and compare with your scenario.

eg:

Tables: caufv. " Caufv is a database view

data: itab like caufv occurs 0 with header line.

select * from caufv into table itab.

In your case if you are selcting the required fields from the table please check the order of the fields being fetched with that of the internal table.

Regards,

Satish

Re: fetching data from view???

Former Member — Thu, 16 Jul 2009 02:41:25 GMT

Hi puja!

you cannot use select statement to retrieve data from view.

use the FM - VIEW_GET_DATA.

Store the values into internal table and then do your process.

Regards,

Sakthi.