topic read data from a databaseview in Application Development and Automation Discussions

read data from a databaseview

Former Member — Tue, 07 Jul 2009 14:39:51 GMT

Hi everybody,

how can i read the data from a databaseview. I try it with a select but it doesn't work.


SELECT * FROM mydatabaseView INTO lt_databaseview.

regards,

Sid

Former Member — Tue, 07 Jul 2009 14:51:32 GMT

HI,

You can use the select statement on Database view.

Former Member — Tue, 07 Jul 2009 14:56:41 GMT

Hi,

Select on database view will work....

try this example and check with yours

caufv is a database view.

eg:-

data: itab_cauvfv type satandard table of types_caufv.

SELECT * FROM caufv

INTO TABLE itab_caufv.

Former Member — Tue, 07 Jul 2009 14:59:07 GMT

Please search the forum. This question has been asked and answered before. You can only SELECT directly from certain types of views.

Rob