the resident asset history report is not usable to me. I want to write a QuickView query with TCode SQVI but am unsure which tables I need to join together to get the following info --
Asset Number, Aquisition Date, Acquisition Value, Periodic Depreciation *not cumulative but broken down by month* and retirement date.
Are tables ANLP and ANLC relevant to get this information? Do I need additional tables? The query should let me search by asset number *I have a list in txt file with about 200 fixed assets I need to analyze*