1. Home
  2. Resources
  3. SAP Tables
  4. T090 - Depreciation calculation keys

SAP Table T090

Depreciation calculation keys

T090 (Depreciation calculation keys) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T090 to other SAP tables.

T090 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AFARSL Internal calculation key for depreciation and interest AFARSL_OLD CHAR 4 0
GBEGIN Start of Validity Period GBEGIN CHAR 1 0
1 From capitalization date
2 From ordinary depreciation start date
3 From special depreciation start date
4 From original acquisition date of AuC
5 From changeover year
AFATYP Depreciation type AFATYP CHAR 1 0
N Ord.depreciation
S Special tax depreciation
Z Interest
XAFAUT Automatic calculation of depreciation or interest XAFAUT CHAR 1 0
X Yes
NULL No
DEGFAK Declining-balance multiplication factor DEGFAK DEC 3 2
MAXPRZ Maximum percentage rate MAXPRZ DEC 7 4
MINPRZ Minimum percentage rate MINPRZ DEC 7 4
UMAFSL Calculation key after changeover UMAFSL T090 CHAR 4 0
UMRPRZ Net book value percentage rate for depreciation changeover UMRPRZ DEC 3 1
XSTILL Calculate shutdown XSTILL CHAR 1 0
X Yes
NULL No
XENDAU Depreciation after end of planned life XENDAU CHAR 1 0
X Yes
NULL No
XUNTNL Calculation of depreciation below net book value zero XUNTNL CHAR 1 0
X Yes
NULL No
XEFDAU Depreciation with expired effective life XEFDAU CHAR 1 0
X Yes
NULL No
PERBZU Period control: Acquisition PERBZU T090R CHAR 2 0
PERBNA Period control: Acquisition in the following year PERBNA T090R CHAR 2 0
PERBAB Period control: Retirement PERBAB T090R CHAR 2 0
PERBUM Period control : Transfer PERBUM T090R CHAR 2 0
XDAILY Depreciation calculation to exact day XDAILY CHAR 1 0
X Yes
NULL No
XLIFEC Reduce useful life to the end of fiscal year XLIFEC CHAR 1 0
X Yes
NULL No
XAFNAH Depreciation levels by fiscal years and periods XAFNAH CHAR 1 0
X Yes
NULL No
XBZDAT Ind.: Calculate depreciation from the asset value date XBZDAT CHAR 1 0
X Yes
NULL No
UMSTM Changeover method UMSTM CHAR 1 0
0 No automatic changeover
1 Changeover when straight-line dep. is higher (Germany)
2 Changeover when net book value percentage reached
3 Changeover when net book value less than changeover amount
4 Changeover when net book value less than straight-line rate
5 Changeover after end of the useful life
6 Changeover in next year as soon as str.-line higher (Poland)
7 Changeover when net book value percent less or same as x%
8 Conversion After End of Planned Life (Inflation)
9 Same as 1, But No Changeover in Dep. Start Year (France)
X Free for user modification 1
Y Free for user modification 2
Z Free for user modification 3
A Same as 1, But Do Not Set Changeover Year (Spec.Dep. Poland)
B Same as 2, But Do Not Set Changeover Year/Period (Russia)
C Free for country-specifics 1
D Same as 5, But Not During Year (Only New Depreciation Calc.)
AFACLA Ordinary depreciation classification AFACLA CHAR 1 0
0 No assignment
1 Straight-line depreciation
2 Declining-balance depreciation
3 Other depreciation
AFAMET Depreciation calculation method AFAMET CHAR 1 0
D Percentage from the useful life
G Total percentage in concessionary period
P Stated percentage
M Mean value from several areas
S No. of units/Total no. of units
T No. of units/remaining units
A Sum-of-the-years-digits method of depreciation
U % from remaining life calc. from depr. conversion date
L Deprec. acc. to the present val. portion of leasing install.
J Decl.-bal. (logarithmic) over total life for Japan
K Decl.-bal. (logarithmic) over remaining life for Korea
C Declining multi-phase depreciation CZ
V Immediate depreciation
X Customer-specific method 1
Y Customer-specific method 2
Z Customer-specific method 3
N No automatic calculation
H Stated percentage, half-year depreciation for Japan
1 Country-specific method
2 Country-specific method
3 Country-specific method
4 Country-specific method
5 Country-specific method
6 Country-specific method
7 Country-specific method
8 Country-specific method
9 Country-specific method
XRAFA Do not reduce depreciation in shortened fiscal year XRAFA CHAR 1 0
X Yes
NULL No
MSFAKR Effects of multiple shifts in depreciation key MSFAKR CHAR 1 0
0 Increase in depreciation and expired useful life
1 Increase in deprec., no increase in exp. useful life
2 No effect on depreciation and useful life
SCHROTT Effect of scrap value on the base value AA_SCHROTT NUMC 1 0
0 Consideration is controlled by cutoff value key
1 Base value is reduced by the scrap value amount
2 Base value is not reduced
3 Cutoff value is ignored

T090 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T090 MANDT T090 MANDT T000 Clients MANDT
T090 PERBAB T090 MANDT T090R Period control rules for transactions MANDT
T090 PERBAB T090 PERBAB T090R Period control rules for transactions PERBSL
T090 PERBNA T090 MANDT T090R Period control rules for transactions MANDT
T090 PERBNA T090 PERBNA T090R Period control rules for transactions PERBSL
T090 PERBUM T090 PERBUM T090R Period control rules for transactions PERBSL
T090 PERBUM T090 MANDT T090R Period control rules for transactions MANDT
T090 PERBZU T090 MANDT T090R Period control rules for transactions MANDT
T090 PERBZU T090 PERBZU T090R Period control rules for transactions PERBSL
T090 UMAFSL T090 MANDT T090 Depreciation calculation keys MANDT
T090 UMAFSL T090 UMAFSL T090 Depreciation calculation keys AFARSL