topic Re: how to get data from view using select statement in Application Development and Automation Discussions

how to get data from view using select statement

Former Member — Tue, 20 Apr 2010 07:28:55 GMT

hi,

i am calling selecting data from view but it gave me this erorr.

VIEW NAME,is not defined in the ABAP Dictionary as a table, projection view, or database view.

Even though i have define this View in my Database, but can't understand what is the problem.

Thanks.

Re: how to get data from view using select statement

Former Member — Tue, 20 Apr 2010 07:39:45 GMT

While creating the View ensure that you have created it as Database View as data can only be fetched from Database view and Projection View.

Re: how to get data from view using select statement

Former Member — Tue, 20 Apr 2010 08:07:09 GMT

actually this view is not made by me, it is made by someone else and i don't know whether it's Database View or Projection View.could u tell me from where i can identified that it's Database View or Projection View.?

Thanks

Re: how to get data from view using select statement

Former Member — Tue, 20 Apr 2010 08:09:32 GMT

Hi,

I think the view created by you may be maintainence or help view, these cannot be

used in select queries for reports.

Regards and Best wishes.

Re: how to get data from view using select statement

Former Member — Tue, 20 Apr 2010 08:14:57 GMT

hi,

when u enter a view on left hand top where the name is given there type is also written.

check it.

Thanks

Gaurav.

Re: how to get data from view using select statement

Former Member — Tue, 20 Apr 2010 08:20:07 GMT

Hi,

if you go to se11 and input the view that you want to see and hit on display, it will take you to the next screen.

in that screen you will be able to see the type of view it is .

This will be displayed just to the left hand side of the view name.

Regs,

SuryaD.