maintenance view

[Former Member]

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

[Former Member]

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

[Former Member]

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!!

[Former Member]

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

[Former Member]

Use table TCURR instead of V_TCURR.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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