SAP table T090 (Depreciation calculation keys)

SAP table T090 has 2 primary key fields being MANDT,AFARSL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AFARSL Internal Calculation Key for Depreciation and Interest CHAR 4 0 * AFARSL_OLD
GBEGIN Start of Validity Period CHAR 1 0 GBEGIN
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 CHAR 1 0 AFATYP
N Ord.depreciation
S Special tax depreciation
Z Interest
XAFAUT Automatic Calculation of Depreciation or Interest CHAR 1 0 XAFAUT
DEGFAK Declining-Balance Multiplication Factor DEC 3 2 DEGFAK
MAXPRZ Maximum Percentage Rate DEC 7 4 MAXPRZ
MINPRZ Minimum Percentage Rate DEC 7 4 MINPRZ
UMAFSL Calculation Key After Changeover CHAR 4 0 T090 UMAFSL
UMRPRZ Net Book Value Percentage Rate for Depreciation Changeover DEC 3 1 UMRPRZ
XSTILL Calculate Shutdown CHAR 1 0 XSTILL
XENDAU Depreciation After End of Planned Life CHAR 1 0 XENDAU
XUNTNL Calculation of Depreciation Below Net Book Value Zero CHAR 1 0 XUNTNL
XEFDAU Depreciation with Expired Effective Life CHAR 1 0 XEFDAU
PERBZU Period Control: Acquisition CHAR 2 0 T090R PERBZU
PERBNA Period Control: Acquisition in the Following Year CHAR 2 0 T090R PERBNA
PERBAB Period Control: Retirement CHAR 2 0 T090R PERBAB
PERBUM Period Control : Transfer CHAR 2 0 T090R PERBUM
XDAILY Depreciation Calculation to Exact Day CHAR 1 0 XDAILY
XLIFEC Reduce Useful Life to the End of Fiscal Year CHAR 1 0 XLIFEC
XAFNAH Depreciation Levels by Fiscal Years and Periods CHAR 1 0 XAFNAH
XBZDAT Ind.: Calculate Depreciation from the Asset Value Date CHAR 1 0 XBZDAT
UMSTM Changeover Method CHAR 1 0 UMSTM
0 No automatic changeover
1 Changeover as soon as straight-line depreciation is higher
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 deprec. higher
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)
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.)
X Free for user modification 1
Y Free for user modification 2
Z Free for user modification 3
AFACLA Ordinary Depreciation Classification CHAR 1 0 AFACLA
0 No assignment
1 Straight-line depreciation
2 Declining-balance depreciation
3 Other depreciation
AFAMET Depreciation Calculation Method CHAR 1 0 AFAMET
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
A Sum-of-the-years-digits method of depreciation
B Depreciation from real estate leasing
C Declining multi-phase depreciation CZ
D Percentage from the useful life
G Total percentage in concessionary period
H Stated percentage, half-year depreciation for Japan
J Decl.-bal. (logarithmic) over total life for Japan
K Decl.-bal. (logarithmic) over remaining life for Korea
L Deprec. acc. to the present val. portion of leasing install.
M Mean value from several areas
N No automatic calculation
P Stated percentage
S No. of units/Total no. of units
T No. of units/remaining units
U % from remaining life calc. from depr. conversion date
V Immediate depreciation
X Customer-specific method 1
Y Customer-specific method 2
Z Customer-specific method 3
XRAFA Do not reduce depreciation in shortened fiscal year CHAR 1 0 XRAFA
MSFAKR Effects of multiple shifts in depreciation key CHAR 1 0 MSFAKR
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 NUMC 1 0 AA_SCHROTT
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 Check Table Check Field
0 T090 MANDT T000 Clients MANDT
1 T090 PERBAB T090R Period control rules for transactions MANDT
1 T090 PERBAB T090R Period control rules for transactions PERBSL
0 T090 PERBNA T090R Period control rules for transactions MANDT
0 T090 PERBNA T090R Period control rules for transactions PERBSL
1 T090 PERBUM T090R Period control rules for transactions MANDT
1 T090 PERBUM T090R Period control rules for transactions PERBSL
0 T090 PERBZU T090R Period control rules for transactions MANDT
0 T090 PERBZU T090R Period control rules for transactions PERBSL
1 T090 UMAFSL T090 Depreciation calculation keys MANDT
1 T090 UMAFSL T090 Depreciation calculation keys AFARSL