Selecting Data From Maintainence View

[Former Member]

Hi,

I have a requirement to select data from V_001_B view,

but it's a maintainence view,

When use this in FROM clause, i get a syntax error .

Is there any other way say FM etc to select data from Maintainence views.

regards,

Raghavendra

[Former Member]

Hi,

I have a requirement to select data from V_001_B view,

but it's a maintainence view,

When use this in FROM clause, i get a syntax error .

Is there any other way say FM etc to select data from Maintainence views.

regards,

Raghavendra

[Former Member]

Hi,

You can't select Data from Maintenace view.

Data can only be selected either from Projection or Database View.

You can select it from the corresponding tables.

Regards,

Nitin

[Former Member]

Find the underlying database tables for the maintenance view and write the select on that table.

Regards,

Ravi

[Former Member]

Hi,

Check the tables which are used in this view V_001_B. based on your select fields, you can use the respective tables and write separate Select statement using join for those respective tables.

thanks,

sksingh

[Former Member]

Hi Raghu,

check for the underlying database tables for the maintenance view exists and write the select on that table.

regards

Manish yogendra

[Former Member]

Hi Raghu,

check for the underlying database tables for the maintenance view exists and write the select on that table.

regards

Manish yogendra