topic Re: Querying data from the maintenance view. in Application Development and Automation Discussions

Querying data from the maintenance view.

Former Member — Wed, 05 Mar 2008 03:26:42 GMT

Hi Experts,

Well, i need the STEXT field value from the maintanance view V_T591A created for the standard table T591A.

Table T591A has the field Subtype but doesn't have the field Stext, which consists the description of the subtype. The Stext field is there in the maintenance view V_T591A.

So, if i want to query the respective description of the specific subtype, how do i get the values from the maintenance view?

Please advice.

Thanks in anticipation to all!

Cheers,

Sundar.

Re: Querying data from the maintenance view.

Former Member — Wed, 05 Mar 2008 03:30:59 GMT

Just treat mainatainace view as another DB table and write the query on the same.

Regards,

Atish

Re: Querying data from the maintenance view.

Former Member — Wed, 05 Mar 2008 03:32:54 GMT

Atish,

It is not possible that way! U cannot Query directly from MV as a DB table.

Anyways, i managed to find the answer.

Thanks though.

Regards,

Sundar.

Re: Querying data from the maintenance view.

Former Member — Wed, 05 Mar 2008 03:33:21 GMT

Thanks!