SAP table TXI_T090 (Depreciation calculation keys)

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

TXI_T090 foreign key relationships

Table Field Check Table Check Field
0 TXI_T090 PERBAB T090R Period control rules for transactions MANDT
0 TXI_T090 PERBAB T090R Period control rules for transactions PERBSL
1 TXI_T090 PERBNA T090R Period control rules for transactions MANDT
1 TXI_T090 PERBNA T090R Period control rules for transactions PERBSL
0 TXI_T090 PERBUM T090R Period control rules for transactions MANDT
0 TXI_T090 PERBUM T090R Period control rules for transactions PERBSL
1 TXI_T090 PERBZU T090R Period control rules for transactions MANDT
1 TXI_T090 PERBZU T090R Period control rules for transactions PERBSL
0 TXI_T090 UMAFSL T090 Depreciation calculation keys MANDT
0 TXI_T090 UMAFSL T090 Depreciation calculation keys AFARSL