Asset Report - for useful life of an asset

[Former Member]

Dear Friends,

Is there any standard report which gives the following information --

1. Asset Number,

2. Asset Name

3. Account Determination,

4. Profit Center

5. Useful Life,

6. Depreciation in the current Year

7. Accumulated Depreciation

8. Acquisition Date

I tried in Asset Balances Reports. Most of the fields are coming except Useful Life.

Can any one please suggest.

Regards

KVKR

[Former Member · Accepted solution]

Hi,

Using the Table - V_ANLSUM_1

VVR

[Former Member]

Hi

There is no report with usefullife , either you can go with query or you can extract Asset standard report where you will find most of the details you mentioned and for usefullife please use table ANLB and extract data from this table for useful life. You may copy your asset nos extracted by the above standard Asset report and paste that in the asset field of table ANLB.

Now you can insert the useful life in your main report.

cheers

Mukta

[Former Member]

Have a look to transaction ARQ0 - Ad Hoc Reports

These are abap 4 query reports, you can easy copy an existing one and ad these fields to it

[Former Member]

Hi

There is no report available, Ask your ABAP Guy to develop one report of your requirement.

Regards

Venkat