read data from a databaseview

[Former Member]

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]

HI,

You can use the select statement on Database view.

[Former Member]

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]

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

Rob