topic Re: Select query from maintenance view in Application Development and Automation Discussions

Select query from maintenance view

Former Member — Mon, 16 Mar 2009 10:35:16 GMT

Hi,

Can anyone tell how to use a select query for a maintenance view? SAP allows to select values only from table, projection or database view. Pls suggest.

Regards,

Jeyananth

Re: Select query from maintenance view

Former Member — Mon, 16 Mar 2009 10:56:57 GMT

Hi Jeyananth

goto to table maintainance generator of maintainance view...

in there in menu environment--~~>modification~~--->source code or events...

main purpose of maintainance view is to update the multiple (related)table at a time (ex mara and makt tables)....

Regards

Hareesh Menon

Re: Select query from maintenance view

Former Member — Mon, 16 Mar 2009 12:02:34 GMT

Hareesh,

I wanted to know whether any way is there to read the values of maintenance view from a program. If I use a select query on the maintenance view, I get an error message saying that select is possible only in tables, projection view/ database view.

Regards,

Jeyananth

Re: Select query from maintenance view

rahul2000 — Mon, 16 Mar 2009 12:04:59 GMT

Hi.

I don't think you will be able to fire SELECT Query on the maintanence view.

Which is the view that you are talking about?

And why are you going for this view since you are getting the error?

Why not fire separate queries?

Rahul.

Re: Select query from maintenance view

ThomasZloch — Mon, 16 Mar 2009 12:08:36 GMT

Not possible, as you found out. Create the same view as a database view (only inner joins posssible!) or program the JOIN yourself in your SELECT statement.

Thomas

Re: Select query from maintenance view

Former Member — Mon, 16 Mar 2009 12:10:34 GMT

Its a custom maintenance view. I need to know the possibility of reading those values...

Re: Select query from maintenance view

RaymondGiuseppi — Mon, 16 Mar 2009 12:29:59 GMT

As SAP doesn't allow SELECT query on maintenance view, you have to use the FM [VIEW_GET_DATA|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=view_get_data&adv=false&sortby=cm_rnd_rankvalue].

Regards

Re: Select query from maintenance view

GauthamV — Mon, 16 Mar 2009 12:48:04 GMT

You can use the tables used in the mainteanence view and write

a simple program to display the same.

Re: Select query from maintenance view

Former Member — Mon, 16 Mar 2009 14:01:17 GMT

you cannot use a select statement on a maintenance view.I tink you can do one thing

like this.First goto the view and note the tables and the fields of the tables used in the view.

Then use an ABAP join (Join statement)to fetch the data .

This will surely meet you need .

Regrards

Hareesh Menon

Re: Select query from maintenance view

Former Member — Fri, 20 Mar 2009 15:53:15 GMT

Thanks for your suggestions.

Regards,

Jeyananth

Re: Select query from maintenance view

Former Member — Fri, 20 Mar 2009 18:38:54 GMT

Next time, it would be appreciated by those who helped you if you would assign poi nts to those answers.

Rob