how to get data from view using select statement

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

hi,

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

check it.

Thanks

Gaurav.

[Former Member]

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.

[Former Member]

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.