Select data from Maintenance view.

[Former Member]

Hi,

Can any body tell me how do we select data from Maintenance view?

Thanks ,

Atul.

[Former Member]

hi atul

VIEW is nothing but the selection query

it contains only structure

select ..field1 field2

from zview

into table itab

where matnr = '11087'.

[Former Member]

Dear Sudhakar,

Thanks for ur reply but it is giving me error that:

Zvew is not a database table or database view or projection view....!

Plz note that Zview is Maintenance view.

Thanks,

Atul

[Former Member]

No its not possible to retrieve data from maintainance view..

Reward if it helpful

[Former Member]

Thanks Arun,

My requirement is select data from Maintenance view.

Can u plz suggest any alternative to it?

Thanks,

Atul

[Former Member]

For this u have only one option according to my view.........

Take the tables for which they established join condition to constuct maintainaace view , and <b>write select querry using INNER JOIN</b> to fetch the related data by establishing join conditions.........

Reward points....

[Former Member]

Just create a database view with the same fields, selection and join conditions as the maintenance view.

Rob

[Former Member]

hi

good

check the below link

http://www.ask.com/web?q=Howmanytypesofviewsinabap&qsrc=1&o=333&l=dir

thanks

mrutyun^