Querying data from the maintenance view.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

Regards,

Atish

[Former Member]

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.

[Former Member]

Thanks!