issue on a maintenance view

[Former Member]

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.

[Former Member]

just refer rich answer.

[Former Member]

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

[Former Member]

Hello,

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

Manoj

[Former Member]

HI

use the following tables...

T001

T004

T009

T004T

T009T

T880

T014

T014T

regards,

balaji

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

reward if helpfull

amit

[Former Member]

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

u get all table associate with perticular view.