topic Re: Data selection with View in Application Development and Automation Discussions

Data selection with View

Former Member — Fri, 05 Dec 2014 07:39:02 GMT

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 — Fri, 05 Dec 2014 10:19:08 GMT

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 — Fri, 05 Dec 2014 12:00:41 GMT

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..!!