Asset Query - Retirements
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.