Data selection with View

[Former Member]

Dear experts,

I build an view from following tables with following join connections:

I also have an selection screen, but how I can select data with view?

is it SELECT FROM _MY_VIEW?

Or INTO MY_VIEW?

I couldn't find any docs for this at SAP Help.

Thanks for the help.

[former_member201285]

There's no difference between a view and a table regarding the select statement:

DATA: gs_my_view TYPE ZMY_VIEW.

SELECT *

FROM ZMY_VIEW

INTO gs_my_view.

...

ENDSELECT

[Former Member]

Hi Denis,

If its Database view,

Its as good as selecting data from a Dataabse Table..!!

Just write,

Select * from Z_VIEW

     into table lt_view.......

If its a maintenance view,

Use FM VIEW_GET_DATA......

Thanking You All..!!