topic Re: how to extract data from maintenance view in Application Development and Automation Discussions

how to extract data from maintenance view

Former Member — Thu, 09 Aug 2007 05:41:42 GMT

can any help me how to extract data from maintenance view T_v and do for all entries.

Thanks & regards,

Mahendra.

Re: how to extract data from maintenance view

Former Member — Thu, 09 Aug 2007 07:15:18 GMT

like normal table

in maintanace view u will find all the data which is exist in table

select *

from that view

into table itab

for all entries any maintanace view

rewrad if helpfull

Re: how to extract data from maintenance view

Former Member — Thu, 09 Aug 2007 08:57:52 GMT

Thanks for your reply..

am trying to fetch data from view v_t438r (Maintanance view)

But it is giving error as below

"V_t438r is not defined in abap dectionary as table , projection view or database view. "

But it is available in SE11.

Regards,

Mahendrab

Re: how to extract data from maintenance view

varma_narayana — Thu, 09 Aug 2007 09:28:39 GMT

Hi ..

Maintenance views cannot be used in programs i.e Select statements.

You can only maintain the data of a Maintenance view in Tcode SM30.

For that you have to first generate the Table maintenance in SE54.

So you can create a Database view if you want to access it in Select ..

<b>Reward if Helpful</b>

<b></b>

Re: how to extract data from maintenance view

Former Member — Thu, 09 Aug 2007 12:37:19 GMT

Hi mahendra kumar

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

If helpfull reward Points.

ANEES AHMED

9886358645

Re: how to extract data from maintenance view

Former Member — Fri, 10 Aug 2007 10:17:38 GMT

Hi ,

U cannot access data from maintenance views . Maintenance view are also made from tables . In the maintenance view u can find the tables of which they are made of .

Use those tables to access the required data .

Regards