I need to create a view combining data from several tables (a lot). I read documentation about it and I understood that, if my requirement is to create relationship in outer join (and this is my case) I need to create maintainance view.
I really don't need "MANTAIN".. I need just for reading, but creating just a database view, "outer" condition fails.
So I created mantainance view and I activated it. But I cannot use in program or for reading table content. If I try to click on button to see tables content (from SE11), a message tells me:
No database view exists for view ZALLPDATAO
Where ZALLPDATAO is mantainance view I created.
Can someone explain me what am I missing and where I am wrong please?
Edited by: Gabriele Montori on Feb 7, 2012 3:30 PM
Edited by: Gabriele Montori on Feb 7, 2012 3:31 PM