topic Re: maintenance view in Application Development and Automation Discussions

maintenance view

Former Member — Thu, 16 Apr 2009 10:43:22 GMT

Hi Experts,

I have to read data from a maintenance view.

How can I do it?

Can I read data by writing a select query/

Regards,

Kushagra sharma

Former Member — Thu, 16 Apr 2009 10:47:16 GMT

Yes.

Former Member — Thu, 16 Apr 2009 10:49:08 GMT

Thanx

I tried

but system is giving an error saying that tat particular view is not maintained as dictionary view or table....

Please advice

Regards,

kushagra sharma

Former Member — Thu, 16 Apr 2009 11:01:23 GMT

HI Kushagra,

you cannot use a select query for a maintenance view

instead you have to do the table joins, what ever maintenace view is usiing.

or you can use the FM VIEW_GET_DATA for getting the data.

For more info check this

Thanks!

Former Member — Thu, 16 Apr 2009 11:10:49 GMT

I think to put the SELECT Query that particular Object should exists at database level.

So can put query only on Database table, Project View and Database View.

Former Member — Thu, 16 Apr 2009 11:11:43 GMT

for database view we can use select statement not maintenance view .. use FM.

VIEW_GET_DATA