Calculation of asset gain/loss amount

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hello Sethuraman,

thank You for your quick answer, but I fear that is not the amount I am looking for

[Former Member · Accepted solution]

Hi Marian,

The accumulated depreciation values are credit so it will show negative values. So you just modify the formula like

Net book value=KANSW+(KNAFA+KSAFA+KAAFA)+(NAFAG+SAFAG+MAFAG)

Profit/Loss=Sales revenue-Net book value

Regards,

G.Sethuraman