Skip to Content
0

Asset History Query SQVI

Nov 26, 2017 at 10:27 AM

57

avatar image

Hi,

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*

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Nov 26, 2017 at 05:29 PM
0

Hi Regina - maybe you can explain how the asset history sheet is unusable? There are sort versions, etc. that could help/be easier than recreating with SQVI

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 27, 2017 at 05:02 AM
0

Hi Regina,

You need following tables for the sap query

  • ANLP - periodic depreciation value by month
  • ANEP - acquisition value and date
  • ANLA - acquisition date, retirement date or deactivation date

Thanks

Share
10 |10000 characters needed characters left characters exceeded