topic Re: issue on a maintenance view in Application Development and Automation Discussions

issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:25:44 GMT

I want to fetch the data from a maintenance view: V_001_B.

I used the select statement to retrieve the data.But, I got a message saying that "it's not a table or a database view or a projection view".

Any body please help me, how to retrieve data from a maintenance view.

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:32:02 GMT

just refer rich answer.

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:34:56 GMT

How can I know what is the base table for the view V_001_B?

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:36:55 GMT

use tables T882,T001,T001Z to read ur concerned data...instead of using the view..

reward if helpfull

amit

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:39:20 GMT

Hello,

You can just select from the table you used for generating the maintainence view.

Manoj

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:40:50 GMT

use the following tables...

T001

T004

T009

T004T

T009T

T880

T014

T014T

regards,

balaji

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:41:13 GMT

go to se11~~- put ur view name there>dislay~~-->check tab stript table/condition join

u get all table associate with perticular view.

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:49:31 GMT

We need a field OPVAR which is present in the table T001.So, can't we use only T001 table, instead of using the view V_001_B or instead of making use of all the tables in the view.

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:52:34 GMT

depend upon condition.

just 1st check table t001 have the same value as it have the value in view using se11.if it is same take it only fro t001

Re: issue on a maintenance view

Former Member — Wed, 27 Dec 2006 06:52:42 GMT

these r the 3 tables which r connected to ur view - T882,T001,T001Z

if u want data based on some join on these 3 tables then put a join in ur code on these 3 tables and then fetch ur record..if u want datra specific to one table only then u can directly select tht frm a single table..

amit