on 07-25-2014 2:46 AM
Hello gurus!
I'am trying to implement the asset retirement report (S_ALR_87012052) into SQL, but I am in trouble with the calculation of the GAIN and LOSS amounts of the asset. I already managed to find out the calculation methods of the other amounts using the ANEA table. I think that table should be used in theese two cases too. Can someone please help me?
Thank you
HM
Hi Marian,
Go to table ANLC and input BUKRS-company code, ANLN1-Asset no, GJAHR-Enter current fiscal year and AFABE-Depreciation area.
In output
Field KANSW is Gross block
Field KNAFA,KSAFA and KAAFA is Acc.dep up to FY start (Ord dep,Spl dep and Manual dep respectively)
Field NAFAG,SAFAG and MAFAG is Dep posted in current year.
So Net book value=KANSW-(KNAFA+KSAFA+KAAFA)-(NAFAG+SAFAG+MAFAG)
Profit/Loss=Sales revenue-Net book value.
Hope it is clear.
Regards,
G.Sethuraman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.