topic Selection from a Maintenance View in Application Development and Automation Discussions

Selection from a Maintenance View

bharath_mohan2 — Tue, 09 Oct 2007 04:38:09 GMT

Hi,

I have to fetch data from a view, unfotunately that view is a mainteance view. Is there any other way to select/fetch data from that view in my report program ?

Regards,

Bharath Mohan B

Re: Selection from a Maintenance View

Former Member — Tue, 09 Oct 2007 04:46:55 GMT

You can't fetch data from the Maintenance View

You can only fetch data from Database View

Find the Transparent tables of that Maintenance View and try to fetch the data from that Tables related to that maintenance View.

Regards

Anji

Re: Selection from a Maintenance View

bharath_mohan2 — Tue, 09 Oct 2007 04:52:06 GMT

Hi Anji,

Thanks for the inputs....... In the maintenace view there are a lot of transparent tables and join conditions used. I think it would be difficlut to fetch directly from the transp. tables.....

would it help if i create a database view....?

Thanks

Bharath Mohan B

Re: Selection from a Maintenance View

Former Member — Tue, 09 Oct 2007 05:22:01 GMT

U cannot access the data from maintanence view.

Only projection and database view can be used in ABAP code.

If u want to access the Data from more the one table , Create the DATABASE VIEW and use this view in ur program.

For example : UR Database view name is Ztest

in ur program

table Ztest.

select * from Ztest ***************

*******************UR Business Logic

<b>Reward if useful</b>