Fixes Assets: Missing Table OFDV

[Former Member]

Hi there

I just wanted to create a self-made report about "Values" and "Depreciation" of fixes assets. In Asset Master Data i found a reference to table "OFDV" but it seems that this table is missing in the database (see attachment).

We have installed SBO V9.0 PL08 and SQL Server 2012.

Does anybody know where I can find the required table?

Thanks for respond.

Rafael

[Former Member · Accepted solution]

Hi there

Finally I found the required table: ODPV

Thanks for respond.

Regards

Rafael

[Former Member]

Hi there

I think the table ofdv does not exists in the new fixed asstes addon. Please check the table "ODPV". This should contain the required data.

Best regards

Rafael

[Former Member]

hi there,

I need the values ​​of ofdv table to generate a report, but I can not find this table

thaks

David Nunes

[Former Member]

Dear Rafael

I faced the same problem and not able to find the table OFDV. But I found the table where the asset values are been stored i.e. ITM8 and that serves my purpose. Hope this will also help you to design report.

Regards

Nabeel

[former_member205766]

Hi

Check the attachment for fixed tables.

With Regards

Balaji