on 04-08-2009 4:54 PM
Hello Gurus,
What is the table name for getting depreciaton values like ordinary depreciation and special depreciation which are appearing in AW01N transaction. I want to generate a report so pls tell me the table name.
regds
Ramachandra
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
A while back I was trying to create an asset report with asset balances but was unsuccessful in finding a summary asset balance table. Because I was creating the report with SAP query, using tables such as ANEP and ANEK yields the following problems:
o Multi lines per asset because various depreciation years (I only need one line - net book value - per asset)
o Fully depreciated assets that do not have depreciation in the current year will not get selected in the report (I want all assets per selection parameters)
I found a document u201CHow to Add Fields to Any Fixed Asset Reportu201D written by Nathan Genez. I use AR01 as it has the field Net Book Value that meets my report requirements. All I did was to add other fields, for example fields defined in ANLC, to the existing reporting structure of AR01. This is much easier than trying to create a new report.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The Dep. value is stored in table . ANLC
ANLC-KNAFA this is for accumulated dep.
for total all accumulated dep. you have add all below fields in table anlc.
ANLC-KNAFA +ANLC-KSAFA ANLC-KAAFA ANLC-NAFAP+ANLC-AAFAM
Thanks,
kali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Try with tables
ANEP
ANEA
ANEK
Alternatively through Quick Viewer you create query. User logical data base ADA
Regards,
Ravi
Edited by: Ravi Sankar Venna on Apr 8, 2009 5:05 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
10 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.