topic Re: maintenance view in Application Development and Automation Discussions

maintenance view

Former Member — Sun, 17 May 2009 08:54:20 GMT

hi all,

I want to retrive data from V_TCURR view. As this is maintenance view so i am not able to retrive data from maintenance view by using select statement. It shows syntex error. So Please provide me the way we can retrive data from MAINTENANCE VIEW.

Thanks

Babbal

Re: maintenance view

Former Member — Sun, 17 May 2009 09:06:33 GMT

Hi,

You can select data only if it is a database view.

You will not be able to do a select on a maintainance view.

If you want to select the data; check the tables of the view and do accordingly.

Regards,

Ankur Parab

Re: maintenance view

Former Member — Sun, 17 May 2009 09:08:12 GMT

Hi Babbal,

You can't use the select query for the Maintenance Views.

you can directly use the tables which are using in that Maintenacne Views.

in your case for the View V_TCURR, the table using is TCURR.

So directly hit that table using the select query. it solves your problem

Thanks!!

Re: maintenance view

Former Member — Sun, 17 May 2009 15:55:10 GMT

Hi,

A maintenance view permits you to maintain the data of an application object together. The data is automatically distributed in the underlying database tables. The maintenance status determines which accesses to the data of the underlying tables are possible with the maintenance view.

Hence it would be easy to retrieve the data from the DB tabke using select query in our case here its TCURR,

So go on

Thanks and Regards

Srikanth.P

Re: maintenance view

Former Member — Sun, 17 May 2009 15:59:20 GMT

Use table TCURR instead of V_TCURR.

Re: maintenance view

Former Member — Mon, 18 May 2009 05:07:03 GMT

Hi Babbal,

Instead of trying to fetch records from maintenance view, you can write a select statement on database table TCURR, which has all the data that is present in V_TCURR.

Hope this may work.

Regards,

Prashant Gaikwad

Re: maintenance view

Former Member — Mon, 18 May 2009 08:33:41 GMT

you cant fetch data from maintanance view just select data from TCURR table it will help you

Re: maintenance view

Former Member — Tue, 19 May 2009 12:18:55 GMT

Why dont you use FM

CONVERT_TO_LOCAL_CURRENCY

if your requirement is to get the currency conversion. This is better way than getting the data from table and then using tfact and ffact factors.

Re: maintenance view

Former Member — Fri, 22 May 2009 09:52:45 GMT

Dear babbal,

select statement cant be on a Maintenance Views.what you can do is go directly to the tables which are using in that Maintenacne Views.in your case for the View V_TCURR,so you can use TCURR.

Cheers

fareed