Asset Query - Retirements

[Former Member]

Dear All

Can you please help me out. I am creating a query in SAP to display asset transactional data and master data. I have encountered two issues.

1. I cannot find a field or table which shows the retirements value. This is available in the Asset History Report. I tried table ANLC but no values are filled in the column for retirement.

2. I am trying to show all assets even those with no transactional value. I am linking tables V_ANLSUM_1 and ANLA to do this but cannot get the list of assets with no transactional values included.

Your helpd is appreciated.

Yours

PRG

[Former Member]

you need to check values posted with transaction type group 20 in ANEP this will be data related to retirement.

For unposted assets, you need to take selection parameters and directly take data in ANLA rather than pushig values of tructure to ANLA.

Hope this helps!!!

Murlidhar Khatri