topic Re: Select data from Maintenance view. in Application Development and Automation Discussions

Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 12:08:06 GMT

Hi,

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

Thanks ,

Atul.

Re: Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 12:11:25 GMT

hi atul

VIEW is nothing but the selection query

it contains only structure

select ..field1 field2

from zview

into table itab

where matnr = '11087'.

Re: Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 12:15:52 GMT

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

Re: Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 12:16:41 GMT

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

Reward if it helpful

Re: Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 12:28:48 GMT

Thanks Arun,

My requirement is select data from Maintenance view.

Can u plz suggest any alternative to it?

Thanks,

Atul

Re: Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 12:38:58 GMT

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

Re: Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 12:41:47 GMT

good

check the below link

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

thanks

mrutyun^

Re: Select data from Maintenance view.

Former Member — Wed, 12 Sep 2007 13:42:45 GMT

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

Rob