Former Member
Jun 22, 2015 at 10:35 AM

# Depreciation key first year 50% + linear depr

789 Views

My dear SAP Guru's,

Problem description:

I have the following request for a depreciation key:

Example: Asset X bought on 1-6-2015 for 10000 with a lifespan of 5 years

Due to regulations we need to depreciate this as following:

Year 1:

50% of 10000 = 5000

+

(5000/5) / (6/12) = 500

Total depreciation year 1 = 5500

Year 2 till 5:

(5000/5) / (12/12) = 1000

Final year (remaining months):

(5000/5) / (6/12) = 500

I made the following multi level method:

Acq. year: 9999

Year: 1

Period: blank

Base value: 01 - Aquisition value

Percentage: 50

I have defined the following depreciation key:

Phase 1:

Base method: 0014 - Ordinary: explicit percentage (after end life)

Period control: 004

Multilevel method: My custom made multilevel method descriped above

Chnge. method: 2 - Changeover when net book value percentage is reached

Percentage: 50,1%

Phase 2:

Base method: 0011 - Ordinary: percentage from useful life

Period control: 004

Multilevel method: 001 - 0%

Test results:

With these settings I'm getting the following results, based on the example I gave (Aq. value = 10k, life span = 5 yr)

Year 1: depreciation is 5000 (so sap calculates the 50%)

Year 2: depreciation is 1250 (5000/4)

Year 3: depreciation is 1250 (5000/4)

Year 4: depreciation is 1250 (5000/4)

Year 5: depreciation is 1250 (5000/4)

Total: 10000

Desired results:

This is how it should be:

Year 1: depreciation is 5000 + 500 (50% + remaining months of the year)

Year 2: depreciation is 1000

Year 3: depreciation is 1000

Year 4: depreciation is 1000

Year 5 : depreciation is 1000

Year 6: depreciation is 500 (remaining 6 months)

Total: 10000

Question:

What adjustments do I need to make to get to my desired results?

Best regards,

Roeland Siemons