09-12-2007 1:08 PM
Hi,
Can any body tell me how do we select data from Maintenance view?
Thanks ,
Atul.
09-12-2007 1:11 PM
hi atul
VIEW is nothing but the selection query
it contains only structure
select ..field1 field2
from zview
into table itab
where matnr = '11087'.
09-12-2007 1:15 PM
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
09-12-2007 1:16 PM
No its not possible to retrieve data from maintainance view..
Reward if it helpful
09-12-2007 1:28 PM
Thanks Arun,
My requirement is select data from Maintenance view.
Can u plz suggest any alternative to it?
Thanks,
Atul
09-12-2007 1:38 PM
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....
09-12-2007 2:42 PM
Just create a database view with the same fields, selection and join conditions as the maintenance view.
Rob
09-12-2007 1:41 PM
hi
good
check the below link
http://www.ask.com/web?q=Howmanytypesofviewsinabap&qsrc=1&o=333&l=dir
thanks
mrutyun^